Append Values
-
Appends Rows After The Last Row Of A Detected Table. The Range Specifies Where To Search For The Table, Not Where Data Is Written.
Batch Clear Values
-
Clears One Or More Ranges Of Values From A Spreadsheet. The Caller Must Specify The Spreadsheet ID And One Or More Ranges. Only Values Are Cleared; All Other Properties Of The Cell (Such As Formatting And Data Validation) Are Kept.
Batch Clear Values By Data Filter
-
Clears One Or More Ranges Of Values From A Spreadsheet. The Caller Must Specify The Spreadsheet ID And One Or More DataFilters. Ranges Matching Any Of The Specified Data Filters Will Be Cleared. Only Values Are Cleared; All Other Properties Of The Cell (Such As Formatting, Data Validation, Etc.) Are Kept.
Batch Get Values
-
Returns One Or More Ranges Of Values From A Spreadsheet. The Caller Must Specify The Spreadsheet ID And One Or More Ranges.
Batch Get Values By Data Filter
-
Returns One Or More Ranges Of Values That Match The Specified Data Filters. The Caller Must Specify The Spreadsheet ID And One Or More DataFilters. Ranges That Match Any Of The Data Filters In The Request Will Be Returned.
Batch Update Spreadsheet
-
Applies One Or More Updates To The Spreadsheet. Each Request Is Validated Before Being Applied. If Any Request Is Not Valid Then The Entire Request Will Fail And Nothing Will Be Applied. Some Requests Have Replies To Give You Some Information About How They Are Applied. The Replies Will Mirror The Requests. For Example, If You Applied 4 Updates And The 3rd One Had A Reply, Then The Response Will Have 2 Empty Replies, The Actual Reply, And Another Empty Reply, In That Order. Due To The Collaborative Nature Of Spreadsheets, It Is Not Guaranteed That The Spreadsheet Will Reflect Exactly Your Changes After This Completes, However It Is Guaranteed That The Updates In The Request Will Be Applied Together Atomically. Your Changes May Be Altered With Respect To Collaborator Changes. If There Are No Collaborators, The Spreadsheet Should Reflect Your Changes.
Batch Update Values
-
Atomically Updates One Or More Ranges. All Succeed Or Fail Together. More Efficient Than Separate Calls.
Clear Values
-
Clears Values From A Spreadsheet. The Caller Must Specify The Spreadsheet ID And Range. Only Values Are Cleared; All Other Properties Of The Cell (Such As Formatting, Data Validation, Etc.) Are Kept.
Copy Sheet
-
Copies A Single Sheet From A Spreadsheet To Another Spreadsheet. Returns The Properties Of The Newly Created Sheet.
Create Spreadsheet
-
Creates A Spreadsheet, Returning The Newly Created Spreadsheet.
Get Developer Metadata
-
Returns The Developer Metadata With The Specified ID. The Caller Must Specify The Spreadsheet ID And The Developer Metadata'S Unique MetadataId.
Get Spreadsheet
-
Returns The Spreadsheet At The Given ID. The Caller Must Specify The Spreadsheet ID.
Get Spreadsheet By Data Filter
-
Returns The Spreadsheet At The Given ID. The Caller Must Specify The Spreadsheet ID. This Method Differs From Spreadsheets.Get In That It Allows Selecting Which Subsets Of Spreadsheet Data To Return By Specifying A DataFilters Parameter. Multiple DataFilters Can Be Specified. Specifying One Or More Data Filters Returns The Portions Of The Spreadsheet That Intersect Ranges Matched By Any Of The Filters.
Get Values
-
Returns A Range Of Values From A Spreadsheet. The Caller Must Specify The Spreadsheet ID And A Range.
Search Developer Metadata
-
Returns All Developer Metadata Matching The Specified DataFilter. If The Provided DataFilter Represents A DeveloperMetadataLookup Object, This Will Return All DeveloperMetadata Entries Selected By It. If The DataFilter Represents A Location In A Spreadsheet, This Will Return All Developer Metadata Associated With Locations Intersecting That Region.
Update Values
-
Updates A Single Contiguous Range In A Spreadsheet. Use Batch Update Values For Multiple Ranges Or Better Efficiency.
.svg)
