Optimize SEO Meta Tags in Google Sheets with Google Gemini

🔁 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