рд╕рднреА рдЯреЗрдореНрдкрд▓реЗрдЯ
SEOBeginner

Add Backlinks to Google Sheets

RobomotionтАв3 рдорд╛рд╣ рдкрд╣рд▓реЗ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛
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.

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

  1. Every 15 Minutes тАФ an Inject trigger repeating every 900 seconds.
  2. Set Parameters тАФ the target domain, the destination sheet, and the two flags that widen the result set: include_subdomains counts links to blog.example.com, include_indirect_links surfaces links that reach you through a redirect or canonical.
  3. Get Backlinks тАФ DataForSEO.Backlinks.Backlinks, live status, mode as_is, 100 links per call.
  4. Build Rows тАФ sixteen columns in the source spreadsheet's order. indirect_link_path is an array of hops, so it is JSON-stringified into its cell.
  5. 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_path columns.

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

SEO рдХреЗ рдФрд░ рдЯреЗрдореНрдкрд▓реЗрдЯ

рд╕рднреА 53 рджреЗрдЦреЗрдВ тЖТ