Create your own REST API in just 5 minutes.
In this guide, we'll cover how to convert an existing Google Sheet spreadsheet into a restful JSON API. This can be useful for powering simple web pages using the spreadsheet as a CMS, creating mock-up Apps, or sharing data with another organisation without spending weeks deploying a custom solution.
You'll be able to search for records, add new records, update and delete existing records.
This will take under two minutes to do, giving you more time to focus on your product.
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 👍".
Let's get started.
For the Spreadsheet you're going to connect to sheet2api, the first row (1) must only contain column
All the other rows may contain data, in whatever format you'd like (symbols, numbers, dates, words, etc).
|3||Elmer Fudd||Chasing Rabbits||Elmer.png|
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.
As per the video below:
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.
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:
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 need help, please feel free to send a message via the contact page.