Google Sheet Connection

This is the same Apps Script Web App URL you added to the check-in form. The dashboard reads data from the same script endpoint.

Current URL:

You also need to update your Apps Script to support reading data. Open your Apps Script editor and add this function below your existing doPost:

Copyfunction doGet(e) {
  var action = e.parameter.action;

  if (action === 'read') {
    var sheet = SpreadsheetApp
      .getActiveSpreadsheet()
      .getActiveSheet();
    var rows = sheet.getDataRange().getValues();
    var headers = rows[0];
    var data = rows.slice(1).map(function(row) {
      var obj = {};
      headers.forEach(function(h, i) {
        obj[h] = row[i];
      });
      return obj;
    });
    return ContentService
      .createTextOutput(JSON.stringify(data))
      .setMimeType(ContentService.MimeType.JSON);
  }

  return ContentService
    .createTextOutput('Bridging Miracles check-in running ✓')
    .setMimeType(ContentService.MimeType.TEXT);
}

After adding the function, click Deploy → Manage deployments → Edit → New version → Deploy to update.