{"product_id":"de-duplicate-hubspot-companies-from-google-maps-via-basedonbusiness","title":"De-duplicate HubSpot Companies from Google Maps via BasedOnBusiness","description":"\u003ch3\u003eDe-duplicate HubSpot Companies from Google Maps automatically using BasedOnBusiness\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls Google Maps business leads via \u003cstrong\u003eBasedOnBusiness\u003c\/strong\u003e, filters for established companies with websites, and \u003cstrong\u003ecreates only new company records in HubSpot\u003c\/strong\u003e—skipping duplicates by checking the company’s domain.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives search criteria\u003c\/strong\u003e from an n8n form submission (category, city, country code, lead count, and minimum reviews).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts a BasedOnBusiness scrape job\u003c\/strong\u003e for the Google Maps query and polls \u003cstrong\u003eevery 15 seconds\u003c\/strong\u003e until the job finishes or fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetrieves and splits\u003c\/strong\u003e the scrape results into individual business items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters out\u003c\/strong\u003e businesses that are permanently closed, missing a website, or below the minimum review threshold.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes websites into a bare domain\u003c\/strong\u003e and prepares HubSpot company fields (name, domain, website, phone, address, city, country, plus a Google Maps facts description).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDe-duplicates in HubSpot by domain\u003c\/strong\u003e: for each business, the workflow searches HubSpot for an existing company with the same domain and \u003cstrong\u003ecreates a new company only when no match is found\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLead sourcing teams want fresh Google Maps companies in HubSpot without duplicates.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators enrich CRM accounts by converting map results into structured company records.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers running repeated searches for categories\/cities need consistent de-duplication.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBasedOnBusiness integration\u003c\/strong\u003e (HTTP Bearer Auth): requires \u003ccode\u003escrapes:read\u003c\/code\u003e and \u003ccode\u003escrapes:write\u003c\/code\u003e scopes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHubSpot integration\u003c\/strong\u003e: uses a HubSpot App Token with \u003ccode\u003ecrm.objects.companies.read\u003c\/code\u003e and \u003ccode\u003ecrm.objects.companies.write\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: if, code, no op, wait, filter, hubspot—used to control scraping, polling, filtering, normalization, and company creation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cem\u003eResult: cleaner HubSpot CRM data with Google Maps leads—without duplicate company records.\u003c\/em\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45877617426611,"sku":"N8N-18562","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lRhOQRbBNYSwtq91ecvIf_tPsb5cjC.png?v=1787337166","url":"https:\/\/buyflowscripts.com\/products\/de-duplicate-hubspot-companies-from-google-maps-via-basedonbusiness","provider":"N8N Commerce","version":"1.0","type":"link"}