Auto-Enrich Company Numbers in Airtable with n8n Workflow

Stop manually hunting for company phone numbers across the web. This n8n workflow automatically enriches your Airtable company database by scraping phone numbers from websites, LinkedIn, and Google Maps using AI-powered extraction and multiple intelligent fallback sources.

What this workflow does

This automation transforms your incomplete company records into fully enriched contact databases through a sophisticated multi-step process:

• Smart data retrieval: Fetches all Airtable records missing phone numbers via manual trigger
• Website scraping: Uses Firecrawl to extract and clean website content as structured markdown
• AI-powered extraction: Claude Sonnet AI agent analyzes scraped content to identify phone numbers with structured output parsing
• LinkedIn fallback: Apify LinkedIn scraper searches company profiles when website scraping fails
• Google Maps backup: Final fallback uses Apify Google Maps scraper with company name and location data
• Automated updates: Normalizes found phone numbers and writes back to Airtable, marking unavailable records appropriately

Use cases

• Sales team automation: Enrich prospect databases with missing contact information for outbound campaigns
• Lead generation agencies: Scale client deliverables by automatically completing company contact data
• Growth operations: Maintain comprehensive company databases without manual research overhead
• CRM data enhancement: Fill gaps in existing customer and prospect records systematically

Technical details

Built with essential n8n nodes including Airtable integration, HTTP requests, custom code nodes, conditional logic, and manual triggers. Leverages Firecrawl community node for web scraping, Claude AI for intelligent data extraction, and Apify scrapers for LinkedIn and Google Maps fallback sources.

⚠️ Self-hosted requirement: This workflow uses the Firecrawl community node and cannot run on n8n Cloud - requires self-hosted n8n installation.