π¬ Optimize SEO meta tags in Google Sheets with Google Gemini
β‘ 1,223 views Β· π¬ Content Creation & Video
Description
π 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 (meta_title, meta_description, row_index)
- Loops through each row and checks if content exists
- Sends the data to Google Gemini for length-optimized output
- Cleans and parses the response
- Updates the original sheet with the shortened results
π οΈ Setup Requirements
- Google Sheets (OAuth2 credentials connected in n8n)
- Google Gemini API key (configured in n8n credentials)
Sheet must contain:
- row_index
- meta_title
- meta_description
Output will be written into:
- meta_titleFixed
- meta_descriptionFixed
π Nodes Used
Google Sheets, Schedule Trigger, AI Agent, Google Gemini Chat Model
π₯ Import
Download workflow.json and import into n8n:
Workflow menu β Import from File