Detect content decay from Google Search Console and alert via Slack and email

by Veena Pandian ✓ · 131 views · created 2026-03-03 · Market Research, AI Summarization

What this workflow does

This workflow has 13 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets and Slack.

How it runs

Trigger: On a schedule (every week at 08:00).

1. Calculate Date Ranges (Code): runs custom JavaScript code
2. Fetch GSC Recent 7 Days (HTTP Request): calls an HTTP API
3. Fetch GSC Previous 28 Days (HTTP Request): calls an HTTP API
4. Compare Periods and Detect Decay (Code): runs custom JavaScript code
5. Filter: keeps only the items that match a condition
6. Log All Results to Decay Sheet (Google Sheets): append
7. Build Weekly Decay Report (Code): runs custom JavaScript code
8. Check If Any Critical Pages (Filter): keeps only the items that match a condition
9. Post Report to Slack (Slack): uses Slack
10. Email Weekly Report (Send Email): sends an email over SMTP

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsSlack

Before you upgrade to n8n 3.0

Nodes used (7)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Google Sheetsn8n-nodes-base.googleSheets
• Filtern8n-nodes-base.filter
• Slackn8n-nodes-base.slack
• Send Emailn8n-nodes-base.emailSend

From the author

Who is this for? SEO managers, content marketers, bloggers, and growth teams who want to automatically catch declining content performance before it's too late — without manually checking Google Search Console every week. What this workflow does This workflow…

View the original on n8n.io → Check your own copy