The Simple API - Just call it

sheetSheet

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

You can find your sheetId here:sheetId
This is a public example sheet (click to open, feel free to edit)
Request: (you can replace with your own params)
GET https://sheet.thesimpleapi.com/
1B5PURw-3ObedNm7LLFwt7ft-3_-iqVpBJec6GptQPZk
:sheetId

Response:
(Press "Send" to see response)

2. Get a range in a sheet

Use the second param /:sheetId/:range to get a specific range

Request: (you can replace with your own params)
GET https://sheet.thesimpleapi.com/
1B5PURw-3ObedNm7LLFwt7ft-3_-iqVpBJec6GptQPZk
:sheetId
/
A1:B2
:range

Response:
(Press "Send" to see response)

3. Multi sheets

:range can be used as reference to a sheet (just like in Excel or Spreadsheet).

Request: (you can replace with your own params)
GET https://sheet.thesimpleapi.com/
1B5PURw-3ObedNm7LLFwt7ft-3_-iqVpBJec6GptQPZk
:sheetId
/
Sheet2!A1:E9
:range

Response:
(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

Now go create your new spreadsheet (or use an existing one) and try the API bellow!

Request: (you can replace with your own params)
GET https://sheet.thesimpleapi.com/
:sheetId
/
:range

Response:
(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.
Please contact me if you found any inappropriate text displayed, or you can help remove it from the sheet as well, thanks!

7. Licences

Free for all of your hobby projects. Contact me if you need more.