đź“Š Generate business research reports with Claude, web search and Google Drive

⚡ 27 views · 📊 Market Research & Insights

💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.

View All Scrapers

Description

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 analysis pipeline, and delivers a structured professional business report — all without human intervention.

What’s the Goal?

To eliminate the hours analysts spend manually gathering data, switching between tools, and writing reports. This workflow does it all in under 3 minutes:

Why Does It Matter?

Manual business research is slow, inconsistent, and expensive. This workflow:

How It Works

Stage 1 — INTAKE Webhook receives a research request. Set node normalizes all inputs and stores credentials. IF node validates the request has a valid topic.

Stage 2 — DATA COLLECTION (parallel) Three HTTP Request nodes run simultaneously:

Stage 3 — DATA PROCESSING Code node merges and cleans all collected data. Extracts headlines, snippets, URLs, publication dates, sentiment signals, and key figures into a structured context object ready for AI analysis.

Stage 4 — AI ANALYSIS (3-pass Claude pipeline) Pass 1 — Research Synthesis: Claude reads all raw data and extracts key facts, trends, and signals Pass 2 — Strategic Analysis: Claude performs SWOT analysis, identifies risks and opportunities Pass 3 — Report Generation: Claude writes the final structured executive report in Markdown

Stage 5 — OUTPUT & DELIVERY Report is saved to Google Drive as a document. Summary is posted to Slack. Full report is emailed via SendGrid. All metadata is logged to Google Sheets. Webhook returns JSON response.

Configuration Requirements

Setup Guide

Step 1: Import this workflow into your n8n instance Step 2: Open the Set Credentials node and replace all placeholder values with your real API keys Step 3: Set your GOOGLE_SHEET_ID in the Log to Sheets node Step 4: Set your GOOGLE_DRIVE_FOLDER_ID in the Save to Drive node Step 5: Configure your Slack webhook URL in the Notify Slack node Step 6: Activate the workflow or trigger manually via POST

Sample Request

POST /webhook/business-report { “topic”: “OpenAI market position 2025”, “company”: “OpenAI”, “ticker”: "", “industry”: “Artificial Intelligence”, “reportType”: “competitive_analysis”, “recipientEmail”: “analyst@yourcompany.com”, “urgency”: “standard” }

Report Types Supported

đź”— Nodes Used

Google Sheets, HTTP Request, Webhook

đź“Ą Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup