Google Sheets — Write sheet
Google Sheets — Write sheet
Section titled “Google Sheets — Write sheet”Type: googlesheets-write-sheet · Package: Google Sheets Activities v1.0.0
Write a set of data on the sheet, starting from A1. It is the direct way to dump data to Google Sheets: an Excel DataTable, the result of a query, a calculated list.
How it works
Section titled “How it works”Write the values starting from A1 on the indicated sheet. Accepts a DataTable (or a DataRow for a single row) — writes just the values (no headers). Requires a Google Sheets — Open session.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
values | expression | The DataTable to write (or a DataRow for a single row). |
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, the first. |
Example
Section titled “Example”Read Excel Sheet path = = asset("datos.xlsx") → output: tablaGoogle Sheets — Write sheet session = = hoja sheet = "Importado" values = = tablaRelated activities
Section titled “Related activities”- Write range — write at a specific position.
- Append rows — append at the end without overwriting.
- Clear range — limpiar antes de escribir.