membuat datalogger esp32 ke google sheet

 1. Membuat dokumen di drive: new -> google sheet

2. membuat script

klik extension -> app script 

var sheet_id = "cek di link google sheet yg d buat";

var sheet_name = "logger";

function doGet(e){

var ss = SpreadsheetApp.openById(sheet_id);

var sheet = ss.getSheetByName(sheet_name);

var sensor = Number(e.parameter.sensor);

var date = Number(e.parameter.date);

sheet.appendRow([sensor,date]);

}

3. deploy - new deployment - pilih web app

4. setting who acces ganti anyone

5. kemudian deploy

6. test buka web browser

https://script.google.com/macros/s/AKfycbwglAL30Vufa0LRwj4diDBOe-Y12dtXWpyr23v4f67uRjs666LVkBTIhiYaNdvoTa1o/exec?sensor=35&date=1103