---
title: "Discussion on \"Using Google sheets as an API For your next app\" | Hashnode"
description: "Discussion on \"Using Google sheets as an API For your next app\". 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 ..."
url: "https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Using Google sheets as an API For your next app](https://blog.gauravtewari.xyz/using-google-sheets-as-an-api-for-your-next-app?utm_source=hashnode&utm_medium=feed)

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 ...

Jan 24, 2021 · 3 min read · blog.gauravtewari.xyz  
Read the article

-   [#productivity](https://hashnode.com/tag/productivity)
-   [#coding](https://hashnode.com/tag/coding)
-   [#tutorial](https://hashnode.com/tag/tutorial)
-   [#technology](https://hashnode.com/tag/technology)
-   [#programming](https://hashnode.com/tag/programming)

## Written by

[Gaurav Tewari](https://hashnode.com/@tewarig)

@tewarig · Dehradun ,India

  
[View profile](https://hashnode.com/@tewarig)

frontend engineer @razorpay

## Responses 9

Markdown supported · ⌘↵ to post

[Nishant Tiwari](https://hashnode.com/@dx4iot)

[Feb 3, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/601ac30edc773e253be7e981)

impressive 😃

[theroyakash](https://hashnode.com/@theroyakash)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600f2bb53fdbb741262616b3)

Man super helpful.

[Alimam Miya](https://hashnode.com/@alimammiya)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600ee46e3fdbb74126261025)

Can you send me the full source code?

[Gaurav Tewari](https://hashnode.com/@tewarig)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600ee46e3fdbb74126261025#reply-600f0ee93b349540feba08b7)

this method is direct no source code is required.

[Alimam Miya](https://hashnode.com/@alimammiya)

[Jan 26, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600ee46e3fdbb74126261025#reply-600fa36bdf57175c6a9fb81b)

[Gaurav Tewari](https://hashnode.com/@tewarig) But this code [cdn.hashnode.com/res/hashnode/image/upload/v16114…](https://cdn.hashnode.com/res/hashnode/image/upload/v1611493237732/pi5mC8Wci.png?auto=compress)

[Gaurav Tewari](https://hashnode.com/@tewarig)

[Jan 26, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600ee46e3fdbb74126261025#reply-600fc89d9d3cb25c41e0abcb)

[Alimam Miya](https://hashnode.com/@alimammiya) oh this is the response we get from the API. [spreadsheets.google.com/feeds/list/1cXItNrEtnHRBI…](https://spreadsheets.google.com/feeds/list/1cXItNrEtnHRBIAo612LImhjnsFMSbgli-R94T2SPhHE/od6/public/basic?alt=json)

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.

[Emam Miya](https://hashnode.com/@emammiya)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600ee41c3b349540feba04a5)

Thanks this is very helpfull

[Zurik Phillips](https://hashnode.com/@zurik)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600edf8e3fdbb74126260fce)

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!

[Gaurav Tewari](https://hashnode.com/@tewarig)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600edf8e3fdbb74126260fce#reply-600f0f2f3b349540feba08c2)

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

[Salman Qureshi](https://hashnode.com/@Hotheadhacker)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600ed2653b349540feba035c)

Thats very informative 👍

[Shubham Waje](https://hashnode.com/@wajeshubham)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600e60b83fdbb74126260528)

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.

[Gaurav Tewari](https://hashnode.com/@tewarig)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600e60b83fdbb74126260528#reply-600e80033b349540feb9fc9d)

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](https://developers.google.com/sheets/api)

[Shubham Waje](https://hashnode.com/@wajeshubham)

[Jan 25, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600e60b83fdbb74126260528#reply-600e81073b349540feb9fcc4)

Oh i see, then it would be a great option for small projects. Thanks for sharing this✌🏻[Gaurav Tewari](https://hashnode.com/@tewarig)

[Bhargav Ponnapalli](https://hashnode.com/@codewithbhargav)

[Jan 24, 2021](https://hashnode.com/posts/using-google-sheets-as-an-api-for-your-next-app/600d72643fdbb7412625f859/comment/600dc1403fdbb7412625ff12)

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

Thanks [Gaurav Tewari](https://hashnode.com/@tewarig)! Keep going!!
