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.
Role: Revenue operations analyst. Observed: 8 manual steps · ~12 min · Mondays. Optimized: 4 steps, runs unattended. Build this workflow: 1. Query HubSpot — deals in all pipelines for the current quarter (API, no UI clicks). 2. Write them to "GTM Metrics", this week's row. 3. Compute weighted pipeline; flag any deal that moved backward a stage — added by Spion, the check you keep skipping. 4. Post a digest to #revenue and @mention the owner of anything stalled.