Google Sheet API

How to connect and use Google Sheet API(sheet2json, sheet2api) as JSON endpoints to get rows as JSON, add rows, update rows, delete rows, create spreadsheets. Use Google Sheet JSON API as your backend and bypass API limits.

Get rows

Make GET request on this endpoint to get rows with required parameters(if any required).

https://v1.nocodeapi.com/<username>/google_sheets/<token>

- Request Parameters:

ObjectDescription
tabId[Required] Your Sheet Tab name. (ex: Sheet1)
row_id[Optional] If you want one row
perPage[Optional] Total number of records you want in one request.
page[Optional] Page number
valueRenderOption[Optional] Determines how values should be rendered in the output. FORMATTED_VALUE, UNFORMATTED_VALUE or FORMULA

Add new Rows

Make POST request on this endpoint to add new rows with required parameters(if any required).

https://v1.nocodeapi.com/<username>/google_sheets/<token>

- Request Parameters:

ObjectDescription
tabId[Required] Your Sheet Tab name. (ex: Sheet1)
body[Required] Array of row array into body

- Body data format example:

[
    [
        "NoCodeAPI",
        "hello@nocodeapi.com"
    ],
    [
        "Mohd Danish",
        "mddanishyusuf@gmail.com"
    ]
]

Update row

Make PUT request on this endpoint to update row with required parameters(if any required).

https://v1.nocodeapi.com/<username>/google_sheets/<token>

- Request Parameters:

ObjectDescription
tabId[Required] Your Sheet Tab name. (ex: Sheet1)
body[Required] Object of row into body with row_id

- Body data format example:

{
    "row_id": 3,
    "name": "NoCodeAPI v2",
    "email": "hello@nocodeapi.com"
}

Delete row

Make DELETE request on this endpoint to delete row with required parameters(if any required).

https://v1.nocodeapi.com/<username>/google_sheets/<token>

- Request Parameters:

ObjectDescription
tabId[Required] Your Sheet Tab name. (ex: Sheet1)
row_id[Required] Row id of your sheet of which you want to delete

Create new Spreedsheet

Make POST request on this endpoint to create new spreedsheet with required parameters(if any required).

https://v1.nocodeapi.com/<username>/google_sheets/<token>/create

- Request Parameters:

ObjectDescription
title[Optional] pass title query params

Search

Make GET request on this endpoint to search with required parameters(if any required).

https://v1.nocodeapi.com/<username>/google_sheets/<token>/search

- Request Parameters:

ObjectDescription
tabId[Required] Your Sheet Tab name. (ex: Sheet1)
searchKey[Required] search key to find result
searchValue[Required] text value to search