dianartanto

Apps Script untuk Google Sheet

Aug 5th, 2026 (edited)
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JavaScript 0.36 KB | Source Code | 0 0
  1. function doGet(e) {
  2.   var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  3.   var params = e.parameter;
  4.   var row = [];
  5.   for (var i = 1; i <= 16; i++) {
  6.     var val = params["ch" + i];
  7.     row.push(val || 0);
  8.   }
  9.   // Tambahkan timestamp
  10.   row.unshift(new Date());
  11.   sheet.appendRow(row);
  12.   return ContentService.createTextOutput("OK");
  13. }
Advertisement
Add Comment
Please, Sign In to add comment