Back to Templates
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.