Create

This activity helps the user to create a new spreadsheet in the specified google account.

Properties

Configuration

Each activity requires a connection with Google Sheets authentication. Once you select the respective project name where Google Sheets has been authenticated, the activity will automatically retrieve the available connections for that project.

Below are the properties available after the project has been integrated:

Google: *This parameter indicates the account name associated with the integration.

Folder: *This parameter indicates to provide the “Folder” name against where the created spreadsheet needs to be placed. It offers multiple ways to choose the Folder:

1. Browse Option: When selecting the “Click on Browse” option, it will automatically list the folders available for the specified account. The user must manually select the spreadsheet each time when using this option.
2. Three-Line Menu: Clicking on the “Three lines” icon will open a context menu with the following two options.
a. Reload Folder Picker: Refreshes the selected folder to select a new folder name.
b. Use Variable: Allows you to provide the “Folder Name” as a variable in “String” format. You can either hardcode the values as a string or use a variable of the “String” datatype. Below are the values that can be provided as variable,
   i. URL or ID: After creating the folder in the specified Google account, you will receive the Folder’s URL and ID. You can use these as a reference to add a new spreadsheet.
   ii. Folder Name: You can either hardcode the name as a string or provide a variable of the “String” datatype.

INPUT

WorkbookName: *This parameter specifies the existing spreadsheet where a new sheet will be added. It offers multiple ways to choose the spreadsheet: 
1. Browse Option: When selecting the “Click on Browse” option, it will automatically list the folders and spreadsheets available for the specified account. The user must manually select the spreadsheet each time when using this option.
2. Three-Line Menu: Clicking on the “Three lines” icon will open a context menu with the following two options.
a. Reload Folder Picker: Refreshes the selected folder or spreadsheet.
b. Use Variable: Allows you to provide the “Workbook Name” as a variable in “String” format. You can either hardcode the values as a string or use a variable of the “String” datatype. Below are the values that can be provided as variable,
    i. URL or ID: After creating the workbook in the specified Google account, you will receive the workbook’s URL and ID. You can use these as a reference to add a new sheet within the workbook.
   ii. Spreadsheet Name: You can either hardcode the name as a string or provide a variable of the “String” datatype.

First Sheet Name: *This parameter specifies the name of the “Sheet” to be created. It accepts values in “String” format, which can be either hardcoded or provided as a variable in the “String” datatype.

If Spreadsheet Already Exists / CreatedSpreadsheetType: If the provided spreadsheet already exists in the specified folder, the activity offers the following options:
1. DontReplace: The spreadsheet will not be replaced, and the workflow will be aborted if a spreadsheet with the same name already exists.
2. Replace: The existing spreadsheet will be replaced with a new one if the same name is found in the folder.
3. AutoRename: If a spreadsheet with the same name already exists, it will automatically rename the new spreadsheet.
4. Addasseperatefile: If a spreadsheet with the same name already exists, a new file with the same name will be created as a separate file in the specified folder.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

CreatedSpreadsheetInfoItems: This parameter allows the user to view the details of the created spreadsheet. The following items are provided:
1. FullName: Displays the full name of the created spreadsheet. You can access this value using Variable.FullName.
2. URL: Provides the URL of the created spreadsheet. You can access this value using Variable.URL.
3. URI: Provides the URI of the created spreadsheet. You can access this value using Variable.URI.
4. CreatedDate: Displays the creation date of the spreadsheet. You can access this value using Variable.CreatedDate.
5. ID: Provides the unique ID of the created spreadsheet. You can access this value using Variable.ID.
6. Name: Displays the name of the created spreadsheet. You can access this value using Variable.Name.
7. ParentID: Displays the name of the parent folder where the spreadsheet is stored. You can access this value using Variable.ParentID.
8. MimeType: Indicates whether the created item is a file or folder. You can access this value using Variable.MimeType.
9. Size: Displays the size of the created spreadsheet. You can access this value using Variable.Size”.

Result: It provides the ability to view the execution status of the activity. It returns values in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.