Create SEO-optimised content from Google Sheets keywords with DataForSEO and Ollama
Go to Workflow
Shivang
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'.
This workflow was created by Shivang and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.