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

Pre-configured, Predictable, Single Interface, Ready-to-use, Opinionated & Managed API Explorer & Server - LowCodeAPI

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.

LowCodeAPI

Build Your Own 

Build & Bundle Your Own Custom API integrations and run independently.

API Token

Generate API Token

OpenAI

Google Docs

Notion

Gmail

Unsplash

Google Drive

Google Forms

Name.com

Gumroad

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.

Stripe

Razorpay

Resend

Mailgun

Postmark

AWS SES

Google Calendar

Replicate

AWS S3

Zoho Sheet

Zohomail

Zoho Tables

Zoho Expense

Zoho Contracts

Zoho Assist

Zoho Analytics

Zoho Webinar

Zoho Connect

Zoho Workely

Zoho SalesIQ

Zoho Bookings

Zoho Bug Tracker

Zoho Marketing 

Zoho Projects

Zoho zeptomail

Zoho Calendar

Zoho WorkDrive

Zoho CRM

Zoho Books

Zoho Desk

Zoho Sign

Zoho Lens

Zoho Invoice

Zoho Campaigns

Zoho Inventory

Zoho Commerce

Zoho Writer

Zoho FSM

Sendgrid

Mailchimp

Zoho People

Anthropic

ElevenLabs

Lovo

Voicemaker

PlayHT

LILT

Hive

Voice rss

Descript

Linguix

Yepic AI

CustomGPT.ai

Resemble AI

Twelve Labs

Nanonets

Leap AI

AssemblyAI

Stability AI

Colossyan

Unreal Speech

Writer AI

Copy AI

Perplexity AI

Hume AI

Letterdrop

TextCortex

Jasper

Cohere

Mistral AI

Goose AI

Cloudflare R2

Heygen AI

Others