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

Description

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 pdf noodle 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

👉🏻 You can use our detailed guide on how to setup this workflow.

Requirements
Google OAuth2 (via Google Search Console): Documentation
pdf noodle 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! 👋🏻