AI-powered web research in Google Sheets with GPT and Bright Data
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects MCP Client and OpenAI Chat Model. It also calls api.brightdata.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Set Variables (Edit Fields (Set)): sets 3 fields: userPrompt, cellReference, ouputLanguage
- Adjust Query Agent (AI Agent): runs an AI agent, with model: GPT 4.1 Mini -
- Bright Data Search Agent (AI Agent): runs an AI agent, with model: GPT 4o -; 1 tool (Bright Data MCP); output parser: Structured Output Parser
- Bright Data - Data Extraction (HTTP Request): calls api.brightdata.com (POST)
- Extract Data (Basic LLM Chain): sends a prompt to an LLM, with model: GPT 4o Mini -; output parser: Structured Output Parser
- Summarize Information (AI Agent): runs an AI agent, with model: GPT 4o Mini -; output parser: Structured Output Parser
- Respond to Webhook: sends the response back to the webhook caller
- Update Logs (Data table): uses Data table
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 (10)
- Respond to Webhook
n8n-nodes-base.respondToWebhook - AI Agent
@n8n/n8n-nodes-langchain.agent - MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool - Webhook
n8n-nodes-base.webhook - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Data table
n8n-nodes-base.dataTable - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Edit Fields (Set)
n8n-nodes-base.set
From the author
🔍 AI-Powered Web Research in Google Sheets with Bright Data 📋 Overview Transform any Google Sheets cell into an intelligent web scraper! Type =BRIGHTDATA("cell", "search prompt") and get AI-filtered result from every website in ~20 seconds. What happens…