Create SEO-optimised content from Google Sheets keywords with DataForSEO and Ollama
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - MongoDB Chat Memory
@n8n/n8n-nodes-langchain.memoryMongoDbChat - Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent
What it does
This workflow creates content for your primary keywords in a Google Sheet by using SERP data and natural language skills of LLMs to create content at scale. Steps: 1) Fetch Rows from a Google Sheet with keywords in Column 'Keyword' 2) Use DataforSEO API (or any other SERP API) to fetch top results, AI Overview, related searches, PAA, etc., and compile them for a prompt. 3) Feed the SERP Data and SEO Guidelines to an AI Agent with a locally run LLM Model (to save cost) to create the content. 4) Add the data in the same Google Sheet in the column header 'Output'.