Google Sheets setup (one time) Paste the Apps Script code below into your sheet to automatically log every submission. See the "Google Sheets Setup" section at the bottom of this page.

Apps Script code

function doPost(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var data = JSON.parse(e.postData.contents);

    if (sheet.getLastRow() === 0) {
      sheet.appendRow([
        "Timestamp","Tenant Name","Email","Unit","Move-In",
        "Reason for Leaving","Overall ★","Cleanliness ★","HVAC ★",
        "Parking ★","Security ★","Maintenance ★","Communication ★",
        "NPS","Value Perception","Lease Clarity",
        "Did Well","Needs Improvement","Other Comments"
      ]);
    }

    sheet.appendRow([
      new Date(data.ts), data.tenantName, data.email, data.unit,
      data.moveIn, data.reason, data.overall, data.clean,
      data.hvac, data.parking, data.security, data.maint,
      data.comm, data.nps, data.value, data.clarity,
      data.well, data.improve, data.other
    ]);

    return ContentService
      .createTextOutput(JSON.stringify({status:"ok"}))
      .setMimeType(ContentService.MimeType.JSON);
  } catch(err) {
    return ContentService
      .createTextOutput(JSON.stringify({status:"error", message: err.toString()}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet(e) {
  return ContentService
    .createTextOutput("Landco Exit Survey — endpoint active.")
    .setMimeType(ContentService.MimeType.TEXT);
}

After pasting: 1. Click Deploy → New deployment 2. Type: Web app 3. Execute as: Me 4. Who has access: Anyone 5. Click Deploy → copy the Web App URL → paste it in the field below Important: Every time you change the script, click Deploy → Manage deployments → create a New version.