Weekly local lead prospecting from Google Maps into HubSpot

Every Monday at 7am, prospect fresh local leads in my target metros and load the new ones into HubSpot.

Inputs I will configure on the workflow: a list of target rows where each row is a city plus business category (for example, "boutique fitness studios in Austin" or "Italian restaurants in Brooklyn"), the Slack channel for the SDR summary, a minimum rating (default 4.3), and a minimum review count (default 30).

For each city + category row, use the Geolocation Search Places by Text operation to pull a fresh list of matching venues in that city. For every promising result, call Geolocation Get Place Details to fetch phone, website, hours, rating, review count, and address. Skip any place that does not have a website or phone, that has fewer than the configured minimum review count, or that looks like a chain or franchise location (multiple branches under the same brand, a brand website with a store locator, or a known national chain) so the pipeline stays high-signal.

Before creating anything in HubSpot, dedupe each remaining candidate against existing contacts using the HubSpot Search Contacts operation. Match on website domain and phone number. Only candidates with no existing match should move forward.

Create the survivors with the HubSpot Batch Create Contacts operation. Use the business name as the company, set the lifecycle stage to "lead", add a custom property source = "local-prospecting", and populate phone, website, address, city, and a category property with the row's category label. Capture the new contact IDs that come back.

Finish by posting a Slack message to the configured SDR channel using the Slack Send a Message operation. The summary should show: how many new prospects were added per city, the top 3 venues by rating in each city (name, rating, review count), and a direct HubSpot link for each newly created contact so a rep can open it in one click. Also list how many candidates were filtered out as chains, low-review, or duplicates so we can tune the rules.

Trigger: cron, every Monday at 7am in my local time zone.