Skip to main content

Daily growth report

Every morning, spend from both ad platforms and subscription revenue arrive in Slack as a spreadsheet, with AI commentary attached.

Triggered daily on a scheduleUnattended
v2.0.74Production Version of the Daily Report Template
2Ad Platform Data Sources
3Comparison Baselines: Day-over-Day · Week-over-Week · Month-over-Month
Background and problem

Why This Workflow Exists

Spend lives in the Apple Search Ads and Google Ads consoles, revenue in the subscription reports. Someone used to export, merge, and paste the numbers into the group chat every day. The report stopped whenever they took time off, and comparison baselines lived in people's heads — a week later the numbers no longer matched.

Execution

How This Workflow Runs

Trigger modeTriggered daily on a schedule
fetch_ad_spend
Pull the previous day's spend from Apple Search Ads and Google Ads
fetch_revenue
Pull subscription revenue data
build_report_xlsx
Generate an xlsx spreadsheet with three comparisons: day-over-day, week-over-week, and month-over-month
ai_commentary
AI writes the day's commentary from the numbers in the spreadsheet, citing nothing outside it
deliver_slack
The spreadsheet and commentary are posted to the Slack channel together
Recreate this process from a template
The template library has similar workflow templates; demo mode runs without credentials, while production results require connecting your own.