Optimize SEO meta tags in Google Sheets with Google Gemini
Needs changesWhat this workflow does
This AI workflow has 10 nodes and runs on a schedule (every day). Along the way it connects Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: On a schedule (every day).
- get-current-tags (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- format-code (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- save-output (Google Sheets): update
- update-tags (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- turn-into-table (Code): runs custom JavaScript code
- Aggregate: combines items into one
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in update-tags (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) update-tags (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Aggregate
n8n-nodes-base.aggregate - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code
From the author
🔁 Loop & Optimize Meta Tags with Google Gemini This workflow automates the shortening of meta titles and descriptions for SEO—directly from your Google Sheet, row by row, using Google Gemini. ✅ What it does - Reads rows from a Google Sheet (metatitle,…