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: 1. n8n instance (self-hosted or cloud) 2. Google account with access to Google Sheets 3. Anthropic API key for Claude 4. Explorium MCP API key <br / Installation & Setup Step 1: Import the Workflow 1. Create a new workflow. 2. Download the workflow JSON from above. 3. In your n8n instance, go to Workflows → Add Workflow → Import from File 4. Select the JSON file and click Import Step 2: Create Google Sheet 1. Create a new google sheet (or make a copy of this template) 2. Your Google Sheet must have the following columns (exact names): name - Company name website - Company website URL businessid - Will be populated by the workflow naics - Will be populated by the workflow numberofemployeesrange - Will be populated by the workflow yearlyrevenuerange - Will be populated by the workflow <br / Step 3: Configure Google Sheets Credentials You'll need to set up two Google credentials: Google Sheets Trigger Credentials: 1. Click on the Google Sheets Trigger node 2. Under Credentials, click Create New 3. If working on n8n Cloud, Click the 'Sign in with Google' button ! 4. Grant permissions to read and monitor your Google Sheets 5. If working on n8n Instance, Follow the OAuth2 authentication process here 6. Fill the Client ID and Client Secret fields ! Google Sheets Update Credentials: 1. Click on the Update Company Row node 2. Under Credentials, select the same credentials or create new ones (The same you did above) 3. Ensure permissions include write access to your sheets Step 4: Configure Anthropic Credentials 1. Click on the Anthropic Chat Model node 2. Under Credentials, click Create New 3. Enter your Anthropic API key ! 4. Save the credentials Step 5: Configure Explorium MCP Credentials 1. Click on the MCP Client node 2. Under Credentials, click Create New (Header Auth) 3. Fill the Name field with apikey 4. Fill the Value field with your Explorium API Key ! 4. Save the credentials Step 6: Link Your Google Sheet 1. In the Google Sheets Trigger node: Select your Google Sheet from the dropdown Select the worksheet (usually "Sheet1") ! 2. In the Update Company Row node: Select the same Google Sheet and worksheet Ensure the matching column is set to rownumber ! Step 7: Activate the Workflow 1. Click the Active toggle in the top right to activate the workflow 2. The workflow will now monitor your sheet every minute for changes How It Works Workflow Process Flow 1. Google Sheets Trigger: Polls your sheet every minute for new rows or changes to name/website fields 2. Filter Valid Rows: Validates that both company name and website are present 3. Loop Over Items: Processes each company individually 4. AI Agent: Uses Explorium MCP to: Find the company's business ID Retrieve firmographic data (revenue, employees, NAICS code) 5. Format Output: Structures the data for Google Sheets 6. Update Company Row: Writes the enriched data back to the original row Trigger Behavior First Activati