Extract Business Contact Info from Google Maps to Google Sheets with Regex
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.
Related Templates
Automate Customer Support & Calendar Bookings with OpenAI GPT and Google Calendar
Website AI Agent with Calendar Integration Categories: AI Agents, Website Integration, Calendar Automation This workfl...
Automate Sales Pipeline: BuiltWith Technology Data to Trello Lead Cards with Google Sheets
Automated workflow that transforms BuiltWith technology data into actionable sales leads in Trello, creating a visual ...
Send a notification to Slack when a new high-quality lead is added to Hubspot
Use Case When tracking your contacts and leads in Hubspot CRM, every new contact might be a potential customer. To guara...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments