Sheets2Json

This code parses Google Sheets Json to a Json version that's easy to consume

It can be used flexibly to parse any GoogleSheet if you pass a googlesheet ID as a parameter value (eg. index.php?sheetId=xxxx) or simply to parse one Google Sheet with the sheetId specified in the code in index.php .

You can also just copy the code in index.php and translate into any language of your choice.

Example:

From

TO

How to Use

1. Clone repository and run composer install (or translate code in index.php into different language)

2. Publish your sheet to the web

3. Copy Sheet ID

4. Paste Sheet ID in index.php or pass it as a parameter via the URL index.php?sheetId=xxxx

License

You can use this code however you like (see LICENSE).