Back to Templates

Optimize SEO Meta Tags in Google Sheets with Google Gemini

Last update

Last update 2 days ago

Share


🔁 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