Hello! My name is Mark Scheiber and I am local here in Boise, graduated from Boise State
University. I acheived a Finance degree with a Minor in Accounting and am currently in
an Master's program at the University of Colorado Boulder Online.
I have specialized in bookkeeping services and having you own "nerd" so to speak means I can give you 100% of my attention.
Please reach out anytime for a quick call to discuss your bookkeeping or accounting
needs at (530)902-8791 or email to [email protected].
Excited to help you save time, focus more on your business activities, and watch your
company grow!
function doPost(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1"); // change if your sheet is named differently
var data = JSON.parse(e.postData.contents);
sheet.appendRow([
new Date(), // timestamp
data.food || "", // the food Siri captured
data.source || "" // optional
]);
return ContentService
.createTextOutput("OK")
.setMimeType(ContentService.MimeType.TEXT);
}
function doGet() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; // Gets the first sheet
var data = sheet.getDataRange().getValues();
var headers = data[0];
var rows = data.slice(1);
var result = rows.map(function(row) {
var obj = {};
row.forEach(function(cell, i) {
obj[headers[i]] = cell;
});
return obj;
});
return ContentService.createTextOutput(JSON.stringify(result))
.setMimeType(ContentService.MimeType.JSON);
}