Entity packs arrive by email, the consolidation file has formulas everywhere, and the summary gets written last at 11pm. This walkthrough shows Cowork reading the packs from your inbox, auditing its own numbers, rebuilding the consolidation and running it again next month on a schedule.
Illustrative recreation of the Claude Cowork desktop app with fictional sample data. Not the actual product; screens and labels can change as Cowork ships updates.
The connector setup, the one-prompt report, the consolidation rebuild and the skill that makes it repeatable.
Add Gmail or Outlook under Customize > Connectors so Cowork can find the monthly entity reporting emails.
Read tools on always-allow, write and delete tools on needs-approval.
Search rule, what to extract, where to save attachments, the summary shape and an audit, in one request.
Claude tests each headline number against its source and explains any difference before you trust the summary.
Use last year's file as the template. Formulas, eliminations and entity tabs carry over; spot-check totals.
Package the run as a skill and add it to a Monthly Consolidation project with clear instructions.
Inside the project, "run the monthly consolidation" is enough.
A scheduled task calls the skill, writes to the project folder and runs on day 3.
Test the task once from its detail page and check the output before relying on the schedule.
We map the actual reporting flow first (who sends what, when, in which format), then build the skill and the audit around it. For the revenue data side, see RevOps for finance.
Short answers before you set this up.
Yes, through the Gmail or Microsoft 365 connector. Set the read-only tools to always-allow and keep write tools on needs-approval. Cowork can search by subject, extract figures from the body and save attachments to a folder.
If you give it last year's workbook as the template, it rebuilds the new period with the same structure, formulas and eliminations tab. Always spot-check totals and ask for an audit tab.
Ask Claude to turn a successful run into a skill, add the skill to a project with clear instructions, then rerun it with a one-line prompt or a scheduled task.
Cowork runs in the Claude desktop app on Mac or Windows on a paid plan. It works on folders you grant it on your computer, can use connectors to apps like Gmail, Google Drive, Slack and HubSpot, and can control a browser or desktop apps when you allow it. The website is Chat, not Cowork.
More Claude walkthroughs and guides from JayOh.
JayOh designs and builds Claude workflows for finance and RevOps teams, with the audit trail and approvals your controller expects.
We engineer growth systems. JayOh builds the RevOps architecture, GTM execution and data infrastructure that turn messy revenue operations into predictable pipeline for B2B SaaS and PE-backed teams.