Google Activities
Use the Google group to read and write Google Sheets spreadsheets from a workflow, and to hold the OAuth credentials that Google API calls authenticate with.
The fifteen Sheets activities are built on the REST Client and call
https://sheets.googleapis.com. The endpoint, method and query parameters are prefilled;
you supply the spreadsheet, the range, and the payload.
Available activities
Read values
| Activity | Purpose |
|---|---|
| GetValues | Reads one range of values |
| BatchGetValues | Reads several ranges in one call |
| BatchGetValuesByDataFilter | Reads ranges selected by data filter |
Write values
| Activity | Purpose |
|---|---|
| UpdateValues | Writes values to a range |
| AppendValues | Appends values after the last row of a range |
| BatchUpdateValues | Writes several ranges in one call |
| BatchUpdateValuesByDataFilter | Writes ranges selected by data filter |
Clear values
| Activity | Purpose |
|---|---|
| ClearValues | Clears one range |
| BatchClearValues | Clears several ranges in one call |
| BatchClearValuesByDataFilter | Clears ranges selected by data filter |
Spreadsheets and sheets
| Activity | Purpose |
|---|---|
| CreateSpreadsheet | Creates a spreadsheet |
| GetSpreadsheet | Retrieves a spreadsheet and its metadata |
| GetSpreadsheetByDataFilter | Retrieves a spreadsheet selected by data filter |
| BatchUpdateSpreadsheet | Applies a batch of structural updates |
| CopySheetToSpreadsheet | Copies a sheet into another spreadsheet |
Connection resources
These are resources rather than workflow steps. They hold OAuth credentials and scopes that the activities above authenticate with.
| Resource | Purpose |
|---|---|
| Gmail | OAuth connection for Gmail |
| GoogleDrive | OAuth connection for Google Drive |
| GoogleSheet | Connection for Google Sheets |
| GoogleSheetProvider | OAuth connection provider for Google Sheets |
| GoogleSheetsOauth | OAuth connection for Google Sheets |
Authentication
Every Sheets activity authenticates with OAuth 2. Auth Type offers a single option,
OAuth 2, and it is the default. Auth Resource takes the OAuth resource holding the
credentials.
The Auth Type help text on these activities reads "Options: No Auth, Basic, API Key, OAuth 2", but the field itself offers only OAuth 2. The help text is inherited from the REST Client the activities are built on.
The data filter variants
Five activities come in a plain form and a ByDataFilter form. The plain form takes the
range from the Range or Ranges field; the ByDataFilter form takes no range field
at all, because the filter that selects the cells travels in the request body instead.