All templates
SEOBeginner
Add Backlinks to Google Sheets
Robomotion•Updated Yesterday

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