Every morning
Every morning I total yesterday's orders from a CSV export and write up the same little report.
How it goes now
Open the export.Sum the column.Count the orders.Work out the average.Paste it into the report.Save.Same again tomorrow.
Every morning, the same numbers in the same places.
Tell Kitewell once
Build a workflow that reads orders.csv in my daily-report folder, totals the amount_usd column with Python, and writes a Markdown report to report.md every morning at 8:00.
That's the whole setup. Kitewell lays out every step for you to check, and nothing is saved until you apply it.
Then it runs on its own
Daily sales reportRunning on this computer
- Read ordersReads the CSV and passes it on.Done
- Build the reportA few lines of Python total the orders and write Markdown.Done
- Save the reportWrites report.md and shows it in the run.Done
What you get instead
Daily sales report8:00
report.md saved: 42 orders, $3,184.20.
report.md
Daily sales report
Orders: 42
Revenue: $3,184.20
Average order: $75.81
Good to know
- No AI and no network: it runs entirely on this computer and needs only Python 3.
- The walkthrough in Build a workflow builds this one step by step, with sample data.
- Your computer needs to be on and awake when it runs. A run missed while it slept starts when it wakes, within 24 hours by default.
What it needs
- Python 3
More chores
- Every morningEvery morning I open each pull request just to work out which one could break something.
- Every MondayEvery Monday I update our dependencies, run the tests, and lose the morning fixing whatever broke.
- Every morningEvery morning I read through fifty emails to find the five that actually need me.