Web research assistant: automated search & scraping with Gemini AI and spreadsheet reports
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs when a chat message arrives. Along the way it connects Google Gemini Chat Model, Google Sheets and Mcp (community).
How it runs
Trigger: When a chat message arrives.
- Gemini Research Orchestrator (AI Agent): runs an AI agent, with model: Google Gemini Chat Model; 6 tools (Apify list, Brave list, Apify execute, Brave execute…); memory: Simple Memory
- Create Research Report (Google Sheets): work with spreadsheet
- Format Research Data (Code): runs custom JavaScript code
- Populate Research Report (HTTP Request): calls an HTTP API (POST)
- Data Enrichment Request (HTTP Request): calls an HTTP API (POST)
- Finalize Output Data (Edit Fields (Set)): sets or maps fields
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-mcp is verified or supports 3.0 (used in Firecrawl list, Firecrawl execute, Brave list).
Nodes used (9)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Mcp Client Tool
n8n-nodes-mcp.mcpClientTool - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set
From the author
⚠️ IMPORTANT: This template requires self-hosted n8n hosting due to the use of community nodes (MCP tools). It will not work on n8n Cloud. Make sure you have access to a self-hosted n8n instance before using this template. Overview This workflow automation…