Export the monthly revenue report from Airtable

The monthly revenue report is mostly the same work every month. An Orkeste agent reads your revenue table in Airtable, sums the figures by segment, compares them with the previous month and writes the narrative report. It saves the draft to Notion or Google Drive, and finance edits it before it goes to leadership.

The problem

Finance spends two days each month turning the same table into the same report, and the narrative is written in a hurry at the end.

How the workflow runs

Runs: When you start it at month end.

  1. Read the table: The agent reads the revenue records in your Airtable table.
  2. Compare: It sums the figures by segment and compares them with the previous month.
  3. Write the narrative: It explains the main changes and the top movers, in the structure set in its briefing.
  4. Approve: Saving the report waits in Validations.
  5. Save: The report is saved as a Notion page or a file in Google Drive.
  6. Finance edits: Finance checks the figures and edits the report before it is shared.

Finance reviews and edits the draft; the agent never distributes it.

Who does what

What this workflow does not do

Works with your stack

Questions about this workflow

Should we trust the numbers?

Check them. Keep totals as formula fields in Airtable and let the agent write the narrative around them; that removes most of the risk.

Can it pull from Stripe directly?

It can list recent payments and subscriptions in Stripe, but for a full month your Airtable table is the reliable source.

What format is the report?

A Notion page or a file saved in Google Drive, with the structure set in the briefing.

Related workflows

Keep reading