Create weekly SEO blog posts from Google Sheets with Gemini and Sanity

by Vinsen · 29 views · created 2026-07-29 · Content Creation, Multimodal AI

What this workflow does

This AI workflow has 27 nodes and runs on a schedule (every 6 days). Along the way it connects Google Gemini Chat Model, Google Sheets and HTTP Request. It also calls serpapi.com, ahrefs-keyword-research.p.rapidapi.com and generativelanguage.googleapis.com over HTTP.

How it runs

Trigger: On a schedule (every 6 days).

1. List Focus Keyword (Google Sheets): uses Google Sheets
2. Riset Google Trends (HTTP Request): calls serpapi.com
3. Rising Topic (Split Out): splits a list into separate items
4. Keyword Match? (If): checks a condition and branches into true / false
5. Riset SVolume (HTTP Request): calls ahrefs-keyword-research.p.rapidapi.com
6. If: checks a condition and branches into true / false
7. Sort: sorts the items
8. Limit: keeps the first few items
9. AI Agent: runs an AI agent, with model: Create Article; 1 tool (Google Search Riset)
10. Wait: waits 10 seconds

…plus 14 more steps. See the full node list below.

Services it uses

Google Gemini Chat ModelGoogle SheetsHTTP Request

HTTP calls to: serpapi.com, ahrefs-keyword-research.p.rapidapi.com, generativelanguage.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (14)

• AI Agent@n8n/n8n-nodes-langchain.agent
• HTTP Requestn8n-nodes-base.httpRequest
• Split Outn8n-nodes-base.splitOut
• Ifn8n-nodes-base.if
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Coden8n-nodes-base.code
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Waitn8n-nodes-base.wait
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Edit Fields (Set)n8n-nodes-base.set
• Http Request Tooln8n-nodes-base.httpRequestTool
• Sortn8n-nodes-base.sort
• Limitn8n-nodes-base.limit

From the author

Quick overview This scheduled workflow pulls focus keywords from Google Sheets, expands them with rising Google Trends queries via SerpApi, validates demand with Ahrefs metrics on RapidAPI, then uses Google Gemini to write and publish an SEO article to Sanity…

View the original on n8n.io → Check your own copy