Scrape Google Maps data & discover email addresses with SerpAPI and EmailListVerify
Needs changesWhat this workflow does
This workflow has 17 nodes and runs on a schedule (every week) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls serpapi.com and api.emaillistverify.com over HTTP.
How it runs
Trigger: On a schedule (every week) (plus 1 other trigger).
- Google Sheets: uses Google Sheets
- Extract keyword and location from URL (Edit Fields (Set)): sets or maps fields
- SERPAPI - Scrape Google Maps URL (HTTP Request): calls serpapi.com
- Extract next start value (Code): runs custom JavaScript code
- Continue IF Loop is complete (If): checks a condition and branches into true / false
- Merge all values from SERPAPI (Code): runs custom JavaScript code
- Split out items (Item Lists): reshapes item lists (legacy Item Lists node)
- Remove empty values (Filter): keeps only the items that match a condition
- Transform data in the right format (Code): runs custom JavaScript code
- Remove duplicate items (Item Lists): reshapes item lists (legacy Item Lists node)
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: serpapi.com, api.emaillistverify.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Item Lists (legacy) in Remove duplicate items, Split out items: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Remove duplicate items, Split out items | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Item Lists
n8n-nodes-base.itemLists - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
This workflow allows to : - scrape Google Maps data using SerpAPI - discovery generic email addresses like contact@ using EmailListVerify API Who’s it for This template is designed to prepare cold outreach for local businesses like restaurants or hotels (you…