The Eigi Studio tour is here. Set up an agent, test a call, read every conversation.Watch the tour →Your first Eigi, live in a week. A real engineer sets it up.Talk to Buddy →Answers on Slack, Discord, WhatsApp and calls.See how →The Eigi Studio tour is here. Set up an agent, test a call, read every conversation.Your first Eigi, live in a week. A real engineer sets it up.Answers on Slack, Discord, WhatsApp and calls.
← Back to the cookbook
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
  1. Decide the five numbers that matter each week. Write them down. Don’t add more.
  2. In n8n, add a schedule trigger for Friday 4pm in your time zone.
  3. Read the sheets. Calculate this week, last week and the change in code, not in AI.
  4. Pass the calculated numbers to the AI node with the prompt below.
  5. 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