AutomationMart
Home/Browse/Generate SEO meta tags with Gemini AI & competitor analysis using Google Sheets
n8n

Generate SEO meta tags with Gemini AI & competitor analysis using Google Sheets

n8nn8n19 modulesv1.0
Google SheetsGemini

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

At a glance

Generate SEO meta tags with Gemini AI & competitor analysis using Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Gemini
Modules
19
Price
Free
Version
v1.0
Generate SEO meta tags with Gemini AI & competitor analysis using Google Sheets workflow diagram

About this workflow

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Export Dext clients to a Google Sheets spreadsheet

Use this template to automatically export your Dext clients to a Google Sheets spreadsheet. The template is scheduled to run every day at 10:00 AM. You can change the schedule after you set up the template by clicking the clock icon on the first module.

Free

Add new rows to a Google Sheets spreadsheet for new Userback feedback

Every time there is a new feedback created via Userback, Make will automatically create a new row in a Google Sheets spreadsheet of your choice. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1e4mpXCyJ0MzPeuJOe8u7nQC5taXKK50R15BAigrMq38/edit?usp=sharing).

Free

Upload a new member from Status Hero into Google Sheets

Make lists members in Status Hero and checks whether all members exist in Google Sheets. If not, a new row with the missing (new) member's data is added in Google Sheets. By this way the list of members in Google Sheets is kept up to date. In this template is used [this](https://docs.google.com/spreadsheets/d/1K8YOYylTFlrRdeopyVBN7R4hjrhnYOJTBX9DAxthl9U/edit?usp=sharing) Spread Sheet.

Free

Add new leads to Myphoner for new Google Sheets spreadsheet rows

Make will watch your specified Google Sheets spreadsheet for new rows at regular intervals and create new leads in Myphoner.

Free

Transform images with AI prompts using FLUX Kontext, Google Sheets and Drive

This workflow automates the generation of AI-enhanced, contextualized images using FLUX Kontext, based on prompts stored in a Google Sheet. The generated images are then saved to Google Drive, and their URLs are written back to the spreadsheet for easy access. --- Example Image: Prompt: The girl is lying on the bed and sleeping Result: ---

Free

Find high-intent sales leads by scraping Glassdoor with Bright Data & GPT

Scrape Glassdoor with Bright Data Designed for sales teams, recruiters, and marketers aiming to automate job discovery and prospecting. This workflow scrapes Glassdoor job listings using Bright Data and automatically generates targeted pitches using AI, streamlining lead identification and outreach. --- đź§© How It Works This automation leverages n8n, Bright Data, Google Sheets, and OpenAI: 1. Trigger - Starts with a custom form input (Location, Keyword, Country). 2. Bright Data Job Scrape - Trigge

Free

Automated phone receptionist for scheduling with Twilio, ElevenLabs & Claude AI

Schedule appointments from phone calls with AI using Twilio and ElevenLabs This n8n template creates an intelligent phone receptionist that handles incoming calls, answers FAQs, and schedules appointments to Google Calendar. The system uses Twilio for phone handling, ElevenLabs for voice AI and basic conversations, and n8n for complex scheduling logic—keeping responses snappy by only invoking the workflow when calendar operations are needed. Who's it for Businesses that need automated

Free

Automated law firm lead management & scheduling with AI, Jotform & Calendar

Youtube Explanation: This n8n workflow is designed to automate the initial intake and scheduling for a law firm. It's split into two main parts: 1. New Inquiry Handling: Kicks off when a potential client fills out a JotForm, saves their data, and sends them an initial welcome message on WhatsApp. 2. Appointment Scheduling: Activates when the client replies on WhatsApp, allowing an AI agent to chat with them to schedule a c

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free