Overview ✨
This template **finds businesses on Google Maps → writes to Google Sheets → enriches + verifies email contact so your outreach stays clean and deliverable. It includes Sticky Notes to explain the flow and setup.
What it does 🔎➡️📄➡️✅
- Search & save: Fetch places and append rows (Name, Address, Website, Rating, Phone) to your sheet.
- Enrich: Ask an LLM (Perplexity) for
Email
+ a short company Background
.
- Verify emails: For Email Verification we use VerificarEmails to validate every email address before writing back (fewer bounces, less blocking).
ℹ️ VerificarEmails node: install the community node @verificaremails/n8n-nodes-verificaremails
(Settings → Community Nodes) and use it until it’s approved as a core node. ✨
Youtube Video
Requirements 🔐
- Use n8n Credentials for: Google Sheets, Perplexity (Bearer), and VerificarEmails.
- Keep prompts short and
temperature: 0
to lower cost.
- Create a Google Sheet with the following headers: UUID, Name, Address, Website, Rating Email, Valid, Email, Phone, Valid Phone, Summary
How to run ▶️
- Set your search params (query, locale, pages).
- Run the flow: it saves results → enriches → verifies emails → updates the sheet.
- If the read/update step doesn’t run, ensure the finalization (Done) path and the correct sheet/tab are selected.
Why verify? ✉️🧹
Bad emails cause bounces, throttling, and blocks. Verifying first protects sender reputation and improves deliverability.
Beyond emails, VerificarEmails also offers **phone, names. Check Email Validation API documentation to better understand verification results.