Turn any Google sheet into an API instantly, for free. Power websites, apps, or whatever you like, all from a spreadsheet. Changes to your spreadsheet update your API in realtime. Neat.

Important note: The Google Sheet URL to use must be a valid Google Sheet CSV URL. Just follow these 3 simple steps as explained here.

Install the package like this:

npm i sheetyjs or yarn add sheety

And then use it like this:

import { getJsonUrl, getJsonObject } from 'sheetjs'

// this must be a valid Google Sheet CSV URL as mentioned above
const googleSheetUrl = ''

// you can get the json file url
const jsonUrl = await getJsonUrl(googleSheetUrl)

// or the json object right away
const jsonObject = await getJsonObject(googleSheetUrl)

Magic ✨

Special thanks to @phillipcaudell for creating sheety.co