Weekly SEO Watchlist Audit to Google Sheets with Gemini and Decodo

This n8n workflow automates the process of auditing a weekly SEO watchlist, leveraging Google Gemini for content analysis, and then recording the audit results in a Google Sheet. It's designed to help SEO professionals and content managers keep track of their target URLs and ensure their content remains optimized.

What it does

This workflow streamlines your SEO monitoring by performing the following steps:

1. Triggers Weekly: The workflow is scheduled to run automatically on a weekly basis.
2. Fetches Watchlist URLs: It reads a list of URLs from a specified Google Sheet, which serves as your SEO watchlist.
3. Processes URLs in Batches: To manage API limits and processing efficiency, the URLs are processed in batches.
4. Audits Each URL with Gemini: For each URL in a batch, it uses a custom Code node to fetch the content. This content is then passed to a Google Gemini Chat Model via a Basic LLM Chain to perform an SEO audit. The audit prompts Gemini to analyze the content for relevance, keywords, structure, and other SEO factors, and to provide suggestions for improvement.
5. Parses Gemini's Output: The structured output from Gemini's analysis is parsed to extract key insights and recommendations.
6. Formats Audit Results: The extracted audit results are formatted into a consistent structure.
7. Appends Results to Google Sheet: Finally, the detailed SEO audit results, including Gemini's analysis and recommendations, are appended as new rows to a designated Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• Google Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential configured for Google Sheets to read from and write to your spreadsheets.
• Google Gemini API Key: An API key for Google Gemini (or a similar large language model) to power the content analysis. This will be configured within the "Google Gemini Chat Model" node.
• Decodo (or similar web scraping tool/library): The "Code" node implies a mechanism to fetch web content from the URLs. While not explicitly defined in the JSON, a custom script within the Code node would likely use a library or service like Decodo (as hinted by the directory name) or a simple HTTP request to scrape the content.

Setup/Usage

1. Import the Workflow:

   • Download the provided JSON file.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the JSON content or upload the file.

2. Configure Credentials:

   • Google Sheets: Locate the "Google Sheets" node. Click on it and select or create a new "Google Sheets" credential. Ensure it has access to the spreadsheet where your watchlist is stored and where the audit results will be written.
   • Google Gemini: Locate the "Google Gemini Chat Model" node. Configure your Google Gemini API key within its settings.

3. Specify Google Sheets:

   • Watchlist Sheet: In the initial "Google Sheets" node (the one reading data), specify the "Spreadsheet ID" and "Sheet Name" where your SEO watchlist URLs are located. Ensure each URL is in a column that can be easily referenced.
   • Audit Results Sheet: In the final "Google Sheets" node (the one writing data), specify the "Spreadsheet ID" and "Sheet Name" where the audit results should be appended.

4. Customize Content Fetching (Code Node):

   • Open the "Code" node. This node is responsible for fetching the content of each URL. You will need to customize the JavaScript code within this node to correctly scrape the content from the URLs. This might involve using an HTTP Request node internally or a custom library/API.
   • Important: The current JSON does not include the actual code for content fetching. You will need to add the logic to retrieve the webpage content for each URL.

5. Customize Gemini Prompt (Basic LLM Chain):

   • Open the "Basic LLM Chain" node.
   • Review and adjust the prompt provided to Google Gemini to tailor the SEO audit to your specific needs. For example, you might want to focus on specific keywords, content length, readability, or technical SEO aspects.

6. Activate the Workflow:

   • Once all credentials and configurations are set, enable the workflow by toggling the "Active" switch in the top right corner of the workflow editor.
   • The "Schedule Trigger" node is configured to run weekly, but you can manually execute the workflow for testing purposes by clicking "Execute Workflow".