Portal Control

1. Buka Google Sheets → Extensions → Apps Script

2. Hapus kode lama, paste:

function doPost(e) {
  var d = JSON.parse(e.postData.contents);
  var ss = SpreadsheetApp.openById(d.sheetId || SpreadsheetApp.getActiveSpreadsheet().getId());
  var sheet = ss.getSheets()[0];
  sheet.clearContents();
  sheet.getRange(1,1,d.values.length,d.values[0].length).setValues(d.values);
  return ContentService.createTextOutput(JSON.stringify({success:true})).setMimeType(ContentService.MimeType.JSON);
}

3. Klik Deploy → New deployment → Web App

4. Execute as: Me, Who has access: Anyone

5. Copy URL, paste di field ini