Staff Work Log
⚙️ One-time setup required
Paste your
Google Apps Script Web App URL
below to connect to the shared Google Sheet.
How to get this URL ↓
Save
📋 Setup Steps
Open
Google Sheets
and create a new spreadsheet
Name it
Junction Café Work Log
Click
Extensions → Apps Script
Delete all existing code and paste the contents of
appsscript.gs
Click
Deploy → New deployment
Choose type:
Web app
Set
"Execute as"
to
Me
Set
"Who has access"
to
Anyone
Click
Deploy
and copy the web app URL
Paste it above and click
Save
‹
Loading…
›
Select Staff Member
— Choose name or add new —
＋
Cancel
Save Staff Member
Days Worked — tap day, then choose type below
0
Days
0
Hours
—
Types
Notes (optional)
Clear
Save Entry ✓
Not connected — add script URL above
Recent Entries
Loading…
Staff Summary
Weekly
Monthly
Name
Days
Hours
Types
Total
—
—
Add Junction Café to your home screen.
Install
✕