All templates
SEOBeginner
Add Backlinks to Google Sheets
Robomotion•Updated 1 week ago

Overview
Pulls 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.
Add Backlinks to Google Sheets
Pulls 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.
How it works
- Every 15 Minutes — an Inject trigger repeating every 900 seconds.
- Set Parameters — the target domain, the destination sheet, and the two flags that widen the result set:
include_subdomainscounts links toblog.example.com,include_indirect_linkssurfaces links that reach you through a redirect or canonical. - Get Backlinks —
DataForSEO.Backlinks.Backlinks, live status, modeas_is, 100 links per call. - Build Rows — sixteen columns in the source spreadsheet's order.
indirect_link_pathis an array of hops, so it is JSON-stringified into its cell. - Append Backlinks — appends to the sheet.
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.
- A sheet whose header row matches the sixteen
url_from … indirect_link_pathcolumns.
Scaling past 100 links
Raise optLimit (up to 1000), or wrap the call in a Core.Flow.Label / Core.Flow.GoTo pair that walks optOffset — the toxic-backlink templates in this set show that pattern.
Ported from
- Add backlinks to Google Sheets from 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.
- 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.
- App Review Alerts to SlackEvery morning, pulls the newest reviews for your app from both Google Play and the App Store, keeps only the ones written since the last run, and posts a digest per store to Slack.