Skip to main content
v1.0.1
17 actions · 1 auth method
Documents

​
Getting Started

1

Create or Select a Project

Set up a new project or select an existing one. See Organizations & Projects.
2

Configure the Connector

Enable the connector and set up a Connector Profile in your project. See Setup Connector Profile.

Connector Profile · OAuth 2.0

The steps in this guide require Admin or Owner privileges within Google Cloud.
3

Link an Account

Link an account from the dashboard (or via StackOne Hub).See the guide for the authentication type chosen in the Connector Profile:

Link Account · OAuth 2.0

4

Use Actions

Connect an AI platform to the linked account’s actions. See AI Platforms.Other ways to call actions are listed in Protocols & SDKs.

​
Actions

|
17 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 Values By Data Filter
Sets values in one or more ranges selected by data filters. All updates succeed or fail together as a single atomic oper…
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.