Skip to main content
Version: Current

Write Range

Description​

Writes tabular data to a Google Sheet starting at a specified cell.

The activity supports writing structured data from collections, lists, and other tabular data sources.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

Display Text​

A user-defined name for the activity, displayed on the workflow canvas to help identify its purpose.

Connection Name​

The configured Google Sheets connection used to access Google Sheets resources.

Spreadsheet​

The spreadsheet where the data will be written.

Sheet Name​

The name of the sheet where the operation will be performed.

If not specified, the currently active sheet is used.

Starting Cell Address​

The top-left cell where the write operation begins.

All data is written relative to this starting location.

Values​

The tabular data to write.

Supported inputs include:

  • Lists
  • Collections
  • Arrays
  • Structured tabular data

Include Header​

Determines whether column headers are written to the sheet.

When enabled, header values are written before the data rows.

Transpose​

Determines whether rows and columns are exchanged before writing the data.

When enabled:

  • Rows become columns
  • Columns become rows
info

For details about selecting spreadsheets, sheets, and cells, see Google Sheets Data Selection.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • Any incoming path completes, or
  • All relevant incoming paths complete before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include:

  • Fault
  • Continue
  • Suspend
  • Retry

Learn more → Error Handling

Output​

Update Details​

Information about the completed update operation.

Common details include:

  • Updated range
  • Number of cells updated
  • Number of rows updated
  • Number of columns updated

Remarks​

  • The authenticated Google account must have permission to modify the spreadsheet.
  • 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 Include Header is enabled, column headers are written before the data rows.
  • When Transpose is enabled, 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.