Block 1 - Configuration
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Automate weekly SEO report with GPT-4 insights and Slack delivery
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
1. Workflow Overview
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...
Best for
- Market Research automation workflows
- AI Summarization automation workflows
- advanced n8n builders looking for reusable templates
Tools used
n8n-nodes-base.set, n8n-nodes-base.stickynote, n8n-nodes-pdforge.pdforge, n8n-nodes-base.httprequest, @n8n/n8n-nodes-langchain.lmchatopenai, n8n-nodes-base.code, n8n-nodes-base.slack, n8n-nodes-base.scheduletrigger
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Marcelo Abreu.
Original n8n.io source1.1 Workflow description
- Title
- Automate weekly SEO report with GPT-4 insights and Slack delivery
- Workflow name
- 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 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! šš»
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Sticky Note
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 3 - Sticky Note1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 4 - Pdforge
- Type / Role
- n8n-nodes-pdforge.pdforge - pdforge
- Config choices
- Version 1
Block 5 - Download Binary
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 6 - OpenAI Chat Model
- Type / Role
- @n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
- Config choices
- Version 1.2
Block 7 - Generate variables
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 8 - Slack - Send Message with File
- Type / Role
- n8n-nodes-base.slack - slack
- Config choices
- Version 2.3
Block 9 - Weekly at monday 8am
- Type / Role
- n8n-nodes-base.scheduleTrigger - scheduleTrigger
- Config choices
- Version 1.2
Block 10 - HTTP Request - Google Search Console - Query - Previous Month
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 11 - HTTP Request - Google Search Console - Page - Previous month
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 12 - Split Out Pages - Previous month
- Type / Role
- n8n-nodes-base.splitOut - splitOut
- Config choices
- Version 1
Block 13 - Format Query - Previous month
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 14 - HTTP Request - Google Search Console - Date
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 15 - Split Out Date
- Type / Role
- n8n-nodes-base.splitOut - splitOut
- Config choices
- Version 1
Block 16 - Format Date
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 17 - HTTP Request - Google Search Console - Overview
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 18 - Split Out Overview
- Type / Role
- n8n-nodes-base.splitOut - splitOut
- Config choices
- Version 1
Block 19 - Format Overview
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 20 - HTTP Request - Google Search Console - Page
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 21 - Split Out Pages
- Type / Role
- n8n-nodes-base.splitOut - splitOut
- Config choices
- Version 1
Block 22 - HTTP Request - Google Search Console - Device
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 23 - Split Out Devices
- Type / Role
- n8n-nodes-base.splitOut - splitOut
- Config choices
- Version 1
Block 24 - Format Devices
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Showing the first 24 of 42 workflow blocks. Download the JSON for the full node graph.
3. Summary Table
| Workflow | Automate weekly SEO report with GPT-4 insights and Slack delivery |
|---|---|
| Complexity | advanced |
| Nodes | 42 |
| Categories | Market Research, AI Summarization |
| Author | Marcelo Abreu |
| Published | 11 Jul 2025 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/5891/5891.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Automate weekly SEO report with GPT-4 insights and Slack delivery do?
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...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.