Google Sheets — Write cell
Google Sheets — Write cell
Section titled “Google Sheets — Write cell”Type: googlesheets-write-cell · Package: Google Sheets Activities v1.0.5 · Output: —
Writes a value to one specific cell. Use it to place a single value: a total, a status, a processed mark. It accepts formulas.
How it works
Section titled “How it works”Writes value to the cell cell of the sheet sheet (the first one if empty), overwriting whatever was there. The value is converted to text and interpreted as USER_ENTERED, just as if you typed it: =SUM(A1:A10) becomes a formula, 1500 a number and 2026-06-15 a date. An empty or null value leaves the cell blank. The cell formatting (colors, borders) is kept.
Required parameters
Section titled “Required parameters”| Parameter | Type | Default | Description |
|---|---|---|---|
cell | string | — | Cell address in A1 notation, e.g. B3. |
value | object | — | Value to write: text, number or formula (=...). |
Optional parameters
Section titled “Optional parameters”| Parameter | Type | Default | Description |
|---|---|---|---|
session | ZoanGoogleSheetsSession | — | Session from Google Sheets — Open. Inside Open’s body it is inherited and you can leave it empty. |
sheet | string | — | Sheet name. If empty, the first sheet is used. |
Output
Section titled “Output”This activity does not return a value.
Common errors
Section titled “Common errors”| Message | Cause and fix |
|---|---|
'cell' is required. | cell is empty or its expression returned null. |
No Google Sheets session available. Provide 'session' from a googlesheets-open activity, or place this activity inside the Open activity's body … | The activity is outside Open’s body and received no session. Move it inside the body or pass the saved session. |
The service sheets has thrown an exception. HttpStatusCode is … | Google rejected the call: missing sheet or range, no access, expired token or quota exceeded. See Google API errors. |
Example
Section titled “Example”Google Sheets — Write cell session = book cell = "D1" value = "Processed " + now().ToString("yyyy-MM-dd")Google Sheets — Write cell session = book cell = "E1" value = "=SUM(B2:B100)" // formulaRelated activities
Section titled “Related activities”- Read cell — read one cell.
- Write range — write several cells.