Data and reporting
The same page of numbers, every Monday morning
Four figures live in four places: revenue in the store, acquisition cost in the ad accounts, stock in a spreadsheet, response time in the inbox. Anyone can assemble them once. Almost nobody assembles them on the same day of the week, to the same definition, for a year. That repetition is the whole product — a run of comparable weeks is what lets you see a trend, and a page rebuilt from memory each time is not comparable to anything.
- Triggers
- Two
- Runs
- Weekly, plus on write
- Stack
- 3 tools
- Durable execution
- Not required
The flow
The top track records the operating facts as they happen. The bottom track wakes once a week, reads them alongside the platform figures, and decides whether the page is complete enough to send.
An order or a reply happens
Sheets · Airtable
Stamp it with the week
n8n · Make
The operating tables
Sheets · Airtable
Every Monday, 08:00
n8n schedule
Pull each source onto one page
n8n · Make
Did every source report?
n8n IF
Send the brief
Slack · WhatsApp
Send it, and name the hole
Slack · WhatsApp
Step by step
- 01
An order or a reply happens
Sheets · AirtableStock movements and first-reply times are not sitting in an API waiting to be queried on Monday. They only exist if something wrote them down at the time.
- 02
Stamp it with the week
n8n · MakeOne week identifier, decided once — which day the week starts on, and which timezone. Two sources disagreeing about where Sunday ends is the most common reason two people read the same brief differently.
- 03
The operating tables
Sheets · AirtableStock on hand and response times, one row per event. These are the two figures no platform will hand you on Monday, so they have to accumulate all week.
- 04
Every Monday, 08:00
n8n scheduleA fixed hour, not a reminder. The brief is worth having because it arrives before the week's decisions, not because it is thorough.
- 05
Pull each source onto one page
n8n · MakeRevenue from the store, spend and acquisition cost from the ad accounts, the two operating figures from the tables. Append the result as one dated row before formatting anything, so the week is preserved even if the send fails.
- 06
Did every source report?
n8n IFChecked per source, not on the page as a whole. An ad account that returned an error and a category that genuinely sold nothing both show as zero, and only one of them is a number.
- 07
Send the brief
Slack · WhatsAppFour figures, each next to the same figure last week. No commentary — the person reading it knows the business, and a paragraph of interpretation is what makes a weekly brief stop being read.
- 08
Send it, and name the hole
Slack · WhatsAppSend the figures you have and say which source did not answer. Holding the brief back until everything is in means it arrives on Wednesday, when it is no longer a Monday brief.
What the platform will not allow
Two of these set how firm Monday's figures actually are; the third sets how fast you may read and write the sheet underneath them.
Meta's ad insights "refresh every 15 minutes and do not change after 28 days of being reported". A figure read on Monday for the week just ended is therefore still moving — the same brief re-run a fortnight later can legitimately show a different number for the same week.
Meta Marketing API — Insights best practicesInsights are rate limited by load, not by call count: "We allow a fixed load limit per application per second. When you exceed that limit, your requests fail." A brief that loops one request per campaign is what runs into this, so ask for the breakdown in one query rather than looping.
Meta Marketing API — Insights best practicesSheets allows 300 read and 300 write requests per minute per project, and 60 per minute per user per project; the quotas refill every minute and there is no daily cap on top of them.
Google Sheets API — Usage limits
When this is not worth building
Three cases where the upkeep costs more than the missing page.
Nobody has a standing Monday decision. A brief that lands in front of a person who will not act on any value it can show is a habit, not an instrument, and habits are abandoned quietly.
The four figures are not yet defined the same way twice. If revenue sometimes includes shipping and sometimes does not, the weekly series measures your bookkeeping mood rather than the business.
Two of the four sources still need a person to export them by hand. A brief that is three-quarters automatic still waits on that person every Monday, and you have added machinery without removing the dependency.