n8n Workflow: Technical SEO Audits with GPT-4o Mini & Multi-Format Reporting

This n8n workflow automates the process of performing technical SEO audits for a list of URLs using the GPT-4o Mini model, and then generates multi-format reports (Google Sheets and Email). It's designed to streamline the analysis of website technical health and deliver actionable insights.

What it does

This workflow performs the following key steps:

1. Triggers Manually or via Webhook: The workflow can be initiated manually or by sending a POST request to its webhook URL.
2. Reads URLs from Google Sheets: It fetches a list of URLs from a specified Google Sheet.
3. Loops Over URLs: Each URL from the Google Sheet is processed individually in batches.
4. Fetches URL Content: For each URL, it makes an HTTP request to retrieve the HTML content of the page.
5. Extracts Clean Text from HTML: The HTML content is then parsed to extract clean, readable text, removing HTML tags and other non-content elements.
6. Generates Technical SEO Audit with OpenAI (GPT-4o Mini): The extracted text content is sent to the OpenAI GPT-4o Mini model, prompting it to perform a technical SEO audit and provide recommendations.
7. Formats Audit Results: The raw audit results from OpenAI are processed and formatted into a structured JSON object.
8. Appends Results to Google Sheets: The structured SEO audit results for each URL are appended as new rows to a designated Google Sheet.
9. Sends Email Report: A summary or detailed report of the audit findings is compiled and sent via Gmail to a specified recipient.
10. Handles Errors: If any critical error occurs during the process, the workflow stops and reports the error.
11. Responds to Webhook: If triggered by a webhook, it sends a response back upon completion.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (self-hosted or cloud).
• Google Account: A Google account with access to Google Sheets for input URLs and output reports. You will need to set up a Google Sheets credential in n8n.
• OpenAI API Key: An OpenAI API key with access to the GPT-4o Mini model. You will need to set up an OpenAI credential in n8n.
• Gmail Account: A Gmail account for sending email reports. You will need to set up a Gmail credential in n8n.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON.
2. Configure Credentials:
   • Locate the "Google Sheets", "OpenAI", and "Gmail" nodes.
   • Click on each node and configure the respective credentials. If you don't have them set up, n8n will guide you through creating new credentials for each service.
3. Specify Google Sheet Details:
   • In the "Google Sheets" node that reads URLs, specify the Spreadsheet ID and Sheet Name where your input URLs are located. Ensure your URLs are in a column that can be easily referenced.
   • In the "Google Sheets" node that appends results, specify the Spreadsheet ID and Sheet Name where you want the audit results to be written.
4. Configure OpenAI Prompt:
   • In the "OpenAI" node, review and adjust the prompt to GPT-4o Mini as needed to refine the technical SEO audit.
5. Configure Gmail Recipient and Content:
   • In the "Gmail" node, specify the recipient email address, subject, and customize the email body using data from the workflow.
6. Activate the Workflow:
   • Once all credentials and configurations are set, activate the workflow by toggling the "Active" switch in the top right corner.
7. Run the Workflow:
   • Manual Trigger: Click "Execute Workflow" to run it manually.
   • Webhook Trigger: Copy the webhook URL from the "Webhook" node and send a POST request to it to trigger the workflow programmatically.

This workflow provides a powerful, automated solution for ongoing technical SEO monitoring and reporting, leveraging the capabilities of AI to deliver insightful audits.