Recipe 09Track B: Go AI-native
How do I automate the weekly report I build by hand?
Let a scheduled workflow pull the numbers from your sheets every Friday, have AI write the words around them, and send the draft to you. Code does the math, AI writes the summary, you approve. The report you spent two hours on becomes a ten-minute review.
- For
- founders sending weekly updates to a team, a client or investors
- Setup
- about 3 hours
- Cost
- $0 self-hosted
Ingredients
Steps
0 of 5 done- Decide the five numbers that matter each week. Write them down. Don’t add more.
- In n8n, add a schedule trigger for Friday 4pm in your time zone.
- Read the sheets. Calculate this week, last week and the change in code, not in AI.
- Pass the calculated numbers to the AI node with the prompt below.
- Send the draft to yourself on Slack or email. Edit, then forward.
Copy this prompt
Write a weekly update from these numbers. They're already calculated, don't recalculate them.
Format: one-line headline, then the 5 numbers with week-over-week change, then 2 lines on what moved and why (only if the notes explain it).
Under 150 words. No hype.
NUMBERS:
{{numbers}}
NOTES FROM THIS WEEK:
{{notes}}Human check
AI writes words, never numbers. You read it before anyone else does.
Done when
the Friday report arrives without you opening a spreadsheet.
Free-tier details checked 29 Oct 2026