Google Spreadsheets as JSON27 Dec 2018
For some use cases it is very easy to use a Google Sheet as the datasource for a website. For example, I’ve used a published Google spreadsheet as the backend data store for a competition leaderboard. This proves to be one of the simplest solutions as several moderators may want quick access to update the leaderboard and it can be updated easily from a mobile device.
It’s quite simple to publish the data from a Google Sheet as JSON:
- Click the blue share button on the top right of the Sheet console to get a shareable link. For this step, have it set so that “Anyone with the link can view”. What this does is two things: it publishes the sheet to be made available publicly, and it also gives you the necessary
SHEET IDfor the following steps. Example:
- Insert the
SHEET IDthat you got from the Step 1 and insert it into the URL template: