Walloon Central Marine
Service Requests
Demo mode
⚙️
Connect to Google Sheets:
Enter your Sheet ID and API Key below, or load demo data.
Service Requests
Sheet1
Form Responses 1
Submissions
Connect & Load
Load Demo Data
All repair types
Engine
Electrical
Hull
Service
Trailer
Other
All priorities
High
Medium
Low
All statuses
New
Assigned
In Progress
Ready
Done
Board
List
Sync
Ticket
Date
Customer
Boat
Repair
Priority
Status
Tech
Connecting to Google Sheets…
🚤 Getting Started — Connect Your Google Sheet
1
In your Google Sheet, go to
Extensions → Apps Script
(or use the
Google Sheets API
with a service account or API key).
2
Enable the
Google Sheets API
in your
Google Cloud Console
and create an API Key (restrict it to Sheets API).
3
Your Sheet must be
shared publicly
(anyone with link can view) OR use a service account for private sheets.
4
Paste your
Sheet ID
from the URL:
docs.google.com/spreadsheets/d/
[SHEET-ID]
/edit
5
Your form columns A–N are already mapped. Just add 4 staff columns to your sheet:
O: Status P: Assigned Tech Q: Priority R: Ticket ID
6
Click
Connect & Load
above, or click
Load Demo Data
to try the dashboard right now.