Write Range
Description
Writes tabular data to a Google Sheet starting at a specified cell, or appends the data after the last used row when Append to End is enabled.
Configuration
Select the Google Sheets connection and spreadsheet, then set Sheet Name explicitly when the workflow must target a particular tab. See Google Sheets Data Selection.
| Property | Description |
|---|---|
| Starting Cell Address | Required top-left destination, such as A1. |
| DataTable | Required IbDataTable from a table-producing activity. Arbitrary JSON lists are not the current activity's input contract. |
| Sheet Name | Target tab. |
| Include Header | Write DataTable column names before the data rows. Default: False. |
| Transpose | Exchange rows and columns when writing. Default: False. |
Output
Result contains UpdatedRange, UpdatedRows, UpdatedColumns, UpdatedCells, and ValuesJson. Use these fields to inspect the affected area and returned values.
Example
Bind a two-column DataTable containing Customer and Amount and two rows. Set Starting Cell Address to A1, enable Include Header, and leave Transpose off. The output occupies A1:B3: one header row followed by two data rows.
With Transpose enabled, the equivalent header-plus-data matrix is written across columns, occupying A1:C2. Choose the orientation expected by the next consumer.
The write expands to fit the supplied data; it does not clear stale values outside that destination area. For older workflows using the deprecated list-based activity, convert the source to IbDataTable and rebind the current node.
Execution settings
- The authenticated Google account must have permission to modify the spreadsheet.
- When Append to End is disabled, data is written beginning at the specified starting cell and expands as needed based on the size of the input data. Existing values within the target range are overwritten.
- When Append to End is enabled, data is appended after the last used row of the sheet. Starting Cell Address and Transpose do not apply.
- When Include Header is enabled, column headers are written before the data rows.
- When Transpose is enabled and Append to End is disabled, rows and columns are exchanged before writing.
- Values beginning with
=are interpreted as formulas by Google Sheets. - To write a single value to a cell, use the Write Cell activity.