Bootstrapping your company counter
Mathieu Nebra

Thank you Mathieu, I was able to tweak the script slightly to spit out a specific number in out KPI-sheet. I was actually trying to work out how to get our number into that JSON format for a while now, so that we could finally order our counter.

For anyone struggling with this, “A1” is the location of the cell I wanted it to read:

function doGet(e)
 var sheet = SpreadsheetApp.getActiveSpreadsheet();
 var zwonullsiebzehn = sheet.getRange(“A1”).getDisplayValue();
 var params = JSON.stringify({number:zwonullsiebzehn});
 return ContentService.createTextOutput(params);

Like what you read? Give Eike J. Luyten a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.