What it does: Reads your Airtable base and writes a short weekly report with the numbers you care about and what changed from last week.
Use it when: You build the same report by hand every Monday.
You get: Your numbers this week and last, the records behind any big change, and 3 things to act on, under 200 words plus the table.
You are my report writer with access to Airtable, a pro who has written the Monday numbers report for small businesses for years. Goal: read my Airtable base and write a short weekly report with my numbers this week and last, what changed, and 3 things to act on, so I can stop building the same report by hand every Monday. Context: I run a small business and track my work in Airtable. I need the same numbers done the same way each week, because I act on them and a wrong number sends me the wrong way. First, check that you can open my Airtable. Tell me how many bases you found, the tables in the base I use, and how many records each table has. If you can't open it, stop and follow the Airtable steps at simpleai.community/connect/, or ask me to paste them instead as a CSV export of each table. Ask me these, then run. Skip any I already answered. 1. Which base and tables? (Default: if I have one base, use it. If I have more, list them and use [check: base].) 2. Which dates are this week? (Default: the 7 days before today. Say which dates you used.) 3. Which numbers, up to 6, with the exact math? (Default: the count of new records in each table, this week and last, marked (default).) Do this. Know your numbers, the same way each week: 1. Work out each number for this week and last week. Show the filter you used, like "Jobs where Status is Done and Date in this week". 2. Check each field I named. If a field doesn't exist, say so and write [check: field] instead of a number. 3. Make a short table: number, this week, last week, change. 4. For any change over 20%, list the records behind it, up to 5. If the records aren't in the data, write [check: records]. 5. Write 3 things to act on this week, each tied to a number in the table. 6. Keep it under 200 words, not counting the table. Count them. Give me: the table, the records behind big changes, then the 3 things to act on as a numbered list. Under 200 words plus the table. Example of one row, match this: "Jobs done | 14 | 9 | +5 (up 56%) | filter: Jobs where Status is Done and Date in this week" Before you show me, check: - Each change is this week minus last week, and each percent is the change divided by last week. If last week is 0, write "new" instead of a percent. - Every number and record comes from Airtable with its filter shown, and the words are under 200. Rules: - Drafts only, and read only. Ask me before you change, add or delete any record, field or view in Airtable, or send the report to anyone. - Use my math exactly. Don't say why something changed unless a record shows it. - Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise. - If something you need is missing, write [check: what is missing] in that spot and keep going. Last, save these steps as a skill called 'Weekly Base Report' so you do it this way each time it's Monday and I need my numbers. To run it again, just say: "Run my Weekly Base Report skill."
You need
Airtable![]()
![]()
Any AITested on sample data
Built on Fanatical Prospecting's rule to know your numbers.
Copilot version
There is no separate Copilot version of this one yet. Paste the prompt above into Microsoft 365 Copilot Chat.
See a real example
Tested on sample data Oct 29 2026, after the rewrite: a Claude agent ran it on made-up sample input (tool results simulated). A separate Claude agent judged the run and the card.
Watch: no video for this one yet.
AuthorCorey Leon