{"product_id":"auto-enrich-company-numbers-in-airtable-with-n8n-workflow","title":"Auto-Enrich Company Numbers in Airtable with n8n Workflow","description":"\u003cp\u003eStop manually hunting for company phone numbers across the web. This \u003cstrong\u003en8n workflow automatically enriches your Airtable company database\u003c\/strong\u003e by scraping phone numbers from websites, LinkedIn, and Google Maps using AI-powered extraction and multiple intelligent fallback sources.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis automation transforms your incomplete company records into fully enriched contact databases through a sophisticated multi-step process:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSmart data retrieval:\u003c\/strong\u003e Fetches all Airtable records missing phone numbers via manual trigger\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWebsite scraping:\u003c\/strong\u003e Uses Firecrawl to extract and clean website content as structured markdown\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAI-powered extraction:\u003c\/strong\u003e Claude Sonnet AI agent analyzes scraped content to identify phone numbers with structured output parsing\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLinkedIn fallback:\u003c\/strong\u003e Apify LinkedIn scraper searches company profiles when website scraping fails\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGoogle Maps backup:\u003c\/strong\u003e Final fallback uses Apify Google Maps scraper with company name and location data\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAutomated updates:\u003c\/strong\u003e Normalizes found phone numbers and writes back to Airtable, marking unavailable records appropriately\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSales team automation:\u003c\/strong\u003e Enrich prospect databases with missing contact information for outbound campaigns\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLead generation agencies:\u003c\/strong\u003e Scale client deliverables by automatically completing company contact data\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGrowth operations:\u003c\/strong\u003e Maintain comprehensive company databases without manual research overhead\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCRM data enhancement:\u003c\/strong\u003e Fill gaps in existing customer and prospect records systematically\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cp\u003eBuilt with essential n8n nodes including Airtable integration, HTTP requests, custom code nodes, conditional logic, and manual triggers. Leverages \u003cstrong\u003eFirecrawl community node\u003c\/strong\u003e for web scraping, Claude AI for intelligent data extraction, and Apify scrapers for LinkedIn and Google Maps fallback sources.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003e⚠️ Self-hosted requirement:\u003c\/strong\u003e This workflow uses the Firecrawl community node and cannot run on n8n Cloud - requires self-hosted n8n installation.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45501588144307,"sku":"N8N-15650","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sn8nEa84cuA-lOcuN4JMV_4fefd5e285474ab9ae6a408a44bfcc97.jpg?v=1778576434","url":"https:\/\/buyflowscripts.com\/products\/auto-enrich-company-numbers-in-airtable-with-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}