Create SEO-optimised content from Google Sheets keywords with DataForSEO and Ollama

Go to Workflow
0 views
Built by Shivang Shivang
Created on June 11, 2026

Description

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'.



Nodes Used (6)

AI Agent
@n8n/n8n-nodes-langchain.agent
Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
MongoDB Chat Memory
@n8n/n8n-nodes-langchain.memoryMongoDbChat
Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama