Track weekly Bing keyword rankings with Apify and Google Sheets
UnknownWhat this workflow does
This workflow has 11 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets, Slack and Apify (community).
How it runs
Trigger: On a schedule (every week at 08:00).
- Read the rank history (Google Sheets): uses Google Sheets
- Set the keywords to track (Edit Fields (Set)): sets 4 fields: keywords, yourDomain, market…
- One search per keyword (Split Out): splits a list into separate items
- Search Bing (Apify): run actor and get dataset (actors)
- Keep organic results (Filter): keeps only the items that match a condition
- Compare with last week (Code): runs custom JavaScript code
- Append this week's ranks (Google Sheets): append
- Optional: only the results that slipped (Filter): keeps only the items that match a condition
- Optional: post movers to Slack (Slack): uses Slack
- Optional: average position per keyword (Summarize): summarizes / groups the items
Services it uses
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 @apify/n8n-nodes-apify is verified or supports 3.0 (used in Search Bing).
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - Summarize
n8n-nodes-base.summarize
From the author
Quick overview Most rank trackers charge per keyword per month. This one runs on your schedule and writes to your sheet. Before each search it reads the history back, so every row carries where the result sat last week, how far it moved, and whether that is…