{"product_id":"weekly-ai-brand-visibility-tracker-with-dataforseo-openai-gmail","title":"Weekly AI Brand Visibility Tracker with DataForSEO, OpenAI \u0026 Gmail","description":"\u003ch3\u003eKnow every week how visible your brand is in AI answers—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs weekly to track how often your brand is mentioned in AI answers for selected topics, using \u003cstrong\u003eDataForSEO\u003c\/strong\u003e results. It compares this week’s performance against your prior runs in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates a brief insight summary with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and sends a clean HTML report via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules weekly (Monday mornings)\u003c\/strong\u003e or can be run manually.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your configuration\u003c\/strong\u003e: topics, brand name, domains to exclude, platform, location, your Google Sheet URL, and recipient email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates parallel DataForSEO requests\u003c\/strong\u003e—one per \u003cem\u003etopic + platform\u003c\/em\u003e pair—to fetch:\n    \u003cul\u003e\n      \u003cli\u003ea DataForSEO brand leaderboard for AI answer mentions\u003c\/li\u003e\n      \u003cli\u003etop cited pages\/source domains\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and ranks results\u003c\/strong\u003e, calculates your brand rank and share of total mentions, and extracts leading cited source domains.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes quoted URLs\u003c\/strong\u003e from the cited-pages response and counts how many quoted pages belong to your domain.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares with history\u003c\/strong\u003e by reading the Google Sheets \u003ccode\u003ehistory\u003c\/code\u003e tab and measuring rank\/share changes vs. the most recent previous run for each topic\/platform.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs this week’s metrics\u003c\/strong\u003e into Google Sheets and, when data exists, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to write up to six summary bullets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an HTML email report\u003c\/strong\u003e using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators monitoring \u003cstrong\u003ebrand visibility in AI answers\u003c\/strong\u003e by topic and platform.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a recurring \u003cstrong\u003eSEO\/AI visibility dashboard\u003c\/strong\u003e with audit-style week-over-week tracking.\u003c\/li\u003e\n  \u003cli\u003eMarketing teams tracking whether competitors or specific source domains appear more often in AI responses over time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData sources:\u003c\/strong\u003e DataForSEO (two HTTP requests using Basic Auth: login email + API password).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage \u0026amp; comparison:\u003c\/strong\u003e Google Sheets with a \u003ccode\u003ehistory\u003c\/code\u003e tab (includes columns like \u003ccode\u003echecked_on\u003c\/code\u003e, \u003ccode\u003etopic_key\u003c\/code\u003e, \u003ccode\u003etopic\u003c\/code\u003e, and week metrics).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI summarization:\u003c\/strong\u003e OpenAI generates a short commentary (up to six bullets) when topic data is present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery:\u003c\/strong\u003e Gmail sends a formatted HTML report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n building blocks mentioned:\u003c\/strong\u003e if, set, code, no op, gmail, merge.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45967685550259,"sku":"N8N-19236","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mqU0rjEKqUVBHfFiTvRyo_ZzGy3vGa.png?v=1788686418","url":"https:\/\/buyflowscripts.com\/products\/weekly-ai-brand-visibility-tracker-with-dataforseo-openai-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}