Pull the weekly pipeline reportHubSpot + Google Sheets + Slack
The Monday metrics ritual, retired.
- Open HubSpot → Deals, filter to this quarter.
- Export the view.
- Open the "GTM Metrics" sheet, paste into a new tab.
- Write a SUMIF for weighted pipeline.
- Copy the total.
- Switch to Slack.
- Type the update in #revenue.
- Query HubSpot deals for the quarter via API.
- Write them to the "GTM Metrics" sheet, this week's row.
- Compute weighted pipeline and flag any deal that slipped a stage.
- Post the digest to #revenue and @-mention the owner of anything stalled.
Trigger · Scheduler, every Monday 08:00. 1. HubSpot · Search deals (all pipelines, close date this quarter); read amount, stage, probability, owner. 2. Formula · weighted pipeline = Σ(amount × stage probability); detect any deal whose stage moved backward vs last week. 3. Google Sheets · Add row to "GTM Metrics": week, total, weighted, deal count, slipped count. 4. Slack · Post to #revenue, @mention the owner of every stalled or slipped deal. 5. On error · alert #revops and retry once after 5 minutes.