Use Google Sheets as your simple database

Marek Králík
Mar 29 · 2 min read
function doPost(e) {
// store data
}
function doGet(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()
var lastRow = sheet.getLastRow();
var cells = sheet.getRange(‘A2:Z’+lastRow);

return ContentService
.createTextOutput(JSON.stringify(cells.getValues()))
.setMimeType(ContentService.MimeType.JSON);
}
Marek Králík

Written by

Web Developer, Entrepreneur and Petrolhead

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade