Optimize SEO Meta Tags in Google Sheets with Google Gemini

This n8n workflow streamlines SEO optimization by reading meta_title, meta_description, and row_index columns from a Google Sheet. It loops through each row, skipping empty content via conditional logic, and sends the data to Google Gemini for generating concise, SEO-friendly versions that fit search engine limits.

Key features include automated scheduling, response parsing for clean output, and direct updates to new columns (meta_titleFixed, meta_descriptionFixed) in the original sheet. This eliminates manual editing, ensuring consistency and saving hours on bulk optimizations.

Ideal for marketers managing large content libraries, e-commerce sites, or blogs. Benefits include improved click-through rates from better meta tags, scalable processing without coding, and easy setup with OAuth2 for Sheets and API key for Gemini. Use cases: Pre-launch site audits, post-migration fixes, or ongoing content refreshes.