Bookings Dashboard – India Scuba Network

Booking Dashboard · India Scuba Network

⚠ Sync failed — the dashboard could not reach your Google Sheet.

Bookings Dashboard (BS & ISN)

Total Bookings

This Month

Total Revenue

₹0

Activities

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Date	Bookings

Configure Trip

Trip Display Name

Trip Type

Capacity

Trip Date(s)

Destination

Quote per Person

Quote Currency

New Trip

Trip Name *

Trip Type

Capacity

Trip Date(s)

Destination

Quote per Person

Quote Currency

Add Participant

Search existing bookings

— or add manually —

Full Name *

Contact

Room Type

Quote Override (leave blank to use trip quote)

Notes (e.g. payment made by another participant)

Payments

Payment Details

🔒 Amount is locked — it comes from your payments sheet. To change it, edit the entry in the List tab.

Currency

Channel

Label (e.g. Advance, Balance, Deposit)

Notes (e.g. paid on behalf of another participant)

Edit Participant

Full Name

Contact

Room Type

Quote Override

Notes

Edit Payment

Amount *

Date

Currency

Method

Label (e.g. Advance, Balance, Deposit)

Notes

Add Payment

Amount *

Date

Currency

Method

Label (e.g. Advance, Balance, Deposit)

Notes

Add Booking

Full Name

Contact

Activity / Trip

Payment Date

Amount (₹)

Payment Method

Trip / Training Date

Notes

Selected Dates

⚙ Sync Troubleshoot

If the Sync button isn't working, follow these 2 steps to manually import your payments:

Step 1 — Download CSV

Click the button below to download the latest payments from your Google Sheet as a CSV file.

⇩ Download Payments CSV

Step 2 — Import CSV

Click the button below and select the CSV file you just downloaded. The dashboard will update instantly.

⇧ Import CSV

🔍 Sync Diagnostics

This test fetches your Apps Script URL directly and shows the raw response — so you can see exactly what's going wrong.

Press "Run Test" to begin...

Common causes of sync failure

Apps Script quota exceeded — happens around the 1st of the month; re-deploys usually fix it
Deployment expired — open Apps Script → Deploy → Manage deployments → check status
Script returning HTML — means a login redirect; the script needs to be deployed as "Anyone" access
CORS error — the Apps Script must set ContentService.createTextOutput(...).setMimeType(ContentService.MimeType.JSON)
Sheet permissions changed — the service account or script owner may have lost access

Revenue Breakdown

By Purpose of Payment

Trip Assistant

Bangalore Scuba · Trips only