Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to close an open spreadsheet connection.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Close function releases the connection to a previously opened Google Sheets spreadsheet. This frees up resources and should be called when spreadsheet operations are complete.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Spreadsheet ID | Yes | Text | - | The spreadsheet ID of the open connection to close |
Errors
- No open connection – no spreadsheet connection exists for the given ID
Tips
- Always close spreadsheets when finished to avoid holding unnecessary connections
- Place close actions in a Finally block to ensure cleanup even when errors occur
Related functions
- Open spreadsheet – Open a spreadsheet connection
- Read sheet range – Read values from a range