De-duplicate HubSpot Companies from Google Maps via BasedOnBusiness

De-duplicate HubSpot Companies from Google Maps automatically using BasedOnBusiness

This n8n workflow pulls Google Maps business leads via BasedOnBusiness, filters for established companies with websites, and creates only new company records in HubSpot—skipping duplicates by checking the company’s domain.

What this workflow does

• Receives search criteria from an n8n form submission (category, city, country code, lead count, and minimum reviews).
• Starts a BasedOnBusiness scrape job for the Google Maps query and polls every 15 seconds until the job finishes or fails.
• Retrieves and splits the scrape results into individual business items.
• Filters out businesses that are permanently closed, missing a website, or below the minimum review threshold.
• Normalizes websites into a bare domain and prepares HubSpot company fields (name, domain, website, phone, address, city, country, plus a Google Maps facts description).
• De-duplicates in HubSpot by domain: for each business, the workflow searches HubSpot for an existing company with the same domain and creates a new company only when no match is found.

Use cases

• Lead sourcing teams want fresh Google Maps companies in HubSpot without duplicates.
• SaaS operators enrich CRM accounts by converting map results into structured company records.
• Automation engineers running repeated searches for categories/cities need consistent de-duplication.

Technical details

• BasedOnBusiness integration (HTTP Bearer Auth): requires scrapes:read and scrapes:write scopes.
• HubSpot integration: uses a HubSpot App Token with crm.objects.companies.read and crm.objects.companies.write.
• n8n nodes/logic: if, code, no op, wait, filter, hubspot—used to control scraping, polling, filtering, normalization, and company creation.

Result: cleaner HubSpot CRM data with Google Maps leads—without duplicate company records.