Weekly Digest Aggregated from a Google Sheet

A Monday morning cron job reads the previous week's rows, runs aggregations (sum, avg, top N), and delivers a tidy summary to WhatsApp — perfect for OKR tracking and team updates.

Cron + WhatsApp Groupdigestreportingcron

Conversation example

Cron triggered: Weekly OKR digest (Monday 9:00 AM)
http_request → Sheets API v4

Reading 'OKRs 2026 Q2' → tab 'Weekly' for the previous week's rows...

whatsapp_web_send

Weekly Digest — Apr 5 to Apr 11, 2026 KR1 (MRR to $60K): $48,920 (on track, 81.5%) KR2 (Activation rate > 45%): 47.2% (hit) KR3 (NPS 50+): 52 (hit — new high) KR4 (Ship 4 agents): 2 of 4 (at risk) By owner: - Rivka: 3 of 3 weekly goals - Daniel: 2 of 3 - Sam: 3 of 3 - Alex: 1 of 2 (at risk on KR4) Posted to #okrs-weekly WhatsApp group. @alex has been DM'd about the KR4 slippage.

More Google Sheets use cases

Deploy this in minutes

Create a LunoGen agent, connect Google Sheets, and start running this workflow from WhatsApp today.