Enrich new HubSpot companies with Google Maps data
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.
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.
Additional information
What does this prompt do?
- The moment a new company is created in HubSpot, find its Google Maps listing and pull website, phone, full address, star rating, review count, and any public emails or social profiles.
- Write the enriched fields straight back to the HubSpot company record so your SDRs don't have to look anything up by hand.
- Post a qualified lead summary to Slack when the rating clears your bar, or flag the company as low signal when it doesn't.
- Replace the manual lookup that sales reps do dozens of times a day every time an inbound shows up.
What do I need to use this?
- A HubSpot account with permission to update company records.
- A Local Business Data account (the Google Maps data provider on RapidAPI) for the lookup.
- A Slack workspace and a channel where the agent can post summaries.
- Custom HubSpot company properties for Google rating and review count. The workflow author can walk you through creating them if they don't exist yet.
How can I customize it?
- Change the rating and review count thresholds that separate a qualified lead from a low signal one.
- Pick which Slack channel gets the summaries, or split qualified and low signal into two different channels.
- Choose which HubSpot fields you want filled in. Some teams want phone and address only, others want the full social and email pull.
- Decide whether the agent should leave existing HubSpot values alone or always trust the Google Maps version.
Frequently asked questions
What happens if there is no matching Google Maps listing?
What if Google Maps returns several listings with the same name?
Can I run this on new contacts or deals instead of new companies?
Will this overwrite data my team already filled in?
Does this work on HubSpot Free?
Stop letting SDRs babysit Google Maps.
Connect HubSpot, Slack, and Local Business Data once, and every new company gets enriched and triaged the moment it lands in your CRM.