Scheduled Report Agent
On a cron schedule, pull metrics, have an agent write a narrative summary, and deliver it to Slack every weekday morning.
What you'll build
A hands-off reporting agent that wakes up on a schedule, gathers fresh data, turns raw numbers into a readable narrative, and posts it to your team — so nobody has to assemble the morning update by hand.
Trigger: a Schedule (cron) — for example weekdays at 9:00am.
The workflow
Build it
Starter — schedule trigger
Add a Starter and set its trigger to Schedule. Use cron 0 9 * * 1-5 (weekdays at 9am). See Triggers for cron syntax.
Pull the metrics
Add whatever source your numbers live in:
- an API block to hit an analytics endpoint, or
- a Supabase / Snowflake block to query a warehouse, or
- a Google Sheets block to read a tracking sheet.
The result is available as, e.g., {{api.data}}.
Agent — turn numbers into a narrative
Add an Agent. Prompt:
You are an analyst writing the daily standup update. Given today's metrics, write a short Slack-formatted summary: the headline number, what changed vs. yesterday, and one thing to watch. Be concise. Use bullet points.
Pass the data: Metrics: {{api.data}}.
Slack — deliver it
Add a Slack block that posts {{agent.content}} to your #standup channel. That's the whole loop — it now runs every weekday untouched.
Make it yours
- Multiple recipients. Fan out with a Parallel block to post to Slack and email the summary via Gmail.
- Charts. Have the agent output a compact table, or add an Image Generator step for a simple visual.
- Alerting. Add a Condition block so it only pings the channel when a metric crosses a threshold — a quiet-by-default report.
- Weekly + daily. Duplicate the workflow with a
0 9 * * 1cron for a Monday deep-dive.