What This Workflow Does
This n8n workflow solves the tedious manual process of researching company details by automatically enriching domain names in your Google Sheets with comprehensive firmographic data from CompanyEnrich. Instead of spending hours looking up individual companies on LinkedIn, Crunchbase, or corporate websites, this automation pulls verified data directly into your spreadsheet.
The workflow reads domain names from a specified Google Sheet column, queries the CompanyEnrich API for each domain, then writes back enriched data like industry classification, employee count, estimated revenue, technology stack, and social media profiles. This transforms basic contact lists into powerful targeting datasets for sales, marketing, and recruitment teams.
How It Works
1. Trigger from Google Sheets
The workflow starts by reading domain names from a specified column in your Google Sheet. You can configure it to run on a schedule (daily/weekly) or trigger manually when you add new prospects.
2. API Query to CompanyEnrich
Each domain is sent to the CompanyEnrich API which returns structured firmographic data. The workflow handles API authentication and rate limiting automatically.
3. Data Processing & Mapping
Key data points are extracted from the API response and formatted for spreadsheet use. The workflow can handle partial matches and missing data gracefully.
4. Write Back to Google Sheets
Enriched data is written to adjacent columns in your original sheet, maintaining row alignment with the source domains. You control which fields get written and their column positions.
Pro tip: Create a separate 'Enriched' tab in your sheet to preserve original data and track enrichment history over time.
Who This Is For
This workflow is ideal for sales teams building targeted account lists, marketers running account-based campaigns, recruiters sourcing candidates, and business development professionals researching partners or competitors. Any role that benefits from deeper company insights without manual research will find value.
Particularly useful for SaaS companies targeting specific industries, agencies building prospect lists, and startups identifying potential customers or partners. The automation scales from enriching dozens to thousands of companies with consistent formatting.
What You'll Need
- An n8n instance (cloud or self-hosted)
- Google Sheets with company domains in a column
- CompanyEnrich API key (free tier available)
- Edit access to the Google Sheet
Quick Setup Guide
- Download the template JSON file
- Import into your n8n instance
- Connect your Google Sheets account
- Add your CompanyEnrich API key
- Configure the sheet ID and domain column
- Map desired output fields to sheet columns
- Test with a few domains then activate
Key Benefits
Save 5-10 minutes per company by eliminating manual research. Enrich hundreds of records in the time it takes to look up one manually.
Improve targeting accuracy with verified firmographics rather than guesses or outdated directory listings.
Maintain data freshness by scheduling regular enrichment runs as your prospect list grows.
Centralize insights directly in Google Sheets where your team already works, no new tools to learn.
Scale your prospecting without adding research staff. The automation handles the volume whether you're enriching 50 or 5,000 companies.