Send hot Hightouch leads to the right AE in Slack hourly

Every hour during business hours (9am to 6pm in my local timezone, Monday through Friday), watch my Hightouch lead-scoring sync into HubSpot and route freshly activated high-intent contacts to the right account executive in Slack with a personalized opener.

Step 1. Use Hightouch's List Syncs to find my lead-scoring sync by name or slug (default: 'lead_score_to_hubspot'). Make the sync name or slug a configurable input.

Step 2. Use Hightouch's List Sync Runs for that sync to look at the most recent successful run. If no new successful run has completed since the last time this workflow executed, exit quietly with no Slack messages. Otherwise note the run's startedAt, finishedAt, and the rows-added count.

Step 3. If new rows were pushed in that run, use HubSpot's Search Contacts to fetch contacts where hubspotscore is greater than or equal to a configurable threshold (default 80) and lastmodifieddate is between the run's startedAt and finishedAt. Return useful properties: firstname, lastname, company, jobtitle, hubspotscore, hubspot_owner_id, and any signal properties I track (recent_form_submission, recent_page_views, last_demo_request, etc.).

Step 4. For each unique hubspot_owner_id, use HubSpot's Get Owner to look up the AE's name and email. Group the qualified contacts by owner.

Step 5. For each owner with at least one new hot lead, use Slack Bot's Open a Conversation to start or resume a DM with that AE (resolve by email), then use Slack Bot's Send a Message to send a compact list of their new leads (contact name, company, score, key signals) plus a 2-3 sentence draft opener tailored to what tipped the score (recent demo request, pricing page visits, job change, etc.). Skip any owner with no new leads so we never spam.

Step 6. After all DMs are sent, use Slack Bot's Send a Message to post a single summary in a shared revops Slack channel (configurable, default #revops) listing how many leads went to which AE so the team has a paper trail.

Make these configurable inputs: the Hightouch sync name or slug, the score threshold, the business-hours window and timezone, the revops summary channel, and an optional override map from HubSpot owner email to Slack user ID for AEs whose work email differs from their Slack email.