Try a script like this:
function doGet() {
//get data from sheet
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName("Sheet1");
var values = JSON.stringify(sh.getDataRange().getValues());
return ContentService.createTextOutput(values);
}
then blocks:
The json structure gets lost in the cells and on the way, and has to be reformed in the blocks
