Import Sheet From CSV / XLSX

1. Complete the Setup steps.
2. Add the Smartsheet Application Scope activity to your project.
3. Add the Import Sheet activity inside the Smartsheet Application Scope activity.
4. Create an enter values for the Input properties.
5. Enter values for the Output properties. The (Folder ID) and (Workspace ID) cannot both be populated as options.
6. Create and enter an ResponseStatus variable for the Output property.

• Sheet Name - Desired name of the sheet. This field supports only Strings or String variables.
• Local File Path - File path to the file to upload. This field supports only Strings or String variables.
• Folder Id - The id of the folder to upload the sheet to. Enter a Int64 or Int64 variable.
• Workspace Id - The id of the Workspace to upload the sheet to. Enter a Int64 or Int64 variable.
• Header Row Index - A zero-based integer indicating the row number to use for column names. Enter a Int32 or Int32 variable.
• Primary Column Index - A zero-based integer indicating the column to designate as primary. Enter a Int32 or Int32 variable.
• Sheet - The imported sheet. This field supports only Sheet variables.
• Permalink - The permalink of the new sheet. This field supports only String variables.

Common

• DisplayName - The display name of the activity. This field supports only Strings or String variables.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

• ResponseStatus - The status of the request (success/failure information). This field supports only ResponseStatus variables.