Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to delete a sheet tab.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Delete sheet tab function removes a sheet tab from a Google Sheets spreadsheet by its sheet ID. All data in the tab is permanently deleted.
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 | - | The numeric sheet ID (use Get metadata to find it) |
Errors
- Sheet not found – no sheet exists with the given ID
- Cannot delete last sheet – a spreadsheet must have at least one sheet tab
Tips
- Use Get metadata to find the numeric sheet ID before deleting
- This action is irreversible – all data in the tab is permanently removed
Related functions
- Add sheet tab – Add a new sheet tab
- Get metadata – List all sheet tabs and their IDs