n8n Weekly SEO Blog Automation: Sheets + Gemini + Sanity

Turn one keyword list into a published SEO blog—automatically, every week

This n8n workflow reads your focus keywords from Google Sheets, finds rising search opportunities with Google Trends (via SerpApi), validates demand using Ahrefs metrics (via RapidAPI), then has Google Gemini generate and publish a complete SEO article to Sanity CMS—including AI-generated images and strategic internal/external linking.

What this workflow does

• Weekly scheduled automation: Runs on a weekly schedule and pulls focus keywords from a Google Sheets spreadsheet.
• Find rising related queries: For each focus keyword, it queries Google Trends via SerpApi, keeps only queries that match your focus keyword list, and filters to relevant options.
• Validate search demand: Retrieves keyword metrics from Ahrefs (via RapidAPI), removes entries with missing/zero search volume or difficulty, sorts by volume, and selects the top candidate.
• Research + write with Gemini: Uses a Google Gemini-powered agent to perform Google Search research (via SerpApi) and outputs a structured JSON article (title, slug, excerpt, and markdown body).
• Publish to Sanity: Converts the JSON into a Sanity “post” document, normalizes body content, assigns author/categories, and creates the post using the Sanity Data API.
• Linking pass: Uses Gemini to add a small set of relevant internal links to other Sanity posts and a limited set of authoritative external links, then patches the updated body back into Sanity.
• AI image generation: Creates three image prompts, renders images with Cloudflare Workers AI (Flux), uploads them as Sanity assets, and patches hero/inline images into the published post.

Use cases

• SaaS marketing teams maintaining consistent SEO publishing without manual writing.
• Automation engineers integrating Sheets-driven SEO pipelines into Sanity CMS.
• Operations teams wanting repeatable keyword-to-content workflows using Ahrefs + Gemini.

Technical details

• Scheduling & logic: if, set, code, sort, wait, limit
• Data sources & APIs: Google Sheets, SerpApi (Google Trends + Google Search research), Ahrefs via RapidAPI
• AI + publishing: Google Gemini, Sanity Data API, Cloudflare Workers AI (Flux) for images