Weekly campaign performance reportGA4 + Google Ads + HubSpot → Sheets → Slack
Three logins, one summary, zero Mondays.
View workflow →- Log into GA4, export sessions + conversions.
- Google Ads — spend + CPC.
- HubSpot — new MQLs.
- Paste all into "Weekly Marketing".
- Write a summary.
- Post to #marketing.
- Pull GA4, Ads, HubSpot.
- Write to the sheet.
- Summarize anything that moved >10% with Claude.
- Post to #marketing.
Trigger · Schedule, every Monday 08:00. 1. Google Analytics 4 · Run a report: sessions, conversions, conversion rate (last 7 days vs prior 7). 2. Google Ads · Get metrics: spend, clicks, CPC by campaign. 3. HubSpot · Search new MQLs created last week. 4. Google Sheets · Add a row to "Weekly Marketing" with every metric. 5. Router + Filter · keep only metrics that moved more than 10% week over week. 6. Slack · Post the movers to #marketing, each with its delta and direction.