Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to auto-resize columns or rows.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Auto-resize function automatically adjusts the width of columns or height of rows to fit their content in a Google Sheets spreadsheet.
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 |
| Dimension | Yes | Select | COLUMNS | COLUMNS or ROWS |
| Start index | Yes | Number | 0 | Zero-based start index of the columns or rows to resize |
| End index | Yes | Number | - | Zero-based end index (exclusive) of the columns or rows to resize |
Errors
- Sheet not found – no sheet exists with the given ID
- Invalid indices – start or end index is out of range
Tips
- Use start=0, end=26 to auto-resize columns A through Z
- Apply after writing data to ensure all content is visible
Related functions
- Format cells – Apply cell formatting
- Insert columns – Insert new columns