function doGet(e) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var data = sheet.getDataRange().getValues(); var headers = data[0].map(String); var rows = data.slice(1) .filter(function(r) { return r.some(function(c) { return c !== '' && c !== null; }); }) .map(function(r) { return r.map(function(c) { if (c === null || c === undefined || c === '') return ''; if (c instanceof Date) { var d = c.getDate(), m = c.getMonth()+1, y = c.getFullYear(); if (y < 1900) return ''; return (d<10?'0'+d:d)+'/'+(m<10?'0'+m:m)+'/'+y; } return String(c); }); }); return ContentService .createTextOutput(JSON.stringify({ headers: headers, rows: rows, updated: new Date().toISOString() })) .setMimeType(ContentService.MimeType.JSON); }