Connecting to Google Sheets…

☁️ Connect to Google Sheets

One-time setup · Takes ~10 minutes
1

Create a Google Spreadsheet

Go to sheets.new and create a new blank spreadsheet. Name it EMS Database.

2

Open Apps Script

In the spreadsheet, click Extensions → Apps Script. Delete the existing code, then paste the full contents of EMS_GoogleAppsScript.gs that was provided alongside this file.

3

Run Setup

In Apps Script, run the setupEMS() function once (▶ Run button). Grant permissions when prompted. This creates all sheets and the default admin user.

4

Deploy as Web App

Click Deploy → New deployment → Web app. Set:
• Execute as: Me
• Who has access: Anyone
Copy the Web App URL provided.

Already configured — open the app →