All templates
SEOAdvanced
Top-10 Rank Drop Alerts by Email
Robomotion•Updated 1 week ago
Overview
Every day, pulls the keywords each target domain currently holds a top-10 position for, compares against yesterday's snapshot, and emails a digest of everything that slipped.
Top-10 Rank Drop Alerts by Email
Every day, pulls the keywords each target domain currently holds a top-10 position for, compares against yesterday's snapshot, and emails a digest of everything that slipped.
How it works
- Daily — an Inject trigger repeating every 86,400 seconds.
- Get Yesterday Positions → Index Yesterday Positions → Clear Keywords Sheet — the index maps
target|keywordto yesterday's position. - For Each Target → Get Top 10 Keywords → Accumulate Page → Go To Next Page — a nested
Label/GoToloop, filtered server-side torank_group <= 10. - Find Rank Drops — reports two kinds of loss: a keyword still on page one but at a worse position, and a keyword that was on page one yesterday and is absent from today's set entirely.
- Append Today Positions → Should We Email → Email The Drops.
Losing page one is the most expensive ranking event there is, and it is usually silent. This is the alert that makes it loud.
The snapshot is written for every target; only targets with drops get mail. The first run establishes the baseline and alerts on nothing.
Setup
- DataForSEO credential — API login and password from https://app.dataforseo.com/api-access.
- Google credential — Service Account or OAuth2 with access to the spreadsheet.
- Gmail credential — OAuth2 for the sending account.
- Two sheets:
Targets(Target,Location,Language) andKeywords(Target,Keyword,Date,Rank,Search Volume,URL).
Ported from
- Get Gmail alerts for dropped top 10 keyword rankings with DataForSEO — DataForSEO template
More seo templates
See all 53 →- ActiveCampaign Lead Business DataEvery 15 minutes, takes the leads ActiveCampaign has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the ActiveCampaign record.
- ActiveCampaign Lead Traffic StatsEvery 15 minutes, takes the leads ActiveCampaign has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the ActiveCampaign record.
- Add Backlinks to Google SheetsPulls the live backlinks pointing at a domain every 15 minutes and appends them to a Google Sheet, one row per link, with the source page, anchor text, follow status, ranks and first/last seen dates.
- AI Mode References to SheetsTracks which websites Google's AI Mode cites when it answers a question. Every 7 days it queries the AI Mode SERP for a keyword, flattens the references of every answer block, de-duplicates them by URL and appends them to a Google Sheet.
- AI Overview Citations to SheetsTracks which websites Google's AI Overview cites for a keyword. Every 7 days it pulls the Google SERP with the AI Overview block loaded, collects every source the answer references, de-duplicates them by URL and appends them to a Google Sheet.
- AI Overview Keyword Wins by EmailEach week, finds the keywords where your domains are newly cited inside Google's AI Overview, saves the full picture to Google Sheets, and emails the new placements.