Extract Business Contact Info from Google Maps to Google Sheets with Regex

Description

Who’s it for

This template is perfect for marketers, sales teams, and entrepreneurs who need verified business leads without spending hours on manual research. If you’re running outreach campaigns, selling B2B services, or building prospect databases, this workflow saves you time and ensures your lead list is always fresh.

How it works

Start with a Google Maps search for a chosen business type and location (e.g., “Call centers in New York”).
The workflow scrapes raw data, extracting business names, phone numbers, addresses, websites, and emails.
Using regex logic, it filters and cleans data, ensuring valid contact details.
Finally, it exports all leads into Google Sheets, giving you a ready-to-use contact list for outreach or CRM import.

How to set up

Replace the placeholder values in the Set Form Fields node with your target industry and location.
Connect your Google Sheets account and provide the sheet ID.
Run the workflow to start building your lead list.

Requirements

Google Sheets credentials
Business type + location input
How to customize the workflow

Change the max_results field to control the number of businesses scraped.
Add extra regex filters to capture more fields (e.g., social links).
Integrate with your CRM or email platform to send leads directly to your outreach pipeline.