SM Reports Buddy
by Cameron Cox
$30
SM Reports Buddy
SM Reports Buddy is an automated Google Sheets reporting system for stage managers who are ready to move beyond copying, pasting, renaming, reformatting, exporting, attaching, and retyping the same information every night.
Most stage managers already have a report template. SM Reports Buddy is what happens when that template starts doing the repetitive work for you.
Built entirely within Google Sheets, SM Reports Buddy transforms your report template into an automated reporting workflow. Instead of duplicating yesterday's report and manually updating dates, titles, report numbers, file names, email subjects, and distribution lists, you set your production up once and let the workbook handle the repetitive work throughout the run.
But SM Reports Buddy goes beyond simply generating reports.
It creates a connected reporting system where rehearsal and performance reports, department logs, PDFs, Google Drive folders, and Gmail drafts all work together. Instead of nightly reports becoming isolated snapshots, important information continues to build into searchable records that become more valuable as your production progresses.
I built SM Reports Buddy because I wanted software that felt like stage management—not like learning an entirely new platform. Everything stays inside the Google Workspace tools many stage managers already use: Google Sheets, Google Drive, PDF exports, and Gmail.
What it does
Build reports without rebuilding paperwork
Create rehearsal and performance reports from a repeatable workflow instead of duplicating yesterday's report and manually updating the same information every night.
Set production information once
Show title, abbreviations, report types, report numbers, dates, naming conventions, email subjects, distribution preferences, and other repeated information are managed from Setup instead of being retyped report after report.
Turn daily reports into living department records
Every rehearsal report is valuable—but only for that day. SM Reports Buddy transforms department notes into cumulative Department Logs, giving each department its own searchable history throughout the production. Instead of searching through weeks of reports trying to remember when something was first reported, the answer is already organized for you.
Generate polished PDFs automatically
Create consistently named Report and Daily Call PDFs without manually exporting, renaming, organizing, or filing every document yourself.
Prepare Gmail drafts in seconds
Generate Gmail drafts with PDFs attached and recipients already populated. You stay in control by reviewing every draft before sending—nothing is ever sent automatically.
Stay inside Google Workspace
No proprietary software. No subscription platform. No new ecosystem to learn. Your reports stay in Google Sheets, your files stay in Drive, and your communication stays in Gmail.
What you get
Google Sheets reporting workbook
Built-in Apps Script automation
Rehearsal and performance report workflows
Automated Department Log system
PDF generation tools
Gmail draft creation
Customizable production setup
Naming, numbering, and email templates
Setup guide and documentation
Who it's for
SM Reports Buddy is designed for stage managers, assistant stage managers, production managers, theatre educators, students, and production teams who already know how to write a report—but want a faster, cleaner, and more organized way to manage the reporting process.
It's especially useful if you're tired of:
Copying yesterday's report every night
Updating the same production information over and over
Manually exporting and renaming PDFs
Preparing the same email every evening
Searching through weeks of old reports to find a department note
Wondering whether the latest report ended up in the correct folder
Please note
SM Reports Buddy is built with Google Sheets and Google Apps Script. A Google account is required, and you'll be asked to authorize the included Apps Script tools before using the automation features.
SM Reports Buddy does not replace the work of a stage manager. It doesn't decide what belongs in a report, write notes for you, or send emails automatically. Instead, it automates the repetitive administrative work surrounding production reporting so you can spend more time focusing on the rehearsal room.
Setup instructions and documentation are included. SM Buddy is currently offered as an early release Google Sheets + Apps Script workflow tool. The core reporting workflow is functional, and documentation is included. Additional walkthrough materials and refinements may be added over time based on user feedback.