Skip to main content

Smartsheet Connector

Smartsheet Smartsheet is a software as a service offering for collaboration and work management, developed and marketed by Smartsheet Inc. This component allows managing and interacting with Smartsheet sheets.

API Documentation

This component was built using the Smartsheet API Documentation

Connections

API Key

Authenticate requests to Smartsheet using an API key.

API keys can be used for development purposes, though an OAuth 2.0 connection is recommended for production integrations.

Refer to the Smartsheet API key documentation for instructions on generating an API key.

Configure the Connection

Create a connection of type API Key and configure the following fields:

  • Base URL: Select the Smartsheet API base URL. Most applications use the commercial endpoint. Government entities should select the government endpoint.
  • API Key: Enter the API key generated from the Smartsheet account settings.
InputCommentsDefault
Base URLMost applications use Smartsheet commercial. Government entities should select the government endpoint.https://api.smartsheet.com/2.0/
API KeyThe API key generated from the Smartsheet account settings.

OAuth 2.0

Authenticate requests to Smartsheet using OAuth 2.0.

To authenticate with Smartsheet through OAuth 2.0, create and configure an app within the Smartsheet account.

Prerequisites

  • A Smartsheet account with access to Developer Tools
  • A developer profile created in Smartsheet

Setup Steps

  1. Log in to Smartsheet
  2. Navigate to the profile icon (bottom left) and select Developer Tools
  3. Create a developer profile if one does not already exist
  4. Click Create New App
  5. Configure the app:
    • App Name: Enter the application name
    • App Description: Add a brief description
    • App Logo: Optional
    • Publish App: Leave unchecked (not required)
    • App Redirect URL: Enter https://oauth2.integrations.acme.com/callback
  6. Save the app and note the generated credentials:
    • App Client ID
    • App Secret

Configure the Connection

Create a connection of type OAuth 2.0 and configure the following fields:

  • API Domain: Select the Smartsheet API domain. Most applications use the commercial domain (api.smartsheet.com). Government entities should select the government endpoint (api.smartsheetgov.com).
  • App Domain: Select the Smartsheet application domain. This should match the API domain selection.
  • Scopes: A space-separated list of permissions to request. Remove any permissions not needed. Refer to the available scopes documentation for details.
  • App Client ID: Enter the client ID generated from the Smartsheet app.
  • App Secret: Enter the client secret generated from the Smartsheet app.

This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.

InputCommentsDefault
API DomainSelect the Smartsheet API domain. Most applications use commercial, but government entities should use the government endpoint.api.smartsheet.com
App DomainSelect the Smartsheet application domain. This should match your API domain selection.app.smartsheet.com
ScopesA space-separated list of permissions to request. Remove any permissions not needed. See available scopes for details.ADMIN_SHEETS ADMIN_SIGHTS ADMIN_USERS ADMIN_WEBHOOKS ADMIN_WORKSPACES CREATE_SHEETS CREATE_SIGHTS DELETE_SHEETS DELETE_SIGHTS READ_CONTACTS READ_EVENTS READ_SHEETS READ_SIGHTS READ_USERS SHARE_SHEETS SHARE_SIGHTS WRITE_SHEETS
App Client IDThe client ID generated when creating an app within Smartsheet's Developer Tools.
App SecretThe client secret generated when creating an app within Smartsheet's Developer Tools.

OAuth 2.0 (Deprecated)

Authenticate requests to Smartsheet using OAuth 2.0. Deprecated in favor of the templated OAuth 2.0 connection.

Deprecation Notice

This connection type is deprecated. Use the OAuth 2.0 connection instead, which provides a simplified configuration with templated URLs.

To authenticate with Smartsheet through OAuth 2.0, create and configure an app within the Smartsheet account.

Prerequisites

  • A Smartsheet account with access to Developer Tools
  • A developer profile created in Smartsheet

Setup Steps

  1. Log in to Smartsheet
  2. Navigate to the profile icon (bottom left) and select Developer Tools
  3. Create a developer profile if one does not already exist
  4. Click Create New App
  5. Configure the app:
    • App Name: Enter the application name
    • App Description: Add a brief description
    • App Logo: Optional
    • Publish App: Leave unchecked (not required)
    • App Redirect URL: Enter https://oauth2.integrations.acme.com/callback
  6. Save the app and note the generated credentials:
    • App Client ID
    • App Secret

Configure the Connection

Create a connection of type OAuth 2.0 (Deprecated) and configure the following fields:

  • Base URL: Select the Smartsheet API base URL. Most applications use the commercial endpoint. Government entities should select the government endpoint.
  • Authorization URL: Select the OAuth 2.0 authorization endpoint for Smartsheet.
  • Token URL: Select the OAuth 2.0 token exchange endpoint for Smartsheet.
  • Scopes: A space-separated list of permissions to request. Remove any permissions not needed. Refer to the available scopes documentation for details.
  • App Client ID: Enter the client ID generated from the Smartsheet app.
  • App Secret: Enter the client secret generated from the Smartsheet app.

This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.

InputCommentsDefault
Base URLMost applications use Smartsheet commercial. Government entities should select the government endpoint.https://api.smartsheet.com/2.0/
Authorization URLThe OAuth 2.0 authorization endpoint for Smartsheet.https://app.smartsheet.com/b/authorize
Token URLThe OAuth 2.0 token exchange endpoint for Smartsheet.https://api.smartsheet.com/2.0/token
ScopesA space-separated list of permissions to request. Remove any permissions not needed. See available scopes for details.ADMIN_SHEETS ADMIN_SIGHTS ADMIN_USERS ADMIN_WEBHOOKS ADMIN_WORKSPACES CREATE_SHEETS CREATE_SIGHTS DELETE_SHEETS DELETE_SIGHTS READ_CONTACTS READ_EVENTS READ_SHEETS READ_SIGHTS READ_USERS SHARE_SHEETS SHARE_SIGHTS WRITE_SHEETS
App Client IDThe client ID generated when creating an app within Smartsheet's Developer Tools.
App SecretThe client secret generated when creating an app within Smartsheet's Developer Tools.

Triggers

Webhook

Receive and validate webhook requests from Smartsheet for manually configured webhook subscriptions.

Actions

Add Column to Sheet

Adds a column to a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
TitleThe display name for the column header.
TypeThe data type for the column. Determines how cell values are displayed and validated.
FormulaThe formula for a column.
HiddenIndicates whether the column is hiddenfalse
Position IndexThe 0-based position where the column should be inserted in the sheet.0
DescriptionAdditional context or instructions displayed below the column header.
LockedIndicates whether the column is lockedfalse
OptionsA list of options for picklists
ValidationIndicates whether validation has been enabled for the columnfalse
WidthDisplay width of the column in pixels.

Add Comment

Adds a comment to a discussion.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Discussion IDThe unique identifier for the discussion.
TextThe text content of the comment.

Add/Update Row

Adds or updates a row on a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Row ID (Optional)An ID of a row to update. Omit to add a new row
Dynamic Columns ValuesList of columns and their values
Column ValuesA list of columns to be updated with the specified value
Row Position (for new rows)The position where new rows are added to the sheet.toBottom
Allow Partial SuccessWhen specified with a value of true, enables partial success for this bulk operationfalse
Override ValidationWhen true, allows cell values outside of the validation limits defined on the column.false

Copy Rows

Copies rows to another sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Source Sheet IDThe unique identifier of the sheet to copy or move rows from.
Row IDsThe IDs of the rows to move or copy from the source sheet
Destination Sheet IDThe unique identifier of the sheet to move or copy rows into.

Copy Sheet

Copies a sheet to a specified destination.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Destination IDThe ID of the destination container (when copying or moving a sheet or a folder).
Destination TypeThe type of container to copy or move the resource into.home
New NameThe display name to assign to the copied resource.

Create Discussion

Creates a discussion on a sheet or row.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Row ID (Optional)The unique identifier for the row. Leave empty to apply to the sheet level.
CommentThe text content to post as a new discussion comment.

Create Folder

Creates a new folder in a specified location.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Folder IDEnter the ID of a folder to create a subfolder in, or omit this value to create a top-level home folder.
Workspace ID (Optional)Create in this workspace. Optional.
Folder NameThe display name for the folder.

Create Sheet

Creates a new sheet with specified columns.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Folder IDCreate sheet in this folder. Omit to create a top-level sheet.
Workspace ID (Optional)The unique identifier for the workspace. Leave empty to use the default context.
Sheet NameThe display name for the new sheet.
ColumnsSee Smartsheet API documentation for additional information about column types.
[
{
"title": "Favorite",
"type": "CHECKBOX",
"symbol": "STAR"
},
{
"title": "Primary Column",
"primary": true,
"type": "TEXT_NUMBER"
}
]

Create Webhook

Creates and enables a webhook for a specified resource.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Callback URLThe URL that Smartsheet sends webhook notifications to. This is usually a reference to another flow's webhook URL.
Webhook NameA descriptive label to identify the webhook in the dashboard.
Sheet IDThe unique identifier for the sheet.
Allow Duplicates?By default this action checks if a webhook with this callback and sheet ID already exists. If it does, this action does not configure a new webhook. Toggle this to true to allow the creation of duplicate webhooks.false

Create Workspace

Creates a new workspace.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Workspace NameThe display name for the workspace.

Delete Column

Deletes a column from a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Column IDThe unique identifier for the column.

Delete Comment

Deletes a comment by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Comment IDThe unique identifier for the comment.

Delete Discussion

Deletes a discussion from a sheet or row.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Discussion IDThe unique identifier for the discussion.

Delete Folder

Deletes a folder by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Folder IDThe unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders.

Delete Instance Webhooks

Deletes all Smartsheet webhooks that point to a flow in this instance.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.

Delete Row

Deletes a row from a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Row IDThe unique identifier for the row.

Delete Sheet

Deletes a sheet by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.

Delete Webhook

Deletes a webhook by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Webhook IDThe unique identifier for the webhook.

Delete Workspace

Deletes a workspace by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Workspace IDThe unique identifier for the workspace.

Edit Comment

Edits a comment by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Comment IDThe unique identifier for the comment.
TextThe text content of the comment.

Get Column

Retrieves a column by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Column IDThe unique identifier for the column.

Get Comment

Retrieves a comment by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Comment IDThe unique identifier for the comment.

Get Contact

Retrieves a contact by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Contact IDThe unique identifier for the contact.

Get Discussion

Retrieves a discussion by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Discussion IDThe unique identifier for the discussion.

Get Folder

Retrieves a folder by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Folder IDThe unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders.

Get Group

Retrieves a group by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Group IDThe unique identifier for the group.

Get Report

Retrieves a report including one page of rows, attachments, discussions, and source sheets.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Report IDThe unique identifier for the report.
Pagination Page SizeThe maximum number of items to return per page.
Pagination PageThe 1-based page number to return.1

Get Row

Retrieves the contents of a row by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Row IDThe unique identifier for the row.

Get Sheet

Retrieves a sheet by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Pagination Page SizeThe maximum number of items to return per page.
Pagination PageThe 1-based page number to return.1

Get Sheet Attachment

Retrieves metadata for an attachment on a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Attachment IDThe unique identifier for the attachment.

Get Sheet Publish Status

Retrieves the publish status of a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.

Get Sheet Version

Retrieves the version number of a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.

Get User

Retrieves a user by their ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
User IDThe ID of a user to fetch. Enter 'me' to get currently logged in user

Get Webhook

Retrieves a webhook by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Webhook IDThe unique identifier for the webhook.

Get Workspace

Retrieves a workspace by its ID.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Workspace IDThe unique identifier for the workspace.
Load AllWhen true, includes nested folders and their contents in the response.false

List Attachments on Row

Lists attachments on a row of a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Row IDThe unique identifier for the row.
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false

List Attachments on Sheet

Lists all attachments on a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false

List Columns

Lists all columns on a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false

List Contacts

Lists all contacts for the authenticated user.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

List Discussion Attachments

Lists all attachments on a discussion.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Discussion IDThe unique identifier for the discussion.
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false

List Discussions

Lists discussions on a sheet or row.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Row ID (Optional)The unique identifier for the row. Leave empty to apply to the sheet level.
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false

List Events

Lists events occurring in the Smartsheet organization account.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
SinceThe starting timestamp for events to return. Format: ISO 8601 (e.g. 2010-01-01T00:00:00Z).2010-01-01T00:00:00Z
Stream PositionIndicates next set of events to return
Max CountThe maximum number of events to return as response to this call.

List Favorites

Lists all favorite items for the authenticated user.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

List Folders

Lists folders, subfolders, or workspace folders.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Folder IDEnter the ID of a folder to list subfolders, or omit this value to list top-level home folders.
Workspace ID (Optional)Create in this workspace. Optional.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

List Groups

Lists all groups in the organization.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Modified SinceWhen specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. Format: ISO 8601 (e.g. 2023-01-01T00:00:00Z).
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

List Home Contents

Lists all Home objects, including dashboards, folders, reports, sheets, templates, and workspaces.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.

List Public Templates

Lists publicly available templates.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

List Reports

Lists all reports accessible to the authenticated user.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Modified SinceWhen specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. Format: ISO 8601 (e.g. 2023-01-01T00:00:00Z).

List Sheets

Lists all sheets accessible to the authenticated user.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Modified SinceWhen specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. Format: ISO 8601 (e.g. 2023-01-01T00:00:00Z).
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

List Users

Lists all users in the organization.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
EmailThe email address to filter users by.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Modified SinceWhen specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. Format: ISO 8601 (e.g. 2023-01-01T00:00:00Z).
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

List User Templates

Lists user-created templates.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

List Webhooks

Lists all webhooks owned by the authenticated user.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Show AllBy default only webhooks whose callback URLs match a flow in the current instance are shown. Toggle this to 'true' to show all webhooks (even those for other apps and instances).false

List Workspaces

Lists all workspaces accessible to the authenticated user.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Fetch AllWhen true, automatically fetches all pages of results. When false, only the specified page is returned.false
Pagination PageThe 1-based page number to return.1
Pagination Page SizeThe maximum number of items to return per page.

Move Folder

Moves a folder to a specified destination.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Folder IDThe unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders.
Destination Folder IDThe unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders.

Move Rows

Moves rows to another sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Row IDsThe IDs of the rows to move or copy from the source sheet
Destination Sheet IDThe unique identifier of the sheet to move or copy rows into.

Move Sheet

Moves a sheet to a specified destination.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
Destination IDThe ID of the destination container (when copying or moving a sheet or a folder).
Destination TypeThe type of container to copy or move the resource into.home

Raw Request

Sends a raw HTTP request to the Smartsheet API.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
URLInput the path only (/reports), The base URL is already included (https://api.smartsheet.com/2.0). For example, to connect to https://api.smartsheet.com/2.0/reports, only /reports is entered in this field.
MethodThe HTTP method to use.
DataThe HTTP body payload to send to the URL.
Form DataThe Form Data to be sent as a multipart form upload.
File DataFile Data to be sent as a multipart form upload.
File Data File NamesFile names to apply to the file data inputs. Keys must match the file data keys above.
Query ParameterA list of query parameters to send with the request. This is the portion at the end of the URL similar to ?key1=value1&key2=value2.
HeaderA list of headers to send with the request.
Response TypeThe type of data you expect in the response. You can request json, text, or binary data.json
TimeoutThe maximum time that a client will await a response to its request
Debug RequestEnabling this flag will log out the current request.false
Retry Delay (ms)The delay in milliseconds between retries. This is used when 'Use Exponential Backoff' is disabled.0
Retry On All ErrorsIf true, retries on all erroneous responses regardless of type. This is helpful when retrying after HTTP 429 or other 3xx or 4xx errors. Otherwise, only retries on HTTP 5xx and network errors.false
Max Retry CountThe maximum number of retries to attempt. Specify 0 for no retries.0
Use Exponential BackoffSpecifies whether to use a pre-defined exponential backoff strategy for retries. When enabled, 'Retry Delay (ms)' is ignored.false

Search Sheets

Searches sheets for a specified phrase.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet ID (Optional)The ID of the sheet to search. Omit to search all sheets.
Search QueryThe text to search for across sheets, rows, and cells.

Send Sheet

Sends a sheet via email to specified recipients.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
FormatThe file format to use when sending the sheet.EXCEL
Paper SizeThe paper size to use when generating the PDF.LETTER
EmailsThe email addresses of recipients to send the document to.
Group IDsThe group IDs of recipients to send the document to.
CC MeIndicates whether to send a copy of the email to the senderfalse
MessageThe message of the email.
SubjectThe subject line of the email.

Set Sheet Publish Status

Sets the publish status of a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
iCal EnabledIf true, a webcal is available for the calendar in the sheetfalse
Read Only Full Accessible ByIndicates who can access the 'Read-Only Full' view of the published sheet:ALL
Read Only Full Default ViewIndicates which view the user has set for a read-only, default view of the published sheetCALENDAR
Read Only Full EnabledIf true, a rich version of the sheet is published with the ability to download row attachments and discussionstrue
Read Only Lite EnabledIf true, a lightweight version of the sheet is published without row attachments and discussionsfalse
Read Write Accessible ByIndicates who can access the 'Edit by Anyone' view of the published sheet:ALL
Read Write Default ViewIndicates which view the user has set for a read-write, default view of the published sheetCALENDAR
Read Write EnabledIf true,a rich version of the sheet is published with the ability to edit cells and manage attachments and discussionstrue

Update Folder

Updates the name of a folder.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Folder IDThe unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders.
Folder NameThe display name for the folder.

Update Sheet

Updates the properties of a sheet.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Sheet IDThe unique identifier for the sheet.
New NameThe updated display name for the sheet.

Update Workspace

Updates the properties of a workspace.

InputCommentsDefault
ConnectionThe Smartsheet connection to use.
Workspace IDThe unique identifier for the workspace.
NameThe updated display name for the workspace.