Google Apps Script Code in Video Below: function doGet() { var content = getSheetData(); var contentObject = {GoogleSheetData: content} return ContentService.createTextOutput(JSON.stringify(contentObject) ).setMimeType(ContentService.MimeType.JSON); } function getSheetData() { var ss= SpreadsheetApp.getActiveSpreadsheet(); var dataSheet = ss.getSheetByName('DATA'); var dataRange = dataSheet.getDataRange(); var dataValues = dataRange.getValues(); return dataValues; }
I hope you can take this script steps further to be able to filter data with multiple criteria then post data to add, edit and delete data. Thank you 🙏
A person who is learning to code like me..we .don't know how to use the JSON and what are its functionalities. I would like to see a demo on how to utilize this JSON function and its output. Thank you.
Thank you so much @Code With Curt. Script code provided by you is usefull ! And yes I am saying this after trying lots of codes named under title "export to JSON" on TH-cam.
Google Apps Script Code in Video Below:
function doGet() {
var content = getSheetData();
var contentObject = {GoogleSheetData: content}
return ContentService.createTextOutput(JSON.stringify(contentObject) ).setMimeType(ContentService.MimeType.JSON);
}
function getSheetData() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var dataSheet = ss.getSheetByName('DATA');
var dataRange = dataSheet.getDataRange();
var dataValues = dataRange.getValues();
return dataValues;
}
I hope you can take this script steps further to be able to filter data with multiple criteria then post data to add, edit and delete data. Thank you 🙏
How can I filter data from the entire sheet's data? For each request, I don't want the entire sheet in json form, only specific parts of it.
A person who is learning to code like me..we .don't know how to use the JSON and what are its functionalities. I would like to see a demo on how to utilize this JSON function and its output. Thank you.
nice stuff - but what can we do with json data coming into postman, at that point?
Cors error accessing from fetch on vscode. did i do something wrong?
Sir , How will I utilize this JSON in html table? please! make video on this topic. Thanks!
Sir how to convert this data into html table pls i need this is in my peoject pls
do it also export values like 0.000000000123232 like 18 decimals values.
Not Work
Thank you so much @Code With Curt. Script code provided by you is usefull ! And yes I am saying this after trying lots of codes named under title "export to JSON" on TH-cam.
Excelent tutorial! That's really works like a charm! Thank you so much!
it is the best explanation for google sheet to JSON, thanks for the code! regards!
Work ?
This helped me! Thanks
Sorry but this did not make any since to me.
At the end of your video, you said if you have any questions or comment , leave it below the video!!
I asked a question BUT you didn’t answer. 😤
so whats the point if anyone can go to this google sheet and mess with it lol
thank you so much : )
.
function doGet (){
var content = getSheetData();
var contentObject = {GoogleSheetData: content}
return ContentService.createTextOutput(JSON. stringify(contentobject) ). sethineType (ContentServich .Minetype .JSON);
}
function getSheetData() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var dataSheet = ss.getSheetByName ('DATA');
var dataRange = dataSheet.getDataRange():
var dataValues = dataRange.getValues();
return datavalues;
}