Skip to main content
Google Sheets
Google Sheets
16 actions · 1 auth method
Documents

​
Authentication

OAuth 2.0

The steps in this guide require Admin or Owner privileges within Google Cloud.Guides: Connector Profile, Link Account
Actions
|
16 actions
Action
Description
Required scopes
Get Spreadsheet
Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID.
Create Spreadsheet
Creates a spreadsheet, returning the newly created spreadsheet.
Get Spreadsheet By Data Filter
Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. This method differs from spreadshee…
Get Values
Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.
Update Values
Updates a single contiguous range in a spreadsheet. Use Batch Update Values for multiple ranges or better efficiency.
Batch Update Values
Atomically updates one or more ranges. All succeed or fail together. More efficient than separate calls.
Append Values
Appends rows after the last row of a detected table. The range specifies where to search for the table, not where data i…
Clear Values
Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared; all oth…
Batch Get Values
Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more rang…
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 a…
Batch Clear Values
Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more range…
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 DataF…
Batch Update Spreadsheet
Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not va…
Get Developer Metadata
Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer metad…
Search Developer Metadata
Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a DeveloperMetad…
Copy Sheet
Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.

​
Getting Started

1

Create or Select a Project

Set up a new project or select an existing one. See the Projects Guide.
2

Configure the Connector

Enable the connector and set up a connector profile in your project. See Managing Connectors.
https://stackone-logos.com/api/google-sheets/filled/png

Connector Profile

Google Sheets - OAuth 2.0
3

Link an Account

Connect an account using StackOne Hub or Auth Link.
https://stackone-logos.com/api/google-sheets/filled/png

Link Account

Google Sheets - OAuth 2.0
4

Use Actions

Invoke actions using one of the methods below: