Add New Sheet
AutomatR.GoogleSheets.Activities.AddNewSheet
The "Add New Sheet" activity in AutomatR facilitates the addition of a new sheet inside a specified Google spreadsheet. This activity is part of the Google Sheets activities package, allowing users to dynamically manage sheets within their Google Sheets documents.
Properties
| Name | Description |
|---|---|
| Input | |
| New Sheet Name | Specifies the name of the new sheet to be added to the Google spreadsheet. String variables containing the desired sheet name. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Add New Sheet" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Result | Outputs the result of the "Add New Sheet" operation, indicating whether the new sheet addition was successful or encountered errors. Variables of relevant types (e.g., Boolean variables) to store the operation result. |
How to Use
- Drag and drop the "Add New Sheet" activity onto the workflow.
- Configure the properties by specifying the new sheet name.
- Optionally, configure the delay and customize the display name.
- Execute the workflow to add a new sheet to the specified Google spreadsheet.
Example
Consider an example where the "Add New Sheet" activity is used to add a sheet named "Monthly Expenses" to an existing Google spreadsheet:
Add New Sheet:
Display Name: "Add Monthly Expenses Sheet"
New Sheet Name: "Monthly Expenses"
Result: isAdditionSuccessful
In this example, the activity adds a new sheet named "Monthly Expenses" to the Google spreadsheet. The result of the operation (success or failure) is stored in the Boolean variable "isAdditionSuccessful" for further handling in the workflow.