| // Google Apps Script — paste this into Extensions > Apps Script in your Google Sheet. | |
| // Deploy as: Web App → Execute as Me → Anyone can access. | |
| // | |
| // The sheet must have headers in row 1: name | author | timestamp | data_json | |
| function doPost(e) { | |
| var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); | |
| var data = JSON.parse(e.postData.contents); | |
| if (data.action === "save") { | |
| // Check if scenario already exists (update in place) | |
| var names = sheet.getRange("A:A").getValues(); | |
| var rowIndex = -1; | |
| for (var i = 1; i < names.length; i++) { | |
| if (names[i][0] === data.name) { | |
| rowIndex = i + 1; // 1-indexed | |
| break; | |
| } | |
| } | |
| var row = [data.name, data.author, data.timestamp, data.data_json]; | |
| if (rowIndex > 0) { | |
| sheet.getRange(rowIndex, 1, 1, 4).setValues([row]); | |
| } else { | |
| sheet.appendRow(row); | |
| } | |
| return ContentService.createTextOutput(JSON.stringify({status: "ok"})) | |
| .setMimeType(ContentService.MimeType.JSON); | |
| } else if (data.action === "delete") { | |
| var names = sheet.getRange("A:A").getValues(); | |
| for (var i = 1; i < names.length; i++) { | |
| if (names[i][0] === data.name) { | |
| sheet.deleteRow(i + 1); | |
| break; | |
| } | |
| } | |
| return ContentService.createTextOutput(JSON.stringify({status: "ok"})) | |
| .setMimeType(ContentService.MimeType.JSON); | |
| } | |
| return ContentService.createTextOutput(JSON.stringify({status: "error", message: "Unknown action"})) | |
| .setMimeType(ContentService.MimeType.JSON); | |
| } | |
| // Required for Apps Script web app — handles GET requests with a simple status page | |
| function doGet(e) { | |
| return ContentService.createTextOutput("SalesComp API is running.") | |
| .setMimeType(ContentService.MimeType.TEXT); | |
| } | |