Append To Spreadsheet
danger
This action has been deprecated and will no longer be available in new workflows.
Appends values to a spreadsheet. The input range is used to search for
existing data and find a "table" within that range. Values will be appended to the
next row of the table, starting with the first column of the table. See the guide
and sample code for specific details
of how tables are detected and data is appended. The caller must specify the spreadsheet
ID, range, and a valueInputOption. The valueInputOption
only controls how the
input data will be added to the sheet (column-wise or row-wise), it does not influence
what cell the data starts being written to.
Basic Parameters
Parameter | Description |
---|---|
Major Dimension | The major dimension of the values. For output, if the spreadsheet data is: A1=1,B1=2,A2=3,B2=4 , then requesting range=A1:B2,majorDimension=ROWS will return [[1,2],[3,4]] , whereas requesting range=A1:B2,majorDimension=COLUMNS will return [[1,3],[2,4]] . For input, with range=A1:B2,majorDimension=ROWS then [[1,2],[3,4]] will set A1=1,B1=2,A2=3,B2=4 . With range=A1:B2,majorDimension=COLUMNS then [[1,2],[3,4]] will set A1=1,B1=3,A2=2,B2=4 . When writing, if this fieldis not set, it defaults to ROWS. |
Range | The range the values cover, in A1 notation. For output, this range indicates the entire requested range, even though the values will exclude trailing rows and columns. When appending values, this field represents the range to search for a table, after which values will be appended. |
Spreadsheet ID | The ID of the spreadsheet to update. |
Value Input Option | How the input data should be interpreted. |
Values | A JSON list of the data to be written. Supported value types are: bool, string, and double. Null values will be skipped. To set a cell to an empty value, set the string value to an empty string. e.g ["value1", "2.1", "false"]. |
Advanced Parameters
Parameter | Description |
---|---|
Delegated User Override | Perform the action on behalf of another user, overriding the delegated user defined in the connection. If not specified, the delegated user is the one provided in the connection. Has no effect when using an OAuth connection. NOTE: the connection details are not edited by this input. |
Example Output
{
"spreadsheetId": "1uW957i4riQvq4E4zRwpwCMuwas_BRIuEPvlPQ0qsB70",
"tableRange": "Sheet1!A1:E55",
"updates": {
"spreadsheetId": "1uW957i4riQvq4E4zRwpwCMuwas_BRIuEPvlPQ0qsB70",
"updatedRange": "Sheet1!A56:E56",
"updatedRows": 1,
"updatedColumns": 5,
"updatedCells": 5
}
}
Workflow Library Example
Append to Spreadsheet with Google Sheets and Send Results Via Email