Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to merge cells in a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Merge cells function merges a range of cells into a single cell. The value of the top-left cell is preserved and all other values are discarded.
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 |
| Sheet ID | Yes | Text | - | Numeric sheet ID |
| Range | Yes | Text | - | A1 notation range to merge (e.g. A1:C1) |
| Merge type | No | Select | MERGE_ALL | MERGE_ALL, MERGE_COLUMNS, or MERGE_ROWS |
Errors
- Sheet not found – no sheet exists with the given ID
Tips
- Only the top-left cell value is kept; back up data before merging
- Use MERGE_ROWS to merge each row separately within the range
Related functions
- Unmerge cells – Unmerge previously merged cells
- Format cells – Apply formatting to cells