Quick overview
This workflow collects a location, search term, and industry from an n8n form, scrapes matching businesses from Google Maps via Apify, deduplicates and upserts companies into HubSpot, then uses Hunter to find contact emails for each domain and upserts the contacts into HubSpot.
How it works
- Starts when a user submits the n8n form with a location, what to scrape, item limit, and a HubSpot industry selection.
- Maps the chosen industry label to the exact industry code HubSpot expects and runs the Apify Google Maps Scraper actor with the form inputs.
- Checks the Apify run status and, if successful, loads the actor’s dataset items.
- Extracts the key business fields (name, category, rating, address, phone, website/domain, and industry) and removes duplicate companies using a domain-based key.
- Searches HubSpot for an existing company by domain and updates it if found or creates a new company if not.
- For companies with a domain, uses Hunter Domain Search to find personal email contacts, deduplicates them by email, and upserts the contacts into HubSpot associated with the company.
Setup
- Add an Apify API token and ensure you have access to the Apify actor “Google Maps Scraper (compass/crawler-google-places)”.
- Add a HubSpot Private App token (HubSpot app token credential) with permission to create, update, and search companies and create/update contacts.
- Add a Hunter API key for Domain Search.
- Review the form defaults (locations, scrape query, item count, and industry list) and update them to match your target markets and HubSpot industry requirements.