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

This n8n workflow automates the generation of SEO meta tags (title and description) for your products or services. It leverages Google Gemini AI for intelligent content creation and integrates with Google Sheets for both input (competitor data) and output (generated meta tags). Additionally, it performs basic competitor analysis by extracting existing meta tags from competitor URLs.

What it does

1. Triggers on Google Sheet Updates: The workflow starts whenever a new row is added or an existing row is updated in a specified Google Sheet. This sheet is expected to contain competitor URLs.
2. Extracts Competitor Meta Tags: For each URL provided in the Google Sheet, it makes an HTTP request to fetch the webpage content.
3. Parses HTML for Meta Information: It then uses an HTML node to extract the existing meta title and meta description from the competitor's webpage.
4. Prepares Data for AI Generation: The extracted competitor meta tags are combined with input from the Google Sheet (e.g., product name, keywords) to form a comprehensive prompt for the AI.
5. Generates New Meta Tags with Gemini AI: It utilizes the Google Gemini Chat Model via a Basic LLM Chain to generate new, optimized SEO meta titles and descriptions based on the provided context and competitor analysis.
6. Structures AI Output: A Structured Output Parser ensures the AI's response is consistently formatted into distinct meta title and meta description fields.
7. Updates Google Sheet: Finally, the newly generated meta tags are written back to the original Google Sheet, enriching your data with AI-powered SEO content.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google account with access to Google Sheets.
  • Google Sheets Credential: An n8n credential configured for Google Sheets (OAuth 2.0).
• Google Gemini API Key: Access to the Google Gemini API.
  • Google Gemini Credential: An n8n credential configured for Google Gemini.
• Competitor Data Google Sheet: A Google Sheet set up with at least a column for "Competitor URL" to trigger the workflow and receive the generated meta tags.

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 three dots in the top right corner and select "Import from JSON".
   • Paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Google Sheets Trigger & Node:
     • Click on the "Google Sheets Trigger" node and the "Google Sheets" node.
     • Select or create a new Google Sheets OAuth2 credential. Ensure it has access to your Google Drive and Sheets.
     • Specify the "Spreadsheet ID" and "Sheet Name" for your competitor data.
   • Google Gemini Chat Model:
     • Click on the "Google Gemini Chat Model" node.
     • Select or create a new Google Gemini credential, providing your API key.
3. Configure Nodes:
   • Google Sheets Trigger:
     • Set the "Trigger On" option to "New Row" or "Updated Row" depending on your use case.
     • Ensure the "Spreadsheet ID" and "Sheet Name" match your input sheet.
   • HTTP Request: This node is pre-configured to fetch the URL from the Google Sheet. No specific changes should be needed unless you want to customize headers or other request parameters.
   • HTML: This node is pre-configured to extract meta title and description. Review the CSS selectors if your target websites have unusual HTML structures.
   • Edit Fields (Set): This node prepares the data for the AI. Ensure the fields being set (productName, keywords, competitorMetaTitle, competitorMetaDescription) correctly map to your Google Sheet columns and the output from the HTML node.
   • Basic LLM Chain: This node orchestrates the prompt for Gemini. Review the prompt template to ensure it aligns with your desired meta tag generation strategy.
   • Structured Output Parser: This node expects the AI output to be in a specific JSON format. Ensure the prompt in the "Basic LLM Chain" node guides Gemini to produce output that this parser can understand (e.g., { "metaTitle": "...", "metaDescription": "..." }).
   • Google Sheets (Write Output):
     • Ensure the "Spreadsheet ID" and "Sheet Name" match your output sheet (likely the same as the input sheet).
     • Map the generated metaTitle and metaDescription fields to the appropriate columns in your Google Sheet.
4. Activate the Workflow: Once all credentials and nodes are configured, activate the workflow. It will now automatically process new or updated rows in your specified Google Sheet.

This workflow provides a powerful foundation for automating SEO meta tag generation, combining competitor insights with advanced AI capabilities.