Analyze search intent for keywords with Google scraping, Bright Data, and Gemini AI
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 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Google Gemini Chat Model. It also calls api.brightdata.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Keywords (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- set keyword (Edit Fields (Set)): sets 2 fields: search_term, country code
- Fetch Google Search Results JSON (HTTP Request): calls api.brightdata.com (POST)
- Split Out: splits a list into separate items
- format fields (Edit Fields (Set)): sets 6 fields: Keyword, ranking page, title…
- Intent Classifier (Text Classifier): classifies text into categories with AI, with model: Google Gemini Chat Model
- informational (Edit Fields (Set)): sets 1 field: intent
- Navigational (Edit Fields (Set)): sets 1 field: intent
- Commercial (Edit Fields (Set)): sets 1 field: intent
…plus 4 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 (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Merge
n8n-nodes-base.merge
From the author
What it does This workflow scrapes the top 10 pages on SERP and conducts an in-depth analysis of the keyword intent for each ranking keyword, saving the information to a Google Sheet for further analysis. How does this workflow work? - We add our keywords and…