Google Sheets — Write cell
Google Sheets — Write cell
Section titled “Google Sheets — Write cell”Type: googlesheets-write-cell · Package: Google Sheets Activities v1.0.0
Type a value into a specific cell. Use it to place specific data: a total, a status, a processing mark. Supports formulas.
How it works
Section titled “How it works”Type value in cell cell. The value is interpreted as USER_ENTERED: If you type =SUM(A1:A10), Google Sheets saves it as formula. Requires a Google Sheets — Open session.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
cell | expression | Cell address, e.g. B3. |
value | expression | Value to write (text, number or formula =...). |
Optional parameters
Section titled “Optional parameters”| Parameter | Editor | Description |
|---|---|---|
session | session | Google Sheets — Open session. Optional: within a body it is inherited. |
sheet | expression | Sheet name. By default, it activates it. |
Example
Section titled “Example”Google Sheets — Write cell session = = hoja cell = "D1" value = = "Procesado " + now().ToString("yyyy-MM-dd")Google Sheets — Write cell session = = hoja cell = "E1" value = "=SUM(B2:B100)" // fórmulaRelated activities
Section titled “Related activities”- Read cell — read a cell.
- Write range — write multiple cells.