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

Go to Workflow
1,882 views
Built by Marcelo Abreu Marcelo Abreu
Created on June 07, 2026

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! 👋🏻

Nodes Used (5)

AI Agent
@n8n/n8n-nodes-langchain.agent
Code
n8n-nodes-base.code
HTTP Request
n8n-nodes-base.httpRequest
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Slack
n8n-nodes-base.slack