Automated collection of contacts from Google Maps via Make.com

Developed a fully automated workflow for collecting and enriching contact information about companies from Google Maps based on specified keywords and geolocation. The solution eliminates the need for manual searching and significantly speeds up the lead generation process for marketing and sales departments.

How it works:

Data input: The user fills out a Fillout form with search parameters.

Data collection: A scenario in Make (Integromat) makes a request to the Google Places API and retrieves the company name, address, and website.

Data enrichment: If the website is found, the system extracts email addresses, phone numbers, and social media links through RapidAPI Website ContactCrawler.

Data processing: The results are cleaned, structured, and formatted into a CSV file.

Data delivery: The file is automatically uploaded to Airtable, and the application status is changed to Complete.

Key results:

Time savings: Reducing the contact collection process from hours to minutes

Scalability: Processing hundreds of records in a single run

Accuracy: Selecting only relevant domains (excluding social media and forms) to obtain valid leads

Integration: Full synchronization with Airtable for convenient tracking of applications

Technologies used:
Make, Google Places API, RapidAPI (Website ContactCrawler), Airtable, Fillout Forms