{"product_id":"weekly-ai-search-visibility-tracking-apify-sheets-gmail","title":"Weekly AI Search Visibility Tracking (Apify + Sheets + Gmail)","description":"\u003ch3\u003eTrack your brand’s weekly AI search visibility—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every week to measure how visible your brand is across Google AI Overview, ChatGPT, Claude, Gemini, and Perplexity. It pulls results from an Apify actor, updates your Google Sheets with gap and citation insights, and emails you a digest via Gmail—so you always know where you’re winning, slipping, or missing citations.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a weekly schedule (or manually):\u003c\/b\u003e loads your brand, queries, selected AI platforms, budget, and Google Sheets configuration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates setup and alerts:\u003c\/b\u003e checks required fields and ensures there are enough queries; if not, it emails a setup problem to your alert address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEnables week-over-week reporting:\u003c\/b\u003e reads the prior \u003ci\u003eHistory\u003c\/i\u003e and \u003ci\u003eGap Report\u003c\/i\u003e tabs from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eMeasures AI visibility with Apify:\u003c\/b\u003e starts the Apify actor run, polls until success\/failure, then aggregates results by question.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpdates gap metrics:\u003c\/b\u003e upserts the latest gap metrics into the \u003ci\u003eGap Report\u003c\/i\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCaptures citation opportunities:\u003c\/b\u003e extracts top cited source URLs (excluding your own domain) and upserts them into \u003ci\u003eCitation Targets\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a weekly score + trends digest:\u003c\/b\u003e appends a run summary to \u003ci\u003eHistory\u003c\/i\u003e (score, rates, checks, estimated cost) and emails an HTML digest via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor brand mention and citation performance across multiple AI platforms without manual reporting.\u003c\/li\u003e\n  \u003cli\u003eSpot week-over-week declines in AI Overview or competitor visibility to adjust content and PR strategy.\u003c\/li\u003e\n  \u003cli\u003eMaintain a running “Citation Targets” list for outreach and optimization workstreams.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eApify actor + polling:\u003c\/b\u003e runs the visibility measurement and waits until results are ready.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets integration:\u003c\/b\u003e reads \u003ci\u003eHistory\u003c\/i\u003e\/\u003ci\u003eGap Report\u003c\/i\u003e, and upserts into \u003ci\u003eGap Report\u003c\/i\u003e and \u003ci\u003eCitation Targets\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail digest delivery:\u003c\/b\u003e sends an HTML weekly summary with trends and alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCore n8n nodes mentioned:\u003c\/b\u003e if, set, code, no op, sort, wait.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eBest for:\u003c\/b\u003e n8n users, automation engineers, and SaaS operators who want automated AI search visibility tracking with Apify + Sheets + Gmail.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45895378895027,"sku":"N8N-18636","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sVNu1FVPUn_QVV41d_kw2_LCfh2p6t.png?v=1787649487","url":"https:\/\/buyflowscripts.com\/products\/weekly-ai-search-visibility-tracking-apify-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}