Hello friends ! Google sheets is really very useful than excel. We can use google sheet as a database or also we can generate json file using the google sheet.I will write a another blog in which you will find that how can we use google sheet as  a database using json but in this blog we will learn that how to convert google sheet to JSON …so lets start:-

Folllow the following steps:-
1. Create a google sheet and put some data
2. Share the sheet by clicking on share button

 3. Click on advance (under the share button)

4.  Turn on public share and click on save button

5.  Copy the share link and paste it in any notepad or word.

6. Now you will get a link something like this :-

https://docs.google.com/spreadsheets/d/1Ji6QQ2ux4gmhK9cRB1MOqf7W1X1X7ve_1OLPdN0AxCc/edit?usp=sharing

7. Now you have to copy the key of the sheet from the link that is :-

https://docs.google.com/spreadsheets/d/SHEET-KEY/edit?usp=sharing

for the above link :-
1Ji6QQ2ux4gmhK9cRB1MOqf7W1X1X7ve_1OLPdN0AxCc    
is  the key for the given link

8. Now the Main part :-

Just Copy the give link below and replace the SheetID with you public sheet key :-

https://script.google.com/macros/s/AKfycbygukdW3tt8sCPcFDlkMnMuNu9bH5fpt7bKV50p2bM/exec?id=SheetID&sheet=Sheet1

Sheet1 represents the sheet tab of you whole file….replace the name of the sheet tab name what ever you have for example:-


https://script.google.com/macros/s/AKfycbygukdW3tt8sCPcFDlkMnMuNu9bH5fpt7bKV50p2bM/exec?id=1Ji6QQ2ux4gmhK9cRB1MOqf7W1X1X7ve_1OLPdN0AxCc&sheet=test1

and thats it you are done ..

Watch the full procedure in the video:- 

Thanks for visiting ….please comment if you face any problem….