Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to write values to a Google Sheet range.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Write sheet range function writes values to a specified range in a Google Sheets spreadsheet. The values are provided as a 2D array matching the target range dimensions.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Spreadsheet ID | Yes | Text | - | Google Sheets spreadsheet ID |
| Range | Yes | Text | - | A1 notation range (e.g. Sheet1!A1:D10) |
| Values | Yes | Text | - | 2D array of values to write, e.g. [["Name","Age"],["Alice","30"]] |
| Value input option | No | Select | USER_ENTERED | How values are interpreted: RAW (as-is) or USER_ENTERED (parsed like UI input) |
| Variable | Yes | Text | - | Variable to store the result |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing updatedRange, updatedRows, updatedColumns, and updatedCells |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid or you lack access
- Invalid range – the A1 notation is malformed
- Dimension mismatch – the values array does not match the range dimensions
Tips
- Use USER_ENTERED to have Google parse formulas, dates, and numbers automatically
- Use RAW to write values exactly as provided without parsing
- Write formulas by starting cell values with = (e.g. =SUM(A1:A10))
Related functions
- Read sheet range – Read values from a range
- Append rows – Add rows to the bottom
- Batch write ranges – Write to multiple ranges at once