Copy Sheet To Spreadsheet
CopySheetToSpreadsheet copies a single sheet into another spreadsheet.
It calls POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo.
The activity has 4 tabs: Configuration, Auth, Input, and Output.
Configuration
| Field | Required | Description |
|---|---|---|
| Name | Optional | Name of the step, should be unique within this workflow. |
| Description | Optional | Describe the purpose or function of this step. |
| Spreadsheet Id | Optional | Enter the ID of the spreadsheet to access its data. |
| Sheet Id | Optional | Enter the ID of the sheet to retrieve its details. |
Auth
| Field | Required | Description |
|---|---|---|
| Auth Type | Optional | The authentication method for the request. OAuth 2 is the only option, and the default. |
| Auth Resource | Optional | OAuth resource containing credentials. |
Input
This activity is built on the REST Client, so the Input tab is the generic HTTP request rather than a Google Sheets-shaped payload.
| Field | Required | Data Type | Description |
|---|---|---|---|
| Target | Required | Object | The HTTP request. |
Output
The activity returns an httpResponse object.
| Field | Data Type | Description |
|---|---|---|
| status.code | Integer | Numeric HTTP status code. |
| status.message | String | Short message associated with the HTTP status. |
| headers | Object | HTTP response headers. |
| body | Object | Parsed body of the response. |
The response body carries:
| Field | Data Type | Description |
|---|---|---|
| sheetId | Integer | The ID of the sheet. |
| title | String | The name of the sheet. |
| index | Integer | The index of the sheet within the spreadsheet. |
| sheetType | String | The type of sheet. |
| gridProperties | Object | Properties of a grid. |
| hidden | Boolean | True if the sheet is hidden in the UI. |
| dataSourceSheetProperties | Object | — |