Generate SEO meta tags with Gemini AI & competitor analysis using Google Sheets
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.
What this workflow does
This AI workflow has 19 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets and Google Gemini Chat Model. It also calls api.scrapingdog.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Update row in sheet (Google Sheets): update
- Scrape Website (HTTP Request): calls api.scrapingdog.com
- HTML: parses or builds HTML
- Edit Fields (Edit Fields (Set)): sets 2 fields: current_title, description
- AI Analyzer (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Googl SERP (HTTP Request): calls an HTTP API
- Code: runs custom JavaScript code
- Competitor Analysis (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: api.scrapingdog.com
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTML
n8n-nodes-base.html - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
From the author
This workflow automates the entire process of creating SEO-optimized meta titles and descriptions. It analyzes your webpage, spies on top-ranking competitors for the same keywords, and then uses a multi-step AI process to generate compelling,…