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

AI Overview Citations to Sheets

RobomotionтАв3 рдорд╛рд╣ рдкрд╣рд▓реЗ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛
AI Overview Citations to Sheets

рдУрд╡рд░рд╡реНрдпреВ

Tracks 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 Citations to Sheets

Tracks 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.

How it works

  1. Every 7 Days тАФ an Inject trigger set to repeat weekly.
  2. Set Parameters тАФ the keyword, location, language and target spreadsheet. load_async_ai_overview is passed through Extra Parameters so DataForSEO fetches the AI Overview block, which Google renders asynchronously and would otherwise be missing from the SERP.
  3. Get AI Overview SERP тАФ DataForSEO.Serp.GoogleOrganic returns the SERP elements in rank order.
  4. Collect References тАФ finds the ai_overview element and walks both its top-level references array and the per-block references of expanded answers, de-duplicating by URL.
  5. Append References тАФ writes one row per source 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 with the columns Source, Domain, URL, Title, Text.

Cost

One live Google Organic SERP call per run.

Ported from

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

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