Using Google Sheet API is very basic with NoCodeAPI. We make the process to access data from your google sheet is so easy and quick. Just authenticate with your Google account and rest we will do for you.

There are the following reasons we build this tool to Save your Time by building your backend.

  • Write API endpoint with your framework(express, Django, Ruby on Rail, etc)
  • Secure Access Token
  • Maintain Server
  • Config caching technology to make API faster
  • Figure out complex documentation
  • Build your own logs system to visualize your APIs
  • Required more time to do all these things.

With NoCodeAPI you can access, update, and delete your google sheet data in 2 minutes with many built-in features:

Setup Sheet API

I'm assuming that you already signup on NoCodeAPI. If not then first make an account there and activate Google Sheet API from Marketplace. Follow this article for a quick setup. Setup Google Sheet API

When you will finish your Google Sheet API then you will see this card with your sheet secure API endpoint.

Google Sheet API Card

Use API Endpoints:

With Google sheet API you can do:

  • Get rows (GET Request)
  • Get single row (GET Request)
  • Add new row (POST Request)
  • Update a row (PUT Request)
  • Delete a row (DELETE Request)

Note: I'll use the CURL command for the demo.

In one Google spreadsheet, you can add multiple tabs, and first, you have to know the tab name of which you want to use API. On the bottom, you can see your all tab's names. In this image api-database, lists & Sheet2 are tabId.

Tab Names

#Get rows

To get your sheet rows to make a GET call to your endpoint with tabId query params and it will return your data as JSON.

curl https://v1.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=<tabId>

Here is the result that will be consoled as JSON.

{
  "data": [
    {
      "row_id": 2,
      "name": "NoCodeAPI",
      "link": "https://nocodeapi.com",
      "description": "Quick and Easy API Gateway for your favorite Applications"
    },
    {
      "row_id": 3,
      "name": "Public APIs",
      "link": "https://public-apis.io",
      "description": "A collection of public APIs for software developers "
    }
  ],
  "total": 2
}

#Get single row

To get a single row from sheet make a GET call to your endpoint with tabId & row_id query params and it will return single data object as JSON.

curl https://v1.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=<tabId>&row_id=<row_id>

Here is a result you will get.

{
  "row_id": 2,
  "name": "NoCodeAPI",
  "link": "https://nocodeapi.com",
  "description": "Quick and Easy API Gateway for your favorite Applications"
}

#Add new row

To add a new row in your google sheet you have made a POST call with Array of rows into body

curl --request POST "https://v1.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=<tabId>" \
-H "Content-Type: application/json" \
--data '[
  [
    "Producthunt",
    "https://producthunt.com",
    "A website to launch new products"
  ],
  [
    "Twitter",
    "https://twitter.com",
    "A Social networking plateform for peoples"
  ]
]'

When you hit this command into the terminal then you will get this message:

{ "message": "Successfully Inserted" }

#Update row

To update a row in your google sheet you have made a PUT call with object data into body

curl --request PUT "https://v1.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=<tabId>" \
-H "Content-Type: application/json" \
--data-raw '{
  "row_id": 3,
  "name": "Producthunt 3",
  "link": "https://producthunt.com",
  "description": "A website to launch new products"
}'

When you hit this command into the terminal then you will get this message:

{ "message": "Updated successfully" }

#Delete row

To delete one row from your google sheet you have made a DELETE call with tabId & row_id query params.

curl --request DELETE https://v1.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=<tabId>&row_id=<row_id>

When you hit this command into the terminal then you will get this message:

{ "message": "Deleted successfully" }

We did it.

If you looking example code of GET, POST, PUT & DELETE into other languages then read these articles.

HTTP GET Examples
HTTP POST Examples
HTTP PUT Examples
HTTP DELETE Examples

Yes, That's all. If you have any other use cases then let us know about that. So, we can make an blog post about that.