Weekly AI Brand Visibility Tracker with DataForSEO, OpenAI & Gmail

Know every week how visible your brand is in AI answers—automatically

This n8n workflow runs weekly to track how often your brand is mentioned in AI answers for selected topics, using DataForSEO results. It compares this week’s performance against your prior runs in Google Sheets, generates a brief insight summary with OpenAI, and sends a clean HTML report via Gmail.

What this workflow does

• Schedules weekly (Monday mornings) or can be run manually.
• Loads your configuration: topics, brand name, domains to exclude, platform, location, your Google Sheet URL, and recipient email.
• Creates parallel DataForSEO requests—one per topic + platform pair—to fetch:
  • a DataForSEO brand leaderboard for AI answer mentions
  • top cited pages/source domains
• Cleans and ranks results, calculates your brand rank and share of total mentions, and extracts leading cited source domains.
• Normalizes quoted URLs from the cited-pages response and counts how many quoted pages belong to your domain.
• Compares with history by reading the Google Sheets history tab and measuring rank/share changes vs. the most recent previous run for each topic/platform.
• Logs this week’s metrics into Google Sheets and, when data exists, uses OpenAI to write up to six summary bullets.
• Sends an HTML email report using Gmail.

Use cases

• SaaS operators monitoring brand visibility in AI answers by topic and platform.
• Automation engineers building a recurring SEO/AI visibility dashboard with audit-style week-over-week tracking.
• Marketing teams tracking whether competitors or specific source domains appear more often in AI responses over time.

Technical details

• Data sources: DataForSEO (two HTTP requests using Basic Auth: login email + API password).
• Storage & comparison: Google Sheets with a history tab (includes columns like checked_on, topic_key, topic, and week metrics).
• AI summarization: OpenAI generates a short commentary (up to six bullets) when topic data is present.
• Email delivery: Gmail sends a formatted HTML report.
• n8n building blocks mentioned: if, set, code, no op, gmail, merge.