How to automate blog SEO audits with Sitebulb and ChatGPT API

Hey there! If you’re looking to automate your blog’s SEO audits and generate actionable reports, you’re in the right place. In this guide, I’ll walk you through setting up a system using Sitebulb and the ChatGPT API. We’ll use Make (formerly Integromat) to connect these tools seamlessly. Let’s dive in!

Introduction

Maintaining a blog’s SEO health is crucial, but manual audits can be time-consuming. By automating this process, you can ensure regular checks and receive actionable insights without lifting a finger. We’ll set up a workflow that:

• Runs scheduled SEO audits using Sitebulb.
• Exports audit data to Google Sheets.
• Processes the data with ChatGPT API to generate fix-it reports.
• Sends the reports to your email.

Estimated setup time: 2 hours.

Step-by-Step Guide

Step 1: Set Up Sitebulb for Scheduled Audits

First, let’s configure Sitebulb to perform regular SEO audits.

1. Install Sitebulb: If you haven’t already, download and install Sitebulb from their official website.
2. Create a New Project: Open Sitebulb and click on “New Project.” Enter your blog’s URL and project name.
3. Configure Audit Settings: In the audit setup:
   • Enable “Scheduled Audits” and set the frequency (e.g., weekly).
   • Under “Audit Data,” select the data points you want to collect. For a comprehensive audit, include SEO, Page Resources, Performance, Structured Data, and Security.
   • In “Crawler Settings,” ensure the Chrome Crawler is selected for accurate performance analysis.
4. Set Up Email Notifications: In the “Crawler Settings,” enable email notifications to receive alerts when audits are complete. Enter your email address.
5. Automate Exports to Google Sheets: In the “Sheets Exports” section:
   • Enable the option and connect your Google account.
   • Select the data you want to export, such as “Audit Summary” and “All Hints.”
6. Start the Audit: Click “Start Now” to initiate the first audit. Sitebulb will now run audits as per the schedule and export data to Google Sheets upon completion.

For more details on setting up scheduled audits and exporting to Google Sheets, refer to Sitebulb’s documentation. ([sitebulb.com](https://sitebulb.com/documentation/website-audit-workflows/setting-scheduled-or-recurring-website-audits/?utm_source=openai))

Step 2: Set Up Make to Process Audit Data

Next, we’ll use Make to automate the processing of audit data and generate fix-it reports.

1. Create a Make Account: Sign up for a free account at Make’s website.
2. Create a New Scenario: In your Make dashboard, click on “Create a new scenario.”
3. Add Google Sheets Module:
   • Search for and add the “Google Sheets” module.
   • Select “Watch Rows” as the trigger.
   • Connect your Google account and select the spreadsheet where Sitebulb exports the audit data.
   • Set the trigger to watch for new rows in the “All Hints” sheet.
4. Add ChatGPT API Module:
   • Search for and add the “HTTP” module.
   • Select “Make a request” as the action.
   • Configure the module:
     • Method: POST
     • URL: https://api.openai.com/v1/engines/davinci-codex/completions
     • Headers:
       • Authorization: Bearer [Your OpenAI API Key]
       • Content-Type: application/json
     • Body:

       {
         "prompt": "Analyze the following SEO issues and provide actionable recommendations:\n\n[Insert SEO issues here]",
         "max_tokens": 500
       }
                   

5. Map Data from Google Sheets to ChatGPT API:
   • In the ChatGPT API module, replace [Insert SEO issues here] in the prompt with data from the Google Sheets module. Map the relevant columns that contain the SEO issues.
6. Add Email Module:
   • Search for and add the “Email” module.
   • Select “Send an Email” as the action.
   • Configure the module:
     • To: Your email address
     • Subject: “SEO Audit Fix-It Report”
     • Body: Map the output from the ChatGPT API module to include the generated recommendations.
7. Activate the Scenario: Once all modules are configured, activate the scenario. Make will now monitor the Google Sheets for new audit data, process it with ChatGPT API, and send you an email with the fix-it report.

Optional Enhancements

To further improve your automated SEO audit system, consider the following enhancements:

• Integrate with Slack: Add a Slack module in Make to send the fix-it reports to a dedicated Slack channel for your team.
• Log Reports in Airtable: Use the Airtable module to log each fix-it report, creating a historical record of audits and actions taken.
• Set Up Alerts for Critical Issues: Configure conditional logic in Make to send immediate alerts if critical SEO issues are detected in the audit data.

By following these steps, you’ll have a robust system in place that automates your blog’s SEO audits and delivers actionable insights directly to your inbox. Happy automating!