Convert Google Sheet into JSON Web App

In this video, I demonstrate how to convert a Google Sheet into a JSON Web App.

Code provided in Comments Below Video.

Video, Code, and Documentation can also be found at:

[CodeWithCurt]

Google Apps Script Code in Video Below:

function doGet() {
var content = getSheetData();
var contentObject = {GoogleSheetData: content}
return
}

function getSheetData() {
var ss=
var dataSheet = ss.getSheetByName('DATA');
var dataRange = dataSheet.getDataRange();
var dataValues = dataRange.getValues();
return dataValues;
}

[machodge]

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 YouTube.

[abdullahquhtani]

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 🙏

[muhammedaadhil]

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.

[tazulislam]

Sir, How will I utilize this JSON in html table? please! make video on this topic. Thanks!

[franbermejo]

it is the best explanation for google sheet to JSON, thanks for the code! regards!

[franciscogomes]

Excelent tutorial! That's really works like a charm! Thank you so much!

[kensleylewis]

nice stuff - but what can we do with json data coming into postman, at that point?

[yesiamsumit]

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.

[diegognoatto]

Cors error accessing from fetch on vscode. did i do something wrong?

[SunilKumar-obvs]

Sir how to convert this data into html table pls i need this is in my peoject pls

[abdullahquhtani]

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. 😤

[ashokgtm]

do it also export values like like 18 decimals values.

[bumpersmith]

Sorry but this did not make any since to me.

[Adam-pzoe]

so whats the point if anyone can go to this google sheet and mess with it lol

[androidapp]

function doGet (){
var content = getSheetData();
var contentObject = {GoogleSheetData: content}
return stringify(contentobject) ). sethineType (ContentServich .Minetype .JSON);
}

function getSheetData() {
var ss=
var dataSheet = ss.getSheetByName ('DATA');
var dataRange = dataSheet.getDataRange():
var dataValues = dataRange.getValues();
return datavalues;
}