Every Monday, posts the week's new HubSpot leads to Slack: how many, how that compares to last week, and who they are.
Uses
HubSpot
Slack
Weekly HubSpot lead report to Slack
Run every Monday at 07:00.Run every Monday at 07:00.
Set slackChannelId to blank.Set slackChannelId to blank.Set leadLimit to 500.Set leadLimit to 500.Set maxNamed to 12.Set maxNamed to 12.
Get the date 7 days before the current date and time and save it as weekStart.Get the date 7 days before the current date and time and save it as weekStart.Get the date 7 days before weekStart and save it as priorWeekStart.Get the date 7 days before weekStart and save it as priorWeekStart.HubSpotFind contacts created since weekStart. Save it as newLeads.Find contacts created since weekStart. Save it as newLeads.HubSpotFind contacts created since priorWeekStart. Save it as priorLeads.Find contacts created since priorWeekStart. Save it as priorLeads.Set newLeadCount to newLeads.total.Set newLeadCount to newLeads.total.
Set leadChange to newLeadCount minus priorLeads.total.Set leadChange to newLeadCount minus priorLeads.total.
Calculate the absolute value of leadChange and save it as leadSwing.Calculate the absolute value of leadChange and save it as leadSwing.Set percentNote to blank.Set percentNote to blank.
If priorLeads.total is greater than 0If priorLeads.total is greater than 0Yes
Set swingRatio to leadSwing divided by priorLeads.total.Set swingRatio to leadSwing divided by priorLeads.total.Format swingRatio as a percentage with 0 decimal places and save it as swingPercent.Format swingRatio as a percentage with 0 decimal places and save it as swingPercent.
Change percentNote to (swingPercent).Change percentNote to (swingPercent).No
No steps
Set momentum to level with the week before.Set momentum to level with the week before.If leadChange is greater than 0If leadChange is greater than 0Yes
Change momentum to up leadSwing@percentNote on the week before.Change momentum to up leadSwing@percentNote on the week before.Else if @leadChange is less than 0
Change momentum to down leadSwing@percentNote on the week before.Change momentum to down leadSwing@percentNote on the week before.Otherwise
No steps
Run Python code on contacts, window_start, max_named, has_more, and total_count and save it as digest.Run Python code on contacts, window_start, max_named, has_more, and total_count and save it as digest.Make weekStart readable as “November 2, 2026” and save it as weekLabel.Make weekStart readable as “November 2, 2026” and save it as weekLabel.
Build the text *New HubSpot leads, week of @weekLabel* @newLeadCount new contacts, @momentum. @digest.body and save it as reportText.Build the text *New HubSpot leads, week of @weekLabel* @newLeadCount new contacts, @momentum. @digest.body and save it as reportText.SlackSend a message to slackChannelId. Save it as posted.Send a message to slackChannelId. Save it as posted.reportText