Enrich new HubSpot companies with Google Maps data

By General Input

When a new company lands in HubSpot, pull its website, phone, address, rating, and contacts from Google Maps, write it back, and post the lead to Slack.

Integrations

  • HubSpot
  • Local Business Data
  • Slack

Type

Agentic Task

Categories

  • Sales
  • Operations

Build me an agent workflow that auto-enriches every new HubSpot company with Google Maps data and routes it to my SDR team in Slack. The whole point is replacing the manual look-it-up-on-Google-Maps-and-paste-it-into-HubSpot step my reps do dozens of times a day.

Trigger: a HubSpot webhook that fires whenever a new company is created. Pass the company id, company name, city, state or region, country, and any existing website / domain into the agent.

Agent instructions:

1. Use Local Business Data's Search to find the matching Google Maps listing. Build the query from the company name plus city and region from the HubSpot payload (for example, "Acme Coffee Roasters Austin TX"). Set extract_emails_and_contacts to true so emails and social profiles come back in the same call.

2. Pick the best match. If multiple candidates come back, compare each candidate's website domain against the HubSpot company's domain first, then fall back to address / city match. If you still cannot decide confidently (no domain match, multiple candidates in the same city, etc.), do not pick. Skip to the Slack step and post a "could not confidently match" note with the top two or three candidates and stop.

3. Call Local Business Data's Business Details on the chosen business_id with extract_emails_and_contacts=true to confirm the full record: website, phone_number, full_address, rating, review_count, plus any emails_and_contacts (emails, social profiles).

4. Call HubSpot's Update Company on the company id from the webhook with these properties: website, phone, address, city, state, zip, country, description (a one-liner summarizing the Google Maps profile), and two custom properties google_rating (number) and google_review_count (number). Only fill blank HubSpot fields by default; do not overwrite values the team has already entered.

5. Decide qualified vs low signal. If rating is below 3.5 OR review_count is below 10, treat it as low signal. Otherwise it's qualified.

6. Use Slack's Send a Message to post into the SDR channel. For qualified leads, post a short summary with the company name, city, rating and review count, website, phone, top emails / social profiles found, and a link to the HubSpot company record. For low signal leads, post a one-line "low-signal lead" note with the rating, review count, and the HubSpot link so an SDR can decide whether to research further.

Make the Slack channel, the qualified-vs-low-signal thresholds, and the list of HubSpot fields to enrich easy for me to change later without editing prompts.

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentLocal listing health board for every location you manageWin back LiveChat visitors whose chats went unansweredTurn Mailjet email clicks into ranked HubSpot follow-upsiMessage campaign console with pre-flight checks and delivery boardChat quality review board for LiveChat support leadsA searchable RFP answer library your bid team drafts fromSee which target accounts just started advertising on LinkedInAccount health board that puts product usage next to your CRMLook up a customer's full chat history mid conversation