# Scenario: the non-profit whose whole operation lived in one sheet

An illustrative scenario showing how Google Workspace™ automation typically grows around an existing Google Sheets™ workflow instead of replacing it.

[Home](https://www.codeinate.com/) > [Case studies](https://www.codeinate.com/case-studies/) > [A spreadsheet that became the business, made safe](https://www.codeinate.com/case-studies/spreadsheet-became-the-business/)

## Where it started

- Members, payments and letters in one Google Sheet™ with hand-typed formulas and no history of who changed what.
- Letters and receipts made by copying a template document and replacing names by hand.

## What was done

- Wrote the process down in plain words with the staff, including the exceptions.
- Kept Google Sheets™ as the data store the staff could still open, added validation and protected ranges, and a change log.
- Built a small sidebar add-on that makes the letters and receipts from the rows, the way Codeinate's own DocMaster add-on does for invoices.
- Documented the formulas and the add-on so a volunteer can follow them.

## What changed

- The sheet is still the sheet. Letters take one click, mistakes are caught before they are saved, and the knowledge is written down.

## The numbers

- Time saved: Depends on the volume of letters (illustrative; not measured)

## Related pages

- [Case studies](https://www.codeinate.com/case-studies/)
- [Google Workspace™ automation](https://www.codeinate.com/services/workspace-automation/)
- [Contact](https://www.codeinate.com/contact/)

Last updated: 2026-11-09. Canonical page: https://www.codeinate.com/case-studies/spreadsheet-became-the-business/

Google Workspace, Google Sheets, Google Docs, Google Slides, Google Forms, Google Drive, Gmail, Google Calendar, Android and Google Play are trademarks of Google LLC. Codeinate products are not affiliated with or endorsed by Google.
