Welcome
Login / Register

Google sheet to JSON

Thanks! Share it with your friends!

URL

You disliked this video. Thanks for the feedback!

Sorry, only registred users can create playlists.
URL


Added by Jason in Tutorials
4 Views

Description

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"
https://spreadsheets.google.com/feeds/list/YOUR-SHEET-KEY/od6/public/values?alt=json

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
https://coderwall.com/p/duapqq/use-a-google-spreadsheet-as-your-json-backend

Post your comment

Comments

Be the first to comment
RSS