{"product_id":"n8n-weekly-seo-blog-automation-sheets-gemini-sanity","title":"n8n Weekly SEO Blog Automation: Sheets + Gemini + Sanity","description":"\u003ch3\u003eTurn one keyword list into a published SEO blog—automatically, every week\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your focus keywords from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, finds rising search opportunities with \u003cstrong\u003eGoogle Trends (via SerpApi)\u003c\/strong\u003e, validates demand using \u003cstrong\u003eAhrefs metrics (via RapidAPI)\u003c\/strong\u003e, then has \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e generate and publish a complete SEO article to \u003cstrong\u003eSanity CMS\u003c\/strong\u003e—including AI-generated images and strategic internal\/external linking.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly scheduled automation:\u003c\/strong\u003e Runs on a weekly schedule and pulls focus keywords from a Google Sheets spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFind rising related queries:\u003c\/strong\u003e For each focus keyword, it queries Google Trends via \u003cstrong\u003eSerpApi\u003c\/strong\u003e, keeps only queries that match your focus keyword list, and filters to relevant options.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidate search demand:\u003c\/strong\u003e Retrieves keyword metrics from \u003cstrong\u003eAhrefs (via RapidAPI)\u003c\/strong\u003e, removes entries with missing\/zero search volume or difficulty, sorts by volume, and selects the top candidate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResearch + write with Gemini:\u003c\/strong\u003e Uses a \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e-powered agent to perform Google Search research (via SerpApi) and outputs a structured JSON article (title, slug, excerpt, and markdown body).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublish to Sanity:\u003c\/strong\u003e Converts the JSON into a Sanity “post” document, normalizes body content, assigns author\/categories, and creates the post using the \u003cstrong\u003eSanity Data API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLinking pass:\u003c\/strong\u003e Uses Gemini to add a small set of relevant \u003cstrong\u003einternal links\u003c\/strong\u003e to other Sanity posts and a limited set of authoritative \u003cstrong\u003eexternal links\u003c\/strong\u003e, then patches the updated body back into Sanity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI image generation:\u003c\/strong\u003e Creates three image prompts, renders images with \u003cstrong\u003eCloudflare Workers AI (Flux)\u003c\/strong\u003e, uploads them as Sanity assets, and patches hero\/inline images into the published post.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS marketing teams maintaining consistent SEO publishing without manual writing.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers integrating Sheets-driven SEO pipelines into \u003cstrong\u003eSanity CMS\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOperations teams wanting repeatable keyword-to-content workflows using Ahrefs + Gemini.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling \u0026amp; logic:\u003c\/strong\u003e if, set, code, sort, wait, limit\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData sources \u0026amp; APIs:\u003c\/strong\u003e Google Sheets, SerpApi (Google Trends + Google Search research), Ahrefs via RapidAPI\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI + publishing:\u003c\/strong\u003e Google Gemini, Sanity Data API, Cloudflare Workers AI (Flux) for images\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741404356787,"sku":"N8N-17623","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YU0c9SygCV3JZ2KZCYWsO_0Zht3O52.png?v=1785315630","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-seo-blog-automation-sheets-gemini-sanity","provider":"N8N Commerce","version":"1.0","type":"link"}