Enrich Google Maps business leads with emails using SerpApi and Airtable
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 27 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Airtable and Serpapi (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Retrieve Searches from Airtable (Airtable): search
- Initiate Pages Batch (Loop Over Items (Split in Batches)): loops over the items in batches
- Perform Google Maps Search (Serp Api): google maps
- Replicate Search Queries (Edit Fields (Set)): sets 2 fields: Search Query, GPS Coordinates
- Process SerpAPI Results (Code): runs custom JavaScript code
- Initialize Search Query (Edit Fields (Set)): sets 3 fields: Search Query, GPS Coordinates, Start
- Remove Duplicate Entries (Code): runs custom JavaScript code
- Verify Website Existence (If): checks a condition and branches into true / false
- Combine Email and Map Data (Merge): merges the data from its input branches
- Set Subpage URLs (Edit Fields (Set)): sets 7 fields: website, website - contact, website - contact-us…
…plus 16 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-serpapi is verified or supports 3.0 (used in Perform Google Maps Search).
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Airtable
n8n-nodes-base.airtable - Serp Api
n8n-nodes-serpapi.serpApi
From the author
Quick overview This workflow pulls Google Maps business results from SerpApi based on search queries stored in Airtable, visits each business website to extract contact emails, and adds the enriched business records back into Airtable. How it works 1. Runs…