Track and alert on Google keyword rankings with Scrapio, Google Sheets, and Slack
UnknownWhat this workflow does
This workflow has 17 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets, Slack and Scrapio (community).
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Set Keywords and Domains (Edit Fields (Set)): sets or maps fields
- Read Ranking History (Google Sheets): read
- Read Ranking Log (Google Sheets): read
- Combine Keywords with History (Merge): merges the data from its input branches
- Aggregate: combines items into one
- Filter: keeps only the items that match a condition
- Split Out: splits a list into separate items
- Aggregate: combines items into one
- Search Google Rankings (Scrapio): search
- Build Weekly Summary (Edit Fields (Set)): sets 5 fields: total, improved, declined…
…plus 5 more steps. See the full node list below.
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-scrapio is verified or supports 3.0 (used in Search Google Rankings).
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - Split Out
n8n-nodes-base.splitOut - Scrapio
n8n-nodes-scrapio.scrapio - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Filter
n8n-nodes-base.filter
From the author
Quick Overview This workflow tracks daily Google search positions for a list of keyword/domain pairs using Scrapio, logs the results to Google Sheets with position change metrics, and sends Slack alerts for sharp ranking drops plus a weekly Slack digest…