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:![sheetId](/static/sheetId-ffc3533ff2ef72c807f10c025d7d0b6a.png)
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
![Invite](/static/invite-54acb6dc0c96ac5032a1b5993d181e9f.png)
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.