🪔 Mandir Events Admin

What this does: Every appointment booking from the website gets saved as a new row in your Google Sheet automatically. You set this up once for each new Sheet (e.g. once a year).

Step 1 — Prepare the Sheet

1. Open your Google Sheet.
2. Click cell A1 and type these 9 column headers across row 1 (one per cell, A through I):

Step 2 — Add the script

1. In the Sheet's top menu, click Extensions → Apps Script. A new tab opens.
2. Delete anything already in the editor, then copy the code below and paste it in.
3. Click the 💾 Save icon (or Ctrl/Cmd + S).

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var d = JSON.parse(e.postData.contents);
  sheet.appendRow([
    new Date(), d.Service || '', d.Date || '', d.Time || '',
    d.Name || '', d.Phone || '', d.Email || '', d.Priest || '', d.Notes || ''
  ]);
  return ContentService.createTextOutput(JSON.stringify({ok:true}))
    .setMimeType(ContentService.MimeType.JSON);
}

Step 3 — Deploy as a Web App

1. In the Apps Script tab, click the blue Deploy button (top right) → New deployment.
2. Click the gear ⚙️ next to "Select type" → choose Web app.
3. Set Execute as: Me.
4. Set Who has access: Anyone. (This must be "Anyone" or the website can't save bookings.)
5. Click Deploy.
6. Google will ask you to authorize. Click Authorize access → pick your Google account → on the "Google hasn't verified this app" screen click Advanced → Go to (project name) (unsafe) → Allow. (This is normal for your own script.)

Step 4 — Copy the URL & save it here

1. After deploying, Google shows a Web app URL ending in /exec. Click Copy.
2. Paste it into the Booking Sheet Web App URL box above.
3. Press ⬆ Publish to Website. Done — new bookings now appear in the Sheet.

Tip: To test, open the temple website, book a test appointment, and check that a new row appears in the Sheet. If nothing appears, re-check that Step 3 access was set to Anyone.