Frends.GoogleSheets.WriteData / 1.1.0
Summary
Writes rows into a spreadsheet from a starting cell, either extending what is there or overwriting it, and reports the range it touched.
Typical use — publishing results where people want to read and filter them themselves rather than in a database
Essential parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| SpreadsheetId | String |
– | abcdef12345...98765ABC |
The spreadsheet ID of the Google Sheets document. |
| StartingCell | String |
Sheet1!A1 |
Sheet1!A1 |
The A1 notation of the starting cell where data will be written. |
| Values | String |
– | [ ["Value1", "Value2"], ["Value3", "Value4"] ] |
The values to write, formatted as a JSON string representing a 2D array. Each inner array represents a row of values. |