sheet2api logo Sign in

Google Sheet as a JSON API

Create your own REST API in just 5 minutes.

With this guide, you'll be able to:

  1. Create a spreadsheet in Google Sheet.
  2. Publish the spreadsheet to the web.
  3. Generate a dynamic JSON API for it.
  4. Pass the JSON API to your back-end developer.

After you've finished this short tutorial, you'll be able to join new teams and say,

"I can help out with the back-end 👍".


1. Prepare your Spreadsheet

For the Spreadsheet you're going to connect to sheet2api, the first row (1) must only contain column names.
All the other rows may contain data, in whatever format you'd like (symbols, numbers, dates, words, etc).

For example:

A B C D E
1 Name Favourite Thing Image
2 Bugs Bunny Carrots Bugs.png
3 Elmer Fudd Chasing Rabbits Elmer.png
4
Looney Tunes
The Simpsons
Sheet3

You may add multiple worksheets such as 'Looney Tunes', 'The Simpsons' to seperate different categories of data.
sheet2api will create an API endpoint for each of these automatically.

2. Create Spreadsheet API

As per the video below:

  1. Copy the Share Link to your Google Sheet.
  2. Create a Spreadsheet API using that Share Link.
  3. Proceed to the next step.

3. Try out your new JSON API

That's the hard work done, now let's try out the new API.

Copy the API URL for your new API listed in your account Your Spreadsheets page, as below.

Your Spreadsheet APIs list in account

Now, visit www.reqbin.com, paste that URL into the form and click "Send".

You should see the contents of your Spreadsheet appear as JSON on the right side of the page.

Here's a video of those steps:

4. Share your API

You've reached the end, great!


Now you can share your sheet2api API URL with anyone.
When your Spreadsheet gets updated, so will your API, automatically! 🤖


It's as easy as that 🎉.

If you found this useful, Tweet it to a friend.

If you need help, please feel free to send a message via the contact page.

Start using sheet2api now

Be up & running in seconds.