Generate SEO Meta Tags with Gemini AI & Competitor Analysis using Google Sheets

This workflow automates the entire process of creating SEO-optimized meta titles and descriptions. It analyzes your webpage, spies on top-ranking competitors for the same keywords, and then uses a multi-step AI process to generate compelling, length-constrained meta tags.

🤖 How It Works This workflow operates in a three-phase process for each URL you provide:

Phase 1: Self-Analysis

When you add a URL to a Google Sheet with the status "New", the workflow scrapes your page's content.

The first AI then performs a deep analysis to identify the page's primary keyword, semantic keyword cluster, search intent, and target audience.

Phase 2: Competitor Intelligence

The workflow takes your primary keyword and performs a live Google search.

A custom code block intelligently filters the search results to identify true competitors.

A second AI analyzes their meta titles and descriptions to find common patterns and successful strategies.

Phase 3: Master Generation & Update

The final AI synthesizes all gathered intelligence—your page's data and the competitor's winning patterns—to generate a new, optimized meta title and description.

It then writes this new data back to your Google Sheet and updates the status to "Generated".

⚙️ Setup Instructions You should be able to set up this workflow in about 10-15 minutes ⏱️.

🔑 Prerequisites You will need the following accounts and API keys:

A Google Account with access to Google Sheets.

A Google AI / Gemini API key.

A SerpApi key for Google search data.

A ScrapingDog API key for reliable website scraping.

🛠️ Configuration Google Sheet Setup: Create a new Google Sheet. The workflow requires the following columns: URL, Status, Current Meta Title, Current Meta Description, Generated Meta Title, Generated Meta Description, and Ranking Factor.

Add Credentials:

Google Sheets Nodes: Connect your Google account credentials to the Google Sheets Trigger & Google Sheets nodes.

Google Gemini Nodes: Add your Google Gemini API key to the credentials for all three Google Gemini Chat Model nodes.

Scrape Website Node: In this HTTP Request node, go to Query Parameters and replace <your-api-key> with your ScrapingDog API key.

Googl SERP Node: In this HTTP Request node, go to Query Parameters and replace <your-api-key> with your SerpApi API key.

Configure Google Sheets Nodes:

Copy the Document ID from your Google Sheet's URL.

Paste this ID into the "Document ID" field in the following nodes: Google Sheets Trigger, Get row(s) in sheet1, and Update row in sheet.

In each of those nodes, select the correct sheet name from the "Sheet Name" dropdown.

✅ Activate Workflow Save and activate the workflow. To run it, simply add a new row to your Google Sheet containing the URL you want to process and set the "Status" column to New.