Configuration
Settings
Google Sheet Connection
All readings sync automatically to your Google Sheet once this URL is set.
Change Password
Apps Script Code — Copy to Google Apps Script
Extensions → Apps Script → paste → Deploy as Web App → Anyone
function doPost(e) {
var d = JSON.parse(e.postData.contents);
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(d.batch) || ss.insertSheet(d.batch);
if(sheet.getLastRow()===0){
sheet.appendRow(['Timestamp','Date','Session','SG','Temp','pH',
'Chiller','Rotation','Notes','Type']);
}
sheet.appendRow([
new Date().toISOString(), d.date, d.session||'',
d.sg||'', d.temp||'', d.ph||'',
d.chiller||'', d.rotation||'', d.notes||'', d.type||'reading'
]);
return ContentService
.createTextOutput(JSON.stringify({status:'ok'}))
.setMimeType(ContentService.MimeType.JSON);
}