Skip to content

Latest commit

 

History

History
35 lines (18 loc) · 1.1 KB

README.md

File metadata and controls

35 lines (18 loc) · 1.1 KB
Raw

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

sheets2json.png

TO

json4romSheet.png

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

publishSheetToWeb.png

  1. Copy Sheet ID

copySheetId.png

  1. 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).