Enrich Company Profiles with Explorium MCP and Claude AI for GTM Research

Description

🕵️ Company Research Agent (n8n + Explorium + LLM)

This n8n workflow automates company research by combining Explorium’s MCP server, web scraping tools, and an AI agent. Results are written to a Google Sheet for easy use in GTM, product analysis, or competitive research.

🚀 What It Does

Given a list of company domains or names, this workflow will:

Look up company information using:
🧠 LLM Agent to guide the research
🔎 Explorium MCP Server for firmographic & tech signals
🌐 Website content and SerpAPI scraping (optional)
Extract key commercial details (see below)
Format the output in a consistent JSON structure
Update a connected Google Sheet with the enriched results

🧩 Extracted Fields

Each company is enriched with:

domain
linkedinUrl
has_free_trial
cheapest_plan
has_enterprise_plan
last_case_study_link
market (e.g., B2B or B2C)
integrations (e.g., Slack, Hubspot, MySQL)
enrichment_status

📥 Input Sheet Format

| input |
|-------------|
| Explorium |
| n8n |
| Apple |
| ... |

📤 Output Sheet Format

| domain | linkedinUrl | has_free_trial | cheapest_plan | has_enterprise_plan | last_case_study_link | market | integrations | enrichment_status |
|--------------|----------------------------------|----------------|----------------|----------------------|-----------------------------|--------|---------------------------------------------------|-------------------|
| Explorium.ai | https://linkedin.com/company/... | TRUE | 69 | TRUE | https://www.explorium.com | B2B | ["HubSpot", "Zapier", "Salesforce", ...] | done |
| n8n.io | https://linkedin.com/company/... | TRUE | 20 | TRUE | https://n8n.io/case-studies | B2B | ["Slack", "Gmail", "MySQL", "Google Sheets", ...] | done |

🛠️ Tools Used

n8n** (Automation platform)
Explorium MCP Server** – rich company enrichment via API
Anthropic Claude or OpenAI** – used by the AI researcher
Google Sheets** – stores output data
Structured Output Parser** – ensures clean, predictable JSON formatting

📦 How to Set It Up

Add your company domains or names to the input sheet
Configure your MCP and SerpAPI credentials in n8n
Run the workflow using the Test Workflow trigger
Watch the sheet populate with results

You can adapt the system to output different formats or fields depending on your team's research goals.

📌 Use Cases

Competitive landscape analysis
Lead intelligence for outbound campaigns
Feature benchmarking (e.g., who offers enterprise or free trial)
VC/investment research

🧠 Notes

This agent is easily customizable. Adjust the LLM prompt or Output Parser to extract different properties.
Explorium MCP is leveraged as the core enrichment engine, ensuring signal accuracy and freshness.