Discussion on "Using Google sheets as an API For your next app"

Gaurav Tewari · 2021-01-24T13:13:08.592Z

Yup, you can use google sheets as an API for your next app .. yes it is possible. Google already provides an API that you can use to read and write data in google sheets also there is an npm package to do the same. so you can basically do all basic ...

Can you send me the full source code?

this method is direct no source code is required.

Alimam Miya oh this is the response we get from the API. spreadsheets.google.com/feeds/list/1cXItNrEtnHRBI…

hit this URL you will get the same data.. I am using a chrome extension to beautify the response we are getting from this request.

Thanks this is very helpfull

Interesting, I've always used json formatted data, placed in a .db file and then used npm install jason-server. However this method is nice because I dont need to run any additional server to serve my data. Google already does it for me!

Nice, I will use this for my next project. Keep up the good work!

yes, that's the best part no need for a server. which saves a lot of time and money.

Thats very informative 👍

Wow! That looks really cool. But, I don't think we can make http requests like POST, PUT, DELETE etc. on it. If I'm wrong please correct me.

But, really a great way to convert a large amount of data in an api.

yes can't make other HTTP requests like PUT, POST, and Delete, but you can use google sheets API to do that developers.google.com/sheets/api

Oh i see, then it would be a great option for small projects. Thanks for sharing this✌🏻Gaurav Tewari

Super helpful. I always wondered if we can manage data easily using sheets with Google or notion.

Thanks Gaurav Tewari! Keep going!!

Search Hashnode

Using Google sheets as an API For your next app

Responses9