> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Append Rows To Sheet
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](https://developers.google.com/sheets/api/guides/values#appending_values)
and [sample code](https://developers.google.com/sheets/api/samples/writing#append_values) 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.
External Documentation
To learn more, visit the [Google Sheets documentation](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append#http-request).
## Basic Parameters
| Parameter | Description |
| --------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| File Identifier | The identifier of the file. You can create a file identifier using the `Set File Variable` action. |
| Range | The range the values cover, in [A1 notation](https://developers.google.com/sheets/api/guides/concepts#cell).
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. |
| Sheet Name | The name of the sheet. |
| Spreadsheet ID | The ID of the spreadsheet. |
| Values | The data that was read or to be written.
This is an array of arrays, the outer array representing all the data and each inner array representing a major dimension.
Each item in the inner array corresponds with one cell.
For input, 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. |
## 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. |
| 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 field
is not set, it defaults to ROWS. |
| Value Input Option | How the input data should be interpreted. |
## Example Output
```json theme={"dark"}
{
"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 Rows to Sheet with Google Sheets and Send Results Via Email](https://library.blinkops.com/workflows/append-rows-to-sheet-with-google-sheets-and-send-results-via-email)
Preview this Workflow on desktop