рд╕рднреА рдЯреЗрдореНрдкрд▓реЗрдЯ
SEOIntermediate
New Ranked Keywords to Slack
RobomotionтАв3 рдорд╛рд╣ рдкрд╣рд▓реЗ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛

рдУрд╡рд░рд╡реНрдпреВ
Each week, pulls every keyword your target domains rank for, compares it against last week's snapshot, and posts whatever is new to Slack.
New Ranked Keywords to Slack
Each week, pulls every keyword your target domains rank for, compares it against last week's snapshot, and posts whatever is new to Slack.
How it works
- Weekly тАФ an Inject trigger repeating every 604,800 seconds.
- Get Previous Keywords тЖТ Index Previous Keywords тЖТ Clear Keywords Sheet тАФ the previous snapshot is read and indexed by
target|keyword, then wiped. That index is the diff baseline. - Get Targets / Collect Targets тАФ one entry per row of the Targets sheet: domain, location, language.
- For Each Target тЖТ Get Ranked Keywords тЖТ Accumulate Page тЖТ Go To Next Page тАФ a nested
Label/GoToloop pages 1000 keywords at a time untiltotal_countis exhausted. - Find New Keywords тАФ builds the full current snapshot and, separately, the rows whose key was absent from the previous one.
- Append Current Snapshot тЖТ Post To Slack.
The sheet always holds the present; Slack always holds the change.
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.
- Slack credential тАФ a bot token with
chat:writeon the target channel. - Two sheets:
Targets(Target,Location,Language) andKeywords(Target,Keyword,Date,Rank,Search Volume,URL,SERP Item Types).
First run
With an empty Keywords sheet every keyword counts as new, so the first Slack message is the whole list. That is the baseline; subsequent runs are the interesting ones.
Ported from
- Get New Ranked Keywords from Google with DataForSEO тАФ DataForSEO template
SEO рдХреЗ рдФрд░ рдЯреЗрдореНрдкрд▓реЗрдЯ
рд╕рднреА 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.