Track weekly AI brand visibility with DataForSEO, OpenAI, Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every week at 08:00) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI Chat Model and Gmail. It also calls api.dataforseo.com over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00) (plus 1 other trigger).
- Settings (Edit Fields (Set)): sets 9 fields: category_topics, brand, domain…
- Plan The Questions (Code): runs custom JavaScript code
- Read What You Saw Last Week (Google Sheets): uses Google Sheets
- Ask Who The Models Name (HTTP Request): calls api.dataforseo.com (POST)
- Ask Which Pages Get Quoted (HTTP Request): calls api.dataforseo.com (POST)
- Put The Answers Together (Merge): merges the data from its input branches
- Read The Leaderboard (Code): runs custom JavaScript code
- Read The Quoted Pages (Code): runs custom JavaScript code
- Compare With Last Week (Code): runs custom JavaScript code
- One Row Per Topic (Split Out): splits a list into separate items
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: api.dataforseo.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 - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Split Out
n8n-nodes-base.splitOut - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow runs weekly to track how often your brand is mentioned in AI answers for chosen category topics using DataForSEO, compares results with a Google Sheets history, generates a short commentary with OpenAI, and sends a formatted…