top of page
Article link

Google sheet as JSON

Get the google sheet data in json format without using google API.

Enter your sheet ID : 

OUTPUT :

Step 1 : Publish google sheet

           file > Publish tothe web.... > Publish > Publish (in alert window) 

Step 2 : Get google sheet ID
         
 copy the sheet url

             url :  https://docs.google.com/spreadsheets/d/1uPAvSYtOYGUQbbRrM8Mh3gdgiUw6QhMihY6MWvvn7Jg/edit
           the black color is the google sheet id1uPAvSYtOYGUQbbRrM8Mh3gdgiUw6QhMihY6MWvvn7Jg
             copy only  the sheet id


Step 3 : Paste the sheet ID and press "Fetch google sheet"
           
The json file will be shown in the user element

Wix-http-function

wanna use this feature in code directly 
1. use fetch to this url change the sheet ID at the end 
https://salman2301.wixsite.com/google-sheet/_functions/googleSheet/1uPAvSYtOYGUQbbRrM8Mh3gdgiUw6QhMihY6MWvvn7Jg

CODE

Disclaimer : 
1. code is used only for the educational purpose.
2. Use the code at your own risk
3. Use google API to get the data more secure way

bottom of page