Generate SEO-Optimized Titles & Meta Descriptions with Bright Data & Gemini AI

This n8n workflow automates the process of generating SEO-optimized titles and meta descriptions for a list of keywords using Bright Data for SERP scraping and Google Gemini AI for content generation. It streamlines content creation by leveraging AI to produce high-quality, relevant SEO metadata.

What it does

This workflow performs the following steps:

1. Triggers Manually: The workflow is initiated manually by clicking "Execute workflow".
2. Loads Keywords from Google Sheets: It reads a list of keywords from a specified Google Sheet.
3. Prepares Data for AI Processing: It transforms the input data to include a prompt for the AI agent, instructing it to generate SEO-optimized titles and meta descriptions for each keyword.
4. Loops Over Keywords: Each keyword is processed individually in a loop.
5. Scrapes SERP Data with Bright Data: For each keyword, it makes an HTTP request to the Bright Data SERP API to fetch real-time search engine results.
6. Generates SEO Metadata with Google Gemini AI: It utilizes a Google Gemini Chat Model within an AI Agent to analyze the SERP data and the keyword, then generates a unique, SEO-optimized title and meta description. A Structured Output Parser ensures the AI's output is consistently formatted as JSON.
7. Saves Results to Google Sheets: The generated titles and meta descriptions, along with the original keyword, are written back to a Google Sheet.

Prerequisites/Requirements

• n8n Instance: A running instance of n8n.
• Google Sheets Account: To store input keywords and output SEO metadata.
  • Google Sheets Credential: An n8n credential configured for Google Sheets access.
• Bright Data Account: To access the SERP API.
  • Bright Data API Key: An n8n credential configured for Bright Data.
• Google Gemini AI (Google Cloud): To use the Gemini Chat Model.
  • Google Gemini API Key: An n8n credential configured for Google Gemini.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Locate the "Google Sheets" node and update its "Credential" to your Google Sheets account.
   • Locate the "HTTP Request" node (for Bright Data) and update its "Credential" to your Bright Data API key.
   • Locate the "Google Gemini Chat Model" node and update its "Credential" to your Google Gemini API key.
3. Prepare your Google Sheet:
   • Create a Google Sheet with a column for your keywords (e.g., named "Keyword").
   • Note the Spreadsheet ID and Sheet Name for configuration in the "Google Sheets" nodes.
4. Configure Google Sheets Nodes:
   • In the first "Google Sheets" node ("Google Sheets"), set the "Spreadsheet ID" and "Sheet Name" to read your input keywords.
   • In the second "Google Sheets" node ("Google Sheets1"), set the "Spreadsheet ID" and "Sheet Name" to write the generated titles and meta descriptions. Ensure the sheet has columns for "Keyword", "SEO Title", and "Meta Description".
5. Configure Bright Data HTTP Request:
   • Ensure the "HTTP Request" node is correctly configured to call the Bright Data SERP API with the necessary parameters (e.g., url, method, headers, body). The current setup expects a POST request to https://api.brightdata.com/dca/trigger with a JSON body containing the url (the search query).
6. Configure AI Agent and Output Parser:
   • Review the prompt in the "Edit Fields" node to ensure it aligns with your desired SEO title and meta description generation criteria.
   • The "Structured Output Parser" is configured to expect a JSON output with seo_title and meta_description fields. Adjust if your AI prompt or desired output structure changes.
7. Activate and Execute:
   • Save the workflow.
   • Click "Execute Workflow" to run it manually. The workflow will process each keyword, scrape SERP data, generate SEO content, and update your Google Sheet.