Optimize SEO Meta Tags in Google Sheets with Google Gemini

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