// 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.

Concept illustration of a rugged tablet showing an inventory and workflow dashboard beside crates of oranges, greens and tomatoes; not a client photo or product screenshot.
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.

  1. First

    Completed: Setup and training

    Getting-started guide and site, the workspaces built, group training call, NotebookLM playbook.

  2. Then

    Completed: The daily report

    The CEO's report automated in Claude Cowork, with a totals check and a duplicate guard.

  3. 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.

  4. 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.
Diagram: Six Claude workspaces: five role desks (leadership, sales, operations, finance, design) share one prompt library of 32 prompts, beside a getting-started guide; every desk follows the rule Claude drafts, a human sends. The daily report runs automatically in Claude Cowork: the daily email and spreadsheet go to the CEO's tested analysis script and a totals check; if totals balance the report is emailed on schedule with a duplicate-send guard, otherwise it is held and never sent. Path to ERP data: Famous ERP feeds a dedicated server that captures ERP data and is running, which feeds an AI vendor integration (read-only first, writes with human review); the vendor's pilot, lot creation from manifests, is in progress. A self-built bridge is kept as reference only and a read-only data service was evaluated.

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.