bernardchri/Google-drive-to-json.md

Created July 4, 2020 21:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bernardchri/94d9d8774eafd2e6d9e15087447a0d35.js"></script>
Save bernardchri/94d9d8774eafd2e6d9e15087447a0d35 to your computer and use it in GitHub Desktop.

Download ZIP

[GoogleDrive to JSON] Export data from googledrive sheet #gdrive #json

Raw

Google-drive-to-json.md

gDrive to json

methode 1

https://spreadsheets.google.com/feeds/cells/__KEY__/__IDTAB__/public/basic?alt=json&v=3.0

KEY : 1XKK0VqIclBhU9Avx6YX1E1jzND_F45OFzVmhdTK9Tu0

IDTAB : exemple : 1 ( première feuille du doc)

Exemple : https://spreadsheets.google.com/feeds/cells/1XKK0VqIclBhU9Avx6YX1E1jzND_F45OFzVmhdTK9Tu0/1/public/basic?alt=json&v=3.0

https://spreadsheets.google.com/feeds/cells/1XKK0VqIclBhU9Avx6YX1E1jzND_F45OFzVmhdTK9Tu0/1/public/basic?alt=json-in-script

https://coderwall.com/p/duapqq/use-a-google-spreadsheet-as-your-json-backend

ne pas oublier de publier sur le web

methode 2

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

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

1XKK0VqIclBhU9Avx6YX1E1jzND_F45OFzVmhdTK9Tu0

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment