Templates / AI-powered web research in Google Sheets with GPT and Bright Data

AI-powered web research in Google Sheets with GPT and Bright Data

Ready for 3.0

by Elay Guez ✓ · 10,996 views · created 2025-10-24 · Market Research, AI RAG

Ready 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 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.

  1. Set Variables (Edit Fields (Set)): sets 3 fields: userPrompt, cellReference, ouputLanguage
  2. Adjust Query Agent (AI Agent): runs an AI agent, with model: GPT 4.1 Mini -
  3. Bright Data Search Agent (AI Agent): runs an AI agent, with model: GPT 4o -; 1 tool (Bright Data MCP); output parser: Structured Output Parser
  4. Bright Data - Data Extraction (HTTP Request): calls api.brightdata.com (POST)
  5. Extract Data (Basic LLM Chain): sends a prompt to an LLM, with model: GPT 4o Mini -; output parser: Structured Output Parser
  6. Summarize Information (AI Agent): runs an AI agent, with model: GPT 4o Mini -; output parser: Structured Output Parser
  7. Respond to Webhook: sends the response back to the webhook caller
  8. Update Logs (Data table): uses Data table

Services it uses

MCP ClientOpenAI Chat Model

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)

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…

Excerpt from Elay Guez's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.