Sheet
Turn your Google Spreadsheet into JSON with a simple API call
1. Get the whole sheet as JSON
Use /:sheetId to fetch the whole sheet as JSON
sheetId here:
This is a public example sheet (click to open, feel free to edit)
GET https://sheet.thesimpleapi.com/(Press "Send" to see response)
2. Get a range in a sheet
Use the second param /:sheetId/:range to get a specific range
GET https://sheet.thesimpleapi.com//(Press "Send" to see response)
3. Multi sheets
:range can be used as reference to a sheet (just like in Excel or Spreadsheet).
GET https://sheet.thesimpleapi.com//(Press "Send" to see response)
4. Private spreadsheets
In order to fetch from private spreadsheets, you have to grant View permission to this email address:sheet-bot@thesimpleapi.iam.gserviceaccount.com
Now go create your new spreadsheet (or use an existing one) and try the API bellow!
GET https://sheet.thesimpleapi.com//(Press "Send" to see response)
5. Behind the scenes
- Google Cloud
- Google Spreadsheet API
- AWS Lambda
- Cloudfront
- Route 53
- NodeJS
6. What can you do with this?
- An effortless CMS to manage content of your website without any backend?
- Use it as a serverless database?
- In fact, the few last items in this section is loaded from a sheet. Go add your own by editing this spreadsheet.