Convert Google Sheets Data into JSON URL using APP #script | #googlesheets

To convert Google Sheets data into a JSON URL using Google Apps Script, you can utilize the built-in functionality of the script editor. This guide will explain how to write a script that retrieves data from Google Sheets and converts it into a JSON format URL, allowing for seamless integration with other applications and APIs.

For any query can message me

#googlesheets
#json #api
#livedata
#livetrading
#stock
#market
#tutorial
#trending
#begginers
#coding
#dataanalysis

[shyamalsamanta]

খুব সুন্দর স‍্যার। অশেষ ধন্যবাদ আপনাকে। অনেক কিছু শিখতে পারছি আপনার ভিডিও দেখে।🙏🙏🙏🙏

[santu..]

Great video Thanks bro .. keep doing like this ...

[vincenttrichy]

Excellent, Very very simple code, explanation clearly. Expect from you more google sheet sync with excel file both side sync.

[sergeypedko]

this is really useful for me, you made my day! Really appreciate!

[cliff_fuhche]

very helpful. Please how do you return only results that match a query, and return everything if query is empty.

[MrAJ-xxgh]

Hi, thanks for sharing. If I need to add the spreadsheet data into object with comment as below structure could you advice what I have to add to the code? Thanks in advance.
{
comment1: "comment1 data",
object: [
{
Symbol: "symbol1",
priceopen: 123,
high: 456,
low: 123,
price: 345,
volumn: 123456
},
{
Symbol: "symbol2",
priceopen: 123,
high: 456,
low: 123,
price: 345,
volumn: 123456
}
]
}

[glendertravel]

Hi
Great Video.
How do you do it when you have different tables in the same sheet?

[abdullahquhtani]

Is it possible to make make nested arrays for example student and his classes or doctor and his working days?!

[andyharewood]

Your video was easy to follow. Well done 👍👍

I did, however, encounter a problem. When it came to using the Web App URL my data is displayed incorrectly.

Each record is displayed in following manner:

[{"Column Header":"Cell Entry", " Column Header":"Cell Entry", etc…! } for all 200+ records.

It is a mess. I have followed your instruction very closely even though it looks like you're using an old version of the Apps Script editor.

However, when I click 'Run' in Apps Script my data is displayed in an orderly fashion which looks like a JSON layout.

Apps Script did, however, truncate my data and returned a message saying "Logging output too large. Truncating output. "

I don't know the first thing about coding. But I can follow a video very well.

Could you please tell me how to fix this?

I would attach pictures but I don't think it's possible on YouTube.

[shovonds]

is there any limitations of execution limit ?

[trushardesai]

I am using microsoft 365. i am not getting publish option. what are other option i will get url

[aravindvithyaasankar]

ur video is very much useful
i need to fetch first 15 min data...is it possible using api...

[shrabanibhattacharya]

Can you develop an android app to screen stock for me plz..

[glhf]

Hi I have an question when I try to type request it keeps showing me that python was not found.. May I know why is this happen? and the bottom Local is what and how to open it? Thanks

[bhanumanhas]

Great video ...is it possible to calculate rsi value in google sheets in single coloumn

[rtspigeons]

Hi... it is possible to add query in this script? for example we want to find Symbol=ASIANPAINT... the query is in the URL and the result only show the Symbol = ASIANPAINT... Thank You...

[spyboyyyyy]

How to create single json of multiple sheets of one document

[Sashankabaidya]

Hello bro... Can u make a video on how to record banknifty open interest data in every 3 min interval in excel using xlwings in python.. Thanks in advance and egarly waiting for this video from u.. Thanks bro...

[svrthardware]

How to add parameter to this script
Example ?id=1 to get only single Row Data by using parameter like ?id=1

[atultanna]

Wont the data be delayed since it is on google sheet