SEO report generator

This workflow automates the creation of comprehensive monthly SEO reports by pulling data from multiple sources, analyzing it with AI, and generating a polished Google Slides presentation ready to share with clients.

Who is it for?

This template is perfect for:

  • SEO Agencies managing multiple clients
  • Digital Marketing Teams
  • Freelance SEO Consultants

What it does

  1. Webhook Trigger: Receives a trigger from Airtable when a new monthly report needs to be generated.
  2. Data Collection: Fetches the client record from Airtable containing report parameters and client details.
  3. Analytics Gathering: Pulls traffic and user behavior data from Google Analytics 4 for the reporting period.
  4. Backlink Analysis: Retrieves backlink metrics and historical data from DataForSEO API.
  5. Content Performance: Fetches WordPress post data to analyze content performance and engagement.
  6. AI-Powered Insights: Sends all collected metrics to OpenAI GPT to generate insights, trends analysis, and strategic recommendations.
  7. Report Generation: Creates a new Google Slides presentation from your branded template, populating it with all metrics, charts, and AI-generated insights.
  8. Data Storage: Updates Airtable with the processed data and generated report link.

How to set up

  1. Airtable Structure:

    • Update Base ID and Table ID to match your Airtable base.
    • Ensure your "Key Metrics" table has fields: Month Number, File ID, Client Name, Import Analytics, Import SEO Metrics, Import Content Metrics.

  2. API Credentials:

  3. Connect Google account (for Analytics 4 and Slides access).

  4. Add DataForSEO API credentials (login and password).

  5. Configure WordPress site credentials for each client.

  6. Add OpenAI API key for GPT analysis.

  7. Google Slides Template:

  8. Create your branded template presentation with placeholder tags (e.g., {{CLIENT_NAME}}, {{SESSIONS}}, {{BACKLINKS}}).

  9. Update the template Presentation ID in the "Create Presentation" module.

  10. Update template slide Object IDs for sections you want to duplicate.

  11. Update Client Configurations:

  12. In GA4 modules, update Property IDs for each client.

  13. In DataForSEO modules, set target domains for backlink analysis.

  14. In WordPress modules, configure site URLs.

  15. Webhook Setup:

  16. Copy the webhook URL from the first module.

  17. Configure an Airtable automation to POST to this webhook with the record ID when you want to generate a report.

  18. Run the Workflow: Trigger via Airtable or test with a manual webhook call!

← Previous
Next →