Enrich Airtable company phones from website, LinkedIn, Google Maps, and Claude

⚠️ Self-hosted only — This template uses a community node (Firecrawl) and cannot run on n8n Cloud.

> 📸 Add a workflow screenshot at the top of this listing.

Who it's for

This workflow is for sales teams, lead generation agencies, and growth operators who maintain a company database in Airtable and need to automatically enrich records with phone numbers from multiple web sources.

How it works

1. A manual trigger fetches all Airtable records where the phone number field is empty. 2. Records are processed one by one through a loop. 3. Each company's website is scraped using Firecrawl, and the raw markdown is cleaned with a custom code node. 4. A Claude Sonnet AI agent analyzes the cleaned content and attempts to extract a phone number using a structured output parser. 5. If the AI finds no phone, the workflow falls back to an Apify LinkedIn scraper, first checking whether the company profile exists. 6. If LinkedIn also yields nothing, a second fallback calls an Apify Google Maps scraper to search by company name and location. 7. Whichever source returns a phone number, a code node normalizes the data and writes it back to Airtable. If no source finds a phone, the record is marked as unavailable.

How to set up

- [ ] Connect your Airtable credentials and set the correct base and table in the Search Airtable Records, Update Airtable Phone Found, and Update Airtable Phone Not Found nodes - [ ] Add your Firecrawl API key to the Scrape Company Website node - [ ] Add your Anthropic API key to the Claude Sonnet Model sub-node inside AI Phone Finder Agent - [ ] Add your Apify API token to both the Fetch LinkedIn Phone via Apify and Fetch Google Maps Phone via Apify nodes - [ ] Review the Clean Scraped Markdown and Refine and Merge Phone Data code nodes to ensure field names match your Airtable schema