To day I show you
How to get JSON data from google sheet
this tutorials JSON demo link:
Step 1: we create a demo google sheet
Step 2: Share the sheet as public
Step 3: Copy share link and get doc key
Step 4: Publish this sheet as web by "file then Publish to the web"
Step 5: In this time use this URL and inject your sheet key by replace with "YOUR-SHEET-KEY"
Step 6: Hope you see the output
Step 7: Here is many extra parameter, you can find your values in
"feed" json object "entry" json object "Your columns tag" as json array
Note: We take help from