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

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

  • Bypass Rate limit
  • Allowed Multiple Google Accounts to use
  • Get more than 100 rows in one API call
  • Add, Update, & delete more than 10 rows in one API call.
  • Secure your API key
  • No server setup
  • Track your API logs
  • and more.

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 the Create Google Sheet API button then authenticate with your Google Account. After authenticating you will be redirected back to the NoCodeAPI with a Modal, just follow the form and click on Create button. 🎉 Done!

Endpoints

There are the 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 Spreadsheet - You can also make fresh new spreadsheet with POST call.
  • Add Sheet Tab - You can add a new tab into your spreadsheet with this endpoint.
  • Search - You can search into your sheet

Video Tutorial

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

NoCodeAPI 3.0 - The easiest way to connect with APIs without code. | Product Hunt