// Case study · Delivered; ERP pilot in progress
Helping a business put AI to work
Six role-based workspaces, a daily report and a controlled path to ERP data for a produce business.

- My role
- Independent consultant: AI implementation and adoption
- Worked with
- The company's CEO and staff; an outside data vendor for the ERP pilot
- Type
- Case study
- Status
- Setup, training, the automated daily report and an ERP data server delivered; the vendor's AI pilot in progress
- Claude
- Claude Cowork
- Microsoft 365
- NotebookLM
- Netlify
- Famous ERP
Overview
A produce business of about 15 people had Claude accounts and a few people using them in different ways, with no shared setup and no easy way to bring the company's own information into the work. Over one engagement I took the company from scattered experiments to a working setup: six role-based Claude workspaces, written guidance, staff training, the CEO's daily report automated, and a controlled path to the company's ERP data: a dedicated server now captures data from the ERP for an AI vendor's integration, without handing anyone a live write path.
- First
Completed: Setup and training
Getting-started guide and site, the workspaces built, group training call, NotebookLM playbook.
- Then
Completed: The daily report
The CEO's report automated in Claude Cowork, with a totals check and a duplicate guard.
- Then
Completed: The data question
Three routes to ERP data evaluated; the self-built bridge set aside; a vendor route chosen and a dedicated server set up to capture ERP data for it.
- Now
Current: Vendor pilot
Lot creation from grower manifests in live implementation on that data; the client reports it is going very well.
The problem
People were trying AI in different ways, without a shared setup or clear guidance. The CEO had a working daily analysis in Claude. One salesperson was feeding it institutional knowledge in chat, where nothing was kept. Others had not started, and one of them was sitting on years of customer notes in a spreadsheet. The ERP had no ready connector, so the company's own data could not reach any of this. The CEO had already tried two automation tools for the daily report and found them too complicated.
People were trying AI in different ways, without a shared setup or clear guidance.
The work
- Six workspaces. I built six Claude workspaces around the real org: a desk each for leadership, sales, operations, finance and design, plus a shared prompt library. Each desk has its own instructions and knowledge files, backed by a library of 32 prompts written for those roles and per-role cheat sheets. Every desk carries the same written rule: Claude drafts, a human sends.
- A getting-started site. A short, client-branded guide covering the basics, how to use Claude, how to set up a Project, how to work securely, a prompt library and builder, an English-Spanish helper, and a page on which AI to use for what. I pulled the pages about their own produce because we did not know their business well enough to stand behind them.
- Training. A live group session with the staff, a working session on the Microsoft 365 connector, and a session with the CEO on Cowork.
- The daily report. The CEO's report moved into Claude Cowork, the tool already on their side, instead of the heavier pipeline the company had been considering. It runs automatically: it reads the day's spreadsheet from email, runs the CEO's own tested analysis script, reconciles the totals, and emails a full report to the people who need it on a schedule, with a guard against sending twice. If the totals do not balance, the report is held and never sent. The report follows the company's season, so it pauses when the season does.
- The data question. The ERP data model was obtained and analysed. I designed a self-built bridge, then set it aside as reference when a managed read-only data service and an AI vendor's integration came into view. I brought the vendors in and set the terms: read-only first, writes only with human review. The company now runs its own dedicated server instance that captures data from the ERP for that integration, and it has been running for a while. On top of it, the vendor's pilot is deliberately narrow: creating produce lots from grower-manifest emails. I wrote the due-diligence brief and a client FAQ along the way.
Tools
- Claude (Teams, Projects): the role desks and their knowledge files.
- Claude Cowork: the scheduled daily report.
- Microsoft 365: Outlook and OneDrive, reached through the Claude connector.
- NotebookLM: reference material, with a playbook on how to use it.
- Netlify: the getting-started site.
- Famous ERP: the operating data everything eventually needs to reach.
Results
- Delivered: Six Claude workspaces: desks for leadership, sales, operations, finance and design, plus the shared prompt library, each desk with instructions and knowledge files.
- Delivered: The getting-started site, 32 role prompts and the per-role cheat sheets.
- Delivered: Staff training: a group call plus working sessions.
- Delivered: The daily report running automatically in Claude Cowork, with a totals check that holds mismatched reports and a duplicate-send guard.
- Delivered: Three routes to ERP data evaluated, with a written brief, and a dedicated server instance running that captures data from the ERP for the AI vendor's integration, on read-only terms with human review on every write.
- Still open: The vendor's AI pilot, creating lots from grower manifests: in progress, and the client reports it is going very well.
- Still open: Individual onboarding follow-ups from the training call.
No usage or time-saved numbers were defined for this engagement, so none are claimed.