Copies a range from one sheet to another sheet

spreadsheetId

sheetId

destinationSpreadsheetId

metadataId

dataFilters

range

majorDimension

valueRenderOption

dateTimeRenderOption

valueInputOption

includeValuesInResponse

responseValueRenderOption

responseDateTimeRenderOption

insertDataOption

Clears the sheet data of one or more ranges

Clears the ranges matching one or more data filter

Retruns data from one or more sheets based on matched condition

Updates one more more ranges in the spreadsheet

Updates one more more ranges in the spreadsheet based on condition

lookup

Clear specific sheet data of Googlesheets

Create new Googlesheet, this will create defaul sheet name Sheet 1

Sheet via LowCodeAPI

This spreadsheet fetches the list of sheets if no ranges is mentioned, If the ranges are populated it will return those filtered range, set includeGridData to true if you want the data associated with sheet to also be returned.

4 Ways this API can be used,

1. Get all the sheets (ranges), just pass the spreadsheet id

2. Get all the sheets (ranges) along with their data, pass the spreadsheet id and includeGridData as true (Don't use this if sheet has huge data)

3. Get only sheet or sheets specified in the ranges, pass spreadsheet id and ranges, pass ranges as comma seperated

4. Get only sheet or sheets specified in the ranges along with thier data, pass spreadsheet id, includeGridData as true and ranges, pass ranges as comma seperated.

ranges

includeGridData

use a1Range or gridRange to filter and fetch the data

a1Range must be a range and a string

gridRange is an object with sheetId which is number
with addtional values

"sheetId": 0,
"startRowIndex": 0,
"endRowIndex": 0,
"startColumnIndex": 0,
"endColumnIndex": 0

Google Sheets

Google Sheets API

LowCodeAPI

OpenAI

Notion

Featured

Google Docs

Gmail

gmail

Pixabay

PixabayAPI

ConvertKit

ConvertKitAPI

Unsplash

UnsplashAPI

Google Drive

Google DriveAPI

Google Forms

Google FormsAPI

Name.com

NameAPI

Cal.com

CalAPI

Gumroad

Pexels

PexelsAPI

Lemon Squeezy

Trello

Telegram

The Stripe API is organized around REST. Our API has predictable resource-oriented URLs, accepts form-encoded request bodies, returns JSON-encoded responses, and uses standard HTTP response codes, authentication, and verbs.

Featured

Others