🎣 Enrich company profiles with Explorium MCP and Claude AI for GTM research

693 views · 🎣 Lead Generation & Enrichment

💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

View All Scrapers

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:

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

🧩 Extracted Fields

Each company is enriched with:


📥 Input Sheet Format

input
Explorium
n8n
Apple

📤 Output Sheet Format

domainlinkedinUrlhas_free_trialcheapest_planhas_enterprise_planlast_case_study_linkmarketintegrationsenrichment_status
Explorium.aihttps://linkedin.com/company/TRUE69TRUEhttps://www.explorium.comB2B[“HubSpot”, “Zapier”, “Salesforce”, …]done
n8n.iohttps://linkedin.com/company/TRUE20TRUEhttps://n8n.io/case-studiesB2B[“Slack”, “Gmail”, “MySQL”, “Google Sheets”, …]done

🛠️ Tools Used


📦 How to Set It Up

  1. Add your company domains or names to the input sheet
  2. Configure your MCP and SerpAPI credentials in n8n
  3. Run the workflow using the Test Workflow trigger
  4. 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


🧠 Notes

🔗 Nodes Used

Google Sheets, AI Agent, Anthropic Chat Model, Structured Output Parser, Call n8n Workflow Tool, MCP Client Tool

📥 Import

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

📖 Importing guide · 🔑 Credential setup