Enrich Company Firmographic Data in Google Sheets with Explorium MCP

Google Sheets Company Enrichment with Explorium MCP

Template

Download the following json file and import it to a new n8n workflow:

google_sheets_enrichment.json

Overview

This n8n workflow template enables automatic enrichment of company information in your Google Sheets. When you add a new company or update existing company details (name or website), the workflow automatically fetches additional business intelligence data using Explorium MCP and updates your sheet with:

Business ID NAICS industry code Number of employees (range) Annual revenue (range)

Key Features

Automatic Triggering**: Monitors your Google Sheet for new rows or updates to company name/website fields Smart Processing**: Only processes new or modified rows, not the entire sheet Data Validation**: Ensures both company name and website are present before processing Error Handling**: Processes each row individually to prevent one failure from affecting others Powered by AI**: Uses Claude Sonnet 4 with Explorium MCP for intelligent data enrichment

Prerequisites

Before setting up this workflow, ensure you have:

n8n instance (self-hosted or cloud) Google account with access to Google Sheets Anthropic API key for Claude Explorium MCP API key

Installation & Setup

Step 1: Import the Workflow

Create a new workflow. Download the workflow JSON from above. In your n8n instance, go to Workflows → Add Workflow → Import from File Select the JSON file and click Import

Step 2: Create Google Sheet

Create a new google sheet (or make a copy of this template) Your Google Sheet must have the following columns (exact names):

name - Company name website - Company website URL business_id - Will be populated by the workflow naics - Will be populated by the workflow number_of_employees_range - Will be populated by the workflow yearly_revenue_range - Will be populated by the workflow

Step 3: Configure Google Sheets Credentials

You'll need to set up two Google credentials:

Google Sheets Trigger Credentials:

Click on the Google Sheets Trigger node Under Credentials, click Create New If working on n8n Cloud, Click the 'Sign in with Google' button

Grant permissions to read and monitor your Google Sheets If working on n8n Instance, Follow the OAuth2 authentication process here Fill the Client ID and Client Secret fields

Google Sheets Update Credentials:

Click on the Update Company Row node Under Credentials, select the same credentials or create new ones (The same you did above) Ensure permissions include write access to your sheets

Step 4: Configure Anthropic Credentials

Click on the Anthropic Chat Model node Under Credentials, click Create New Enter your Anthropic API key

Save the credentials

Step 5: Configure Explorium MCP Credentials

Click on the MCP Client node Under Credentials, click Create New (Header Auth) Fill the Name field with api_key Fill the Value field with your Explorium API Key

Save the credentials

Step 6: Link Your Google Sheet

In the Google Sheets Trigger node:

Select your Google Sheet from the dropdown Select the worksheet (usually "Sheet1")

In the Update Company Row node: Select the same Google Sheet and worksheet Ensure the matching column is set to row_number

Step 7: Activate the Workflow

Click the Active toggle in the top right to activate the workflow The workflow will now monitor your sheet every minute for changes

How It Works

Workflow Process Flow

Google Sheets Trigger: Polls your sheet every minute for new rows or changes to name/website fields Filter Valid Rows: Validates that both company name and website are present Loop Over Items: Processes each company individually AI Agent: Uses Explorium MCP to: Find the company's business ID Retrieve firmographic data (revenue, employees, NAICS code) Format Output: Structures the data for Google Sheets Update Company Row: Writes the enriched data back to the original row

Trigger Behavior

First Activation**: May process all existing rows to establish a baseline Ongoing Operation**: Only processes new rows or rows where name/website fields change Polling Frequency**: Checks for changes every minute

Usage

Adding New Companies

Add a new row to your Google Sheet Fill in the name and website columns Within 1 minute, the workflow will automatically: Detect the new row Enrich the company data Update the remaining columns

Updating Existing Companies

Modify the name or website field of an existing row The workflow will re-process that row with the updated information All enrichment data will be refreshed

Monitoring Executions

In n8n, go to Executions to see workflow runs Each execution shows: Which rows were processed Success/failure status Detailed logs for troubleshooting

Troubleshooting

Common Issues

All rows are processed instead of just new/updated ones

Ensure the workflow is activated, not just run manually Manual test runs will process all rows First activation may process all rows once

No data is returned for a company

Verify the company name and website are correct Check if the company exists in Explorium's database Some smaller or newer companies may not have data available

Workflow isn't triggering

Confirm the workflow is activated (Active toggle is ON) Check that changes are made to the name or website columns Verify Google Sheets credentials have proper permissions

Authentication errors

Re-authenticate Google Sheets credentials Verify Anthropic API key is valid and has credits Check Explorium Bearer token is correct and active

Error Handling

The workflow processes each row individually, so if one company fails to enrich:

Other rows will still be processed The failed row will retain its original data Check the execution logs for specific error details

Best Practices

Data Quality: Ensure company names and websites are accurate for best results Website Format: Include full URLs (https://example.com) rather than just domain names Batch Processing: The workflow handles multiple updates efficiently, so you can add several companies at once Regular Monitoring: Periodically check execution logs to ensure smooth operation

API Limits & Considerations

Google Sheets API**: Subject to Google's API quotas Anthropic API**: Each enrichment uses Claude Sonnet 4 tokens Explorium MCP**: Rate limits may apply based on your subscription

Support

For issues specific to:

n8n platform**: Consult n8n documentation or community Google Sheets integration**: Check n8n's Google Sheets node documentation Explorium MCP**: Contact Explorium support for API-related issues Anthropic/Claude**: Refer to Anthropic's documentation for API issues

Example Use Cases

Sales Prospecting: Automatically enrich lead lists with company size and revenue data Market Research: Build comprehensive databases of companies in specific industries Competitive Analysis: Track and monitor competitor information Investment Research: Gather firmographic data for potential investment targets