All templates
SEOBeginner
SERP Position for Airtable Records
Robomotion•Updated 1 week ago
Overview
Watches an Airtable table for keyword/domain pairs that have not been checked yet, looks up where the domain ranks for that keyword on Google, and writes the position back onto the record.
SERP Position for Airtable Records
Watches an Airtable table for keyword/domain pairs that have not been checked yet, looks up where the domain ranks for that keyword on Google, and writes the position back onto the record.
How it works
- Every 15 Minutes — an Inject trigger repeating every 900 seconds.
- List Unchecked Records —
filterByFormula=NOT({Processed}), ten at a time. - For Each Record → Build SERP Request → Get SERP Position.
- Build Record Update → Write Position Back — sets
Position,URL,CheckedandProcessed.
The lookup passes target through Extra Parameters, so DataForSEO filters the SERP to that domain server-side and the first item is the position — which is why the depth can stay at 1.
Setup
- DataForSEO credential — API login and password from https://app.dataforseo.com/api-access.
- Airtable credential — a personal access token with access to the base.
- A table with
Keyword,Target, optionalLocationandLanguage, plusPosition,URL,CheckedandProcessed(checkbox).
Ported from
- Get Google SERP position for new Airtable records 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.