All templates
SEOIntermediate
New Top-10 Keywords to Airtable
Robomotion•Updated 2 months ago
Overview
Each week, finds the keywords where your domains have broken into Google's first page, writes them to an Airtable base, and posts a summary to Slack.
New Top-10 Keywords to Airtable
Each week, finds the keywords where your domains have broken into Google's first page, writes them to an Airtable base, and posts a summary to Slack.
How it works
- Weekly — Inject trigger.
- Index Previous Keywords → Clear Keywords Sheet — the diff baseline.
- For Each Target → Get Ranked Keywords, filtered server-side on
rank_group <= 10→ Accumulate Page → Go To Next Page. - Find New Keywords → Append Current Snapshot → For Each Batch → Create Airtable Records → Post To Slack.
The Airtable write loops in batches of ten because that is the hard limit of the bulk-create endpoint.
Page one is where the traffic is — a keyword moving from 14 to 9 is worth more than ten new keywords ranking at 60, and this is the alert that catches it.
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.
- Airtable credential — a personal access token, plus the base ID and table name.
- Slack credential — a bot token with
chat:write. - Two sheets:
TargetsandKeywords.
Ported from
- Log New Ranked Keywords in Top 10 Google Results in Airtable 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.