Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to create a new Google Sheets spreadsheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Create spreadsheet function creates a new Google Sheets spreadsheet with the specified title. Returns the spreadsheet ID and URL of the newly created file.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Title | Yes | Text | - | The title for the new spreadsheet |
| Variable | Yes | Text | - | Variable to store the result |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing spreadsheetId, spreadsheetUrl, and title |
Errors
- Insufficient permissions – the app lacks spreadsheets scope
- Quota exceeded – Google API rate limit reached
Tips
- The new spreadsheet is created in the root of the authenticated user’s Google Drive
- Use Google Drive actions to move the file to a specific folder after creation
- Access the spreadsheet ID from {variable.spreadsheetId} for subsequent operations
Related functions
- Open spreadsheet – Open an existing spreadsheet
- Write sheet range – Write values to the new spreadsheet