Daily SEO Audit Workflow with HTML Reports via Gmail/Slack

This n8n workflow automates the process of performing a daily SEO audit and generating an HTML report. It then sends this report via Gmail or Slack, providing a convenient way to stay updated on key SEO metrics.

What it does

This workflow performs the following steps:

1. Triggers Daily: The workflow is scheduled to run daily, ensuring regular SEO audits.
2. Performs HTTP Request: It makes an HTTP request to an external API (likely an SEO tool or custom script) to retrieve SEO-related data.
3. Processes Data: The retrieved data is then processed and transformed using a "Code" node, which likely extracts relevant information or formats it for reporting.
4. Edits Fields: A "Set" node is used to further refine and prepare the data, potentially adding or modifying fields for the report.
5. Generates HTML Report: An "HTML" node takes the processed data and generates a structured HTML report, making the information easy to read and digest.
6. Sends Report via Gmail: The generated HTML report is then sent as an email via Gmail.

Prerequisites/Requirements

To use this workflow, you will need:

• An n8n instance: Self-hosted or cloud.
• Gmail Account: For sending email reports. You'll need to configure a Gmail credential in n8n.
• An external SEO API/service: The workflow makes an HTTP request, so you'll need access to an API that provides the SEO data you wish to audit. The specific endpoint and authentication details will need to be configured in the "HTTP Request" node.
• Basic JavaScript knowledge: For customizing the "Code" node if you need to adjust data processing.

Setup/Usage

1. Import the workflow: Download the JSON definition and import it into your n8n instance.
2. Configure Credentials:
   • Gmail: Set up a Gmail OAuth2 credential in n8n.
3. Configure HTTP Request Node:
   • Update the URL, headers, and any authentication details for your SEO API in the "HTTP Request" node.
4. Customize Code Node:
   • Review and modify the JavaScript code in the "Code" node to match the structure of the data returned by your SEO API and to extract the specific metrics you want in your report.
5. Configure Edit Fields (Set) Node:
   • Adjust the fields being set or transformed to ensure the data is in the correct format for your HTML report.
6. Customize HTML Node:
   • Modify the HTML template within the "HTML" node to design your report layout and display the extracted SEO data as desired.
7. Configure Gmail Node:
   • Specify the recipient email address(es), subject, and ensure the HTML report is attached or embedded in the email body.
8. Activate the workflow: Once configured, activate the "Schedule Trigger" node to enable daily execution.