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

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