Weekly AI Search Visibility Tracking (Apify + Sheets + Gmail)

Track your brand’s weekly AI search visibility—automatically

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

What this workflow does

• Runs on a weekly schedule (or manually): loads your brand, queries, selected AI platforms, budget, and Google Sheets configuration.
• Validates setup and alerts: checks required fields and ensures there are enough queries; if not, it emails a setup problem to your alert address.
• Enables week-over-week reporting: reads the prior History and Gap Report tabs from Google Sheets.
• Measures AI visibility with Apify: starts the Apify actor run, polls until success/failure, then aggregates results by question.
• Updates gap metrics: upserts the latest gap metrics into the Gap Report tab.
• Captures citation opportunities: extracts top cited source URLs (excluding your own domain) and upserts them into Citation Targets.
• Sends a weekly score + trends digest: appends a run summary to History (score, rates, checks, estimated cost) and emails an HTML digest via Gmail.

Use cases

• Monitor brand mention and citation performance across multiple AI platforms without manual reporting.
• Spot week-over-week declines in AI Overview or competitor visibility to adjust content and PR strategy.
• Maintain a running “Citation Targets” list for outreach and optimization workstreams.

Technical details

• Apify actor + polling: runs the visibility measurement and waits until results are ready.
• Google Sheets integration: reads History/Gap Report, and upserts into Gap Report and Citation Targets.
• Gmail digest delivery: sends an HTML weekly summary with trends and alerts.
• Core n8n nodes mentioned: if, set, code, no op, sort, wait.

Best for: n8n users, automation engineers, and SaaS operators who want automated AI search visibility tracking with Apify + Sheets + Gmail.