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

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

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

Sheet via LowCodeAPI

Google Sheets

Google Sheets API

Pre-configured, Predictable, Single Interface, Ready-to-use, Opinionated & Managed API Explorer & Server. Bring your API credentials, configure and access your 3rd party APIs. Using LowCodeAPI securely manage all integrations in one place.