Track Google AI Overview citations with Bright Data, OpenAI, Google Sheets and Slack
Ready for 3.0What this workflow does
This AI workflow has 22 nodes and runs on a schedule (every day at 08:00) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI Chat Model, Slack and Google Gemini Chat Model. It also calls api.brightdata.com over HTTP.
How it runs
Trigger: On a schedule (every day at 08:00) (plus 1 other trigger).
- Settings (Edit Fields (Set)): sets 6 fields: keywords, brand_domain, country…
- Read Last Run (Google Sheets): uses Google Sheets
- One Row Per Keyword (Code): runs custom JavaScript code
- Search Google (HTTP Request): calls api.brightdata.com (POST)
- Read The AI Overview (Code): runs custom JavaScript code
- Rank The Cited Domains (Code): runs custom JavaScript code
- Any Overviews Found? (If): checks a condition and branches into true / false
- Plan Page Reads (Code): runs custom JavaScript code
- Read Cited Pages (HTTP Request): calls api.brightdata.com (POST)
- Build Citation Report (Code): runs custom JavaScript code
…plus 8 more steps. See the full node list below.
Services it uses
HTTP calls to: api.brightdata.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Slack
n8n-nodes-base.slack - n8n Form Trigger
n8n-nodes-base.formTrigger - Switch
n8n-nodes-base.switch - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Quick overview This workflow runs weekly (or on demand) to check Google AI Overview citations for a set of keywords using Bright Data, compares the cited domains to last run’s results, generates a short briefing with OpenAI, logs a row-per-citation history to…