Actions11
Sheet → Create
AI-generatedOverview
This node allows users to create a new sheet within an existing Google Sheets spreadsheet using a Google Service Account for authentication. It is useful for automating the management of spreadsheets, such as adding new sheets programmatically without manual intervention. For example, it can be used in workflows that require dynamic sheet creation based on incoming data or events.
Use Case Examples
- Automatically create a new sheet in a Google Sheets spreadsheet to organize data for a new project.
- Add a new sheet to a spreadsheet as part of a data processing pipeline to separate different data sets.
Properties
| Name | Meaning |
|---|---|
| Authentication | Choose the authentication method to access Google Sheets API, either using saved credentials or manual entry. |
| Service Account Email | The email address of the Google service account used for authentication (required if manual authentication is selected). |
| Private Key | The private key from the service account JSON used for authentication (required if manual authentication is selected). |
| Impersonate Email (Optional) | Email of a user to impersonate, requiring domain-wide delegation (optional, manual authentication only). |
| Spreadsheet ID | The ID of the Google Sheets spreadsheet where the new sheet will be created. |
| New Sheet Name | The name of the new sheet to be created within the specified spreadsheet. |
Output
JSON
json- The response data from the Google Sheets API after creating the new sheet, including details of the created sheet.
Dependencies
- Google Sheets API accessed via a Google service account with appropriate permissions.
Troubleshooting
- Common issues include missing or invalid credentials, which will cause authentication failures. Ensure the service account email and private key are correctly provided if using manual authentication.
- If the specified spreadsheet ID is incorrect or the user does not have access, the API call will fail. Verify the spreadsheet ID and permissions.
- Errors related to sheet name conflicts or invalid names may occur; ensure the new sheet name is unique within the spreadsheet.
Links
- Google Sheets API - Batch Update - Documentation for the API method used to create a new sheet in a spreadsheet.
- Using OAuth 2.0 for Server to Server Applications - Guide on how to use Google service accounts for authentication.