Skip to main content
Version: Current

Write Cell

Description​

Writes a value to a cell in a Google Sheet, either at a specified cell address or at the next empty cell on a chosen column or row when Append to End is enabled.

The value can be plain text, a number, a date, or a formula.

Common settings​

Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.

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 containing the cell to update.

Sheet Name​

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

If not specified, the currently active sheet is used.

Append to End​

When enabled, writes the value at the next empty cell after the last used data on the chosen column or row.

Appending skips gaps within existing data. For example, if B1 and B3 contain values and B2 is empty, appending to column B writes to B4. If A5 and C5 contain values, appending to row 5 writes to D5. For an empty column E, writing starts at E1; for an empty row 10, writing starts at A10.

Default value is False.

Configure this checkbox at design time. Append to End does not support Process Data variables or Liquid expressions.

When Append to End is enabled, Cell Address is ignored. Provide either Column Letter or Row Number, but not both.

Cell Address​

The cell where the value will be written.

Required when Append to End is disabled. Ignored when Append to End is enabled.

Column Letter​

When Append to End is enabled, writes in the next empty cell of this column (for example, A).

Provide either Column Letter or Row Number, not both.

Row Number​

When Append to End is enabled, writes in the next empty cell of this row (for example, 1).

Provide either Column Letter or Row Number, not both.

Value​

The value to write to the specified cell.

Supported values include:

  • Text
  • Numbers
  • Dates
  • Formulas
info

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

Execution settings​

Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.

Output​

Result​

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.
  • When Append to End is disabled, the value is written to Cell Address. If the target cell already contains a value, the existing value is replaced.
  • When Append to End is enabled, Cell Address is ignored. Specify exactly one of Column Letter or Row Number to write at the next empty cell on that column or row.
  • Values beginning with = are interpreted as formulas by Google Sheets.
  • If a formula is written, Google Sheets automatically calculates and stores the result.
  • To write values to multiple cells, use the Write Range activity.

Example: Write text or a formula​

Set Sheet Name to Orders and Cell Address to D10. Supply =SUM(D2:D9) as Value to write a formula. The input is interpreted as user-entered content, so numbers and dates can be parsed according to the spreadsheet's settings. Use an unambiguous date representation and verify the resulting display format.

Inspect Result → UpdatedRange and UpdatedCells. Other Result fields are UpdatedRows, UpdatedColumns, and ValuesJson.

Help improve this page