Automate Weekly SEO Report with GPT-4 Insights and Slack Delivery

What this workflow does

• Runs automatically every Monday morning at 8 AM
• Collects your Google Search Console from the last month and the month before that for a given url (date range is configurable)
• Formats the data, aggregating it by date, query, page, device and country
• Generates AI-driven analysis and insights on your results, providing actionable recommendations
• Renders the report as a visually appealing PDF with charts and tables
• Sends the report via Slack (you can also add email or WhatsApp)

A sample for the first page of the report:

Setup Guide

• Create an account of pdforge and use the pre-made Meta Ads template.
• Connect Google OAuth2 (guide on the template), OpenAI and Slack to n8n
• Set your site url and date range
• (opcional) Customize the scheduling date and time

Requirements

• Google OAuth2 (via Google Search Console): Documentation
• pdforge access: Create an account
• AI API access (e.g. via OpenAI, Anthropic, Google or Ollama)
• Slack acces (via OAuth2): Documentation

Feel free to contact me via Linkedin, if you have any questions! 👋🏻