Skip to main content

Optimize SEO meta tags in Google Sheets with Google Gemini

Workflow preview

Optimize SEO meta tags in Google Sheets with Google Gemini preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

πŸ” 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