Convert Google Sheets to JSON API

Speed up your prototyping by skipping API development and using Google Sheets instead.

First, you need to make your Google Sheets Document shareable (aka create a public link), and then paste it here.

Docs

Additional customisation of your API URL:

  1. Use
    ?parse=1
    query param to parse stored data into JSON format (eg. if you have valid JSON stored in sheets)
  2. Use
    ?limit=<number> 
    to "slice" your data (eg. if you have 1000 rows in your sheets and you only want to get the first 10 rows)