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 (metatitle, metadescription, rowindex) - 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: - rowindex - metatitle - metadescription

Output will be written into: - metatitleFixed - metadescriptionFixed