SEO Helper by D4 

SEO Helper by D4 is a powerful Google Sheets add-on that automates SEO workflows using Gemini and Claude AI APIs.

SEO Data Collection Automatically collect Title, Meta Description, H1 and H2-H6 headings from any URL. Analyze keyword gaps between your page and competitors.

Content Analysis Extract main page text, build H2-H6 structure from competitor headings, and analyze word frequency with unigrams, bigrams and trigrams across multiple texts.

AI Writing Tools Write SEO texts based on headings structure and keyword requirements. Improve existing texts to match keyword frequency targets. Format text to HTML. Translate content into Ukrainian, Russian, English, German and Bulgarian.

Text Analysis Summarize texts with AI, create merged summaries across multiple analyses, compare text analyses to find content gaps and improvement opportunities.

Keyword & URL Tools Build word lists with checkbox filtering, classify search queries into categories automatically, count and deduplicate URLs, clean Google tracking parameters from URLs.

Check word frequency in text against target values with color-coded results — green for exact match, red for too few, yellow for too many.

Supports Ukrainian, Russian and English content.