Generate business research reports with Claude, web search and Google Drive

by Oneclick AI Squad ✓ · 185 views · created 2026-03-02 · Market Research, Multimodal AI

What this workflow does

This workflow has 20 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets. It also calls google.serper.dev, newsapi.org and alphavantage.co over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Set Credentials and Config (Edit Fields (Set)): sets 16 fields: topic, company, ticker…
2. Validate Input (If): checks a condition and branches into true / false
3. Search Google via Serper (HTTP Request): calls google.serper.dev (POST)
4. Fetch News Articles (HTTP Request): calls newsapi.org
5. Fetch Market Data (HTTP Request): calls alphavantage.co
6. Return Validation Error (Respond to Webhook): sends the response back to the webhook caller
7. Merge and Clean Data (Code): runs custom JavaScript code
8. Claude Pass 1 Research Synthesis (HTTP Request): calls api.anthropic.com (POST)
9. Extract Pass 1 Output (Code): runs custom JavaScript code
10. Wait: pauses before continuing

…plus 9 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: google.serper.dev, newsapi.org, alphavantage.co, api.anthropic.com, googleapis.com, api.sendgrid.com

Before you upgrade to n8n 3.0

Nodes used (8)

• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• Respond to Webhookn8n-nodes-base.respondToWebhook
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Waitn8n-nodes-base.wait

From the author

This workflow is a fully automated AI-powered business intelligence agent. It accepts a research topic or company name via webhook, autonomously collects data from multiple live sources (web search, news feeds, financial APIs), runs a multi-stage Claude AI…

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