Last active
June 15, 2022 15:37
-
-
Save qoobaa/5938bafd207e29fde46b80dc2398b9dc to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var SHEET_ID = "17lRx0wgx9f2JutGKKFfkHmbrkqgsy7nf6IDJL07w-Vs"; | |
var SHEET_NAME = "downloads"; | |
function doGet(event) { | |
return handleResponse(event); | |
} | |
function doPost(event) { | |
return handleResponse(event); | |
} | |
function handleResponse(event) { | |
var lock = LockService.getPublicLock(); | |
lock.waitLock(30000); | |
try { | |
var result = {status: "ok"}; | |
var sheet = SpreadsheetApp | |
.openById(SHEET_ID) | |
.getSheetByName(SHEET_NAME); | |
var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0]; | |
var currentRowNumber = sheet.getLastRow() + 1; | |
var currentRow = []; | |
for (var i in headers) { | |
var header = headers[i]; | |
if (header === "timestamp") { | |
// automatically insert a new date into the first column | |
currentRow.push(new Date()); | |
} else { | |
currentRow.push(event.parameter[header] || ""); | |
} | |
} | |
sheet.getRange(currentRowNumber, 1, 1, currentRow.length).setValues([currentRow]); | |
} catch (error) { | |
result = {status: "error", error: error}; | |
} finally { | |
lock.releaseLock(); | |
} | |
return ContentService | |
.createTextOutput(JSON.stringify(result)) | |
.setMimeType(ContentService.MimeType.JSON); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
timestamp | firstname | lastname | email | subscribe | country | organization | sector | explanation