Google Sheet

Convert your Google Sheet into JSON API without coding

Overview

Everyone knows about google sheet and the use cases. People using Google sheet to make daily logs, meeting notes, Quick MVP in Sheet, and People also building websites with Google Sheet.

So, you can convert your Google spreadsheet into JSON API without code and integrate it into your system.

Getting started

We are assuming that you already signup on nocodeapi.com. If not then first make an account and activate Google Sheet API from Marketplace

To make Google Sheet API you have to Authenticate with your Google Account. After this we just need your spreadsheet id to make Sheet API.

  • Sheet ID - Your google spreadsheet ID of which you want API.

Example URL https://docs.google.com/spreadsheets/d/1mkabaGFBmlXENl5b-HLVRRCNU8Tx_y3Pe_gnyIREX1I/edit

The Sheet ID is the part after d/, in the above link, it's 1mkabaGFBmlXENl5b-HLVRRCNU8Tx_y3Pe_gnyIREX1I

Click on Create Google Sheet API button then authenticate with your Google Account. After authenticate you will be redirected back to the NoCodeAPI with a Modal, just follow the form and click on Create button. 🎉 Done!

Endpoints

There are following endpoints for Google Sheet API:

  • Get All Records - Get all sheet data by tabId.
  • Get single row - Pass row id to get single row object from sheet.
  • Append new row - Push new row into your google sheet.
  • Update row - Pass object with new values with row_id.
  • Delete one row - You can also delete one row or multiple rows at a time.
  • Create new Spreedsheet - You can also make fresh new spreedsheet with POST call.
  • Add Sheet Tab - You can add new tab into your spreedsheet with this endpoint.

Video Tutorial

If you love video tutorial then we also have video tutorial for you.