About this integration
Work management for sheets, rows, workspaces, reports, and users.
There are 5 triggers, 26 search modules and 45 actions available. The integration connects via basic or oauth authentication. Webhook-based triggers fire instantly without polling.
How to connect
The credential form asks for API Base URL, API Key, API Base URL, and Client ID.
OAuth asks you to approve ADMIN_SHEETS, ADMIN_SIGHTS, and ADMIN_USERS before access is granted.
Enter your credentials below. WEXTL stores them encrypted and uses them only to call the API on your behalf.
| Field | Type | Help |
|---|---|---|
API Base URLRequired | select | Select the base URL for the API. |
API KeyRequired | password | Log into Smartsheet → Account Settings → API Access → Generate API Access Token. |
You’ll be redirected to sign in and approve access — your password is never shared with WEXTL.
| Field | Type | Help |
|---|---|---|
API Base URLRequired | select | Select the base URL for the API. |
Client IDRequired | text | Go to the Developer Portal → OAuth → create an OAuth app to obtain your Client ID and Client Secret |
Client SecretRequired | password | Go to the Developer Portal → OAuth → create an OAuth app to obtain your Client ID and Client Secret |
- 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
Use it in workflow automation
Start with Watch Attachments, then add Add a Column.
Triggers, searches and actions
Open any Smartsheet trigger, search, or action to see its inputs and outputs — 5 triggers, 26 searchs, 45 actions.
Triggers
Use one of 5 triggers to kick off a workflow as soon as an event occurs in the app.
- Watch Attachments
- Watch Discussions
- Watch Events
- Watch Groups
- Watch Sheets
Searches
This integration includes 26 search modules for looking data up mid-run.
- Get a Column
- Get a Contact
- Get a Discussion
- Get a Group
- Get an Alternate Email
Actions
Take action during a run with 45 available modules that write data back into the app.
- Add a Column
- Add an Alternate Email
- Add a Row
- Add Sheet Attachment
- Attach New Sheet Attachment
Explore the fields available for each Smartsheet trigger, search, and action.
Triggers
| Field | Type |
|---|---|
ID | number |
Parent ID | number |
Attachment type | text |
Attachment sub type | text |
Mime type | text |
Parent type | text |
Created at | date |
Created by | object |
ID | text |
Name | text |
Email | |
Name | text |
Size in kb | number |
URL | url |
URL expires in millis | number |
| Field | Type |
|---|---|
Access level | text |
ID | number |
Comments | array |
Comment attachments | array |
Comment count | number |
Created by | object |
Email | text |
Name | text |
Last commented at | date |
Last commented user | object |
Email | text |
Name | text |
Parent ID | number |
Parent type | text |
Read only | boolean |
Title | text |
| Field | Type |
|---|---|
Webhook NameRequired | text |
EventsRequired | choice |
ScopeRequired | text |
Scope Object IDRequired | number |
| Field | Type |
|---|---|
ID | number |
Name | text |
Description | text |
Owner | text |
Owner ID | number |
Created at | date |
Modified at | date |
| Field | Type |
|---|---|
ID | number |
Access level | text |
Created at | date |
Modified at | date |
Name | text |
Permalink | url |
Version | number |
Source | object |
ID | number |
Type | text |
Searches
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Level | choice |
| Field | Type |
|---|---|
Description | text |
Format | text |
Hidden | boolean |
ID | number |
Index | number |
Locked | boolean |
Locked for user | boolean |
Title | text |
Width | number |
Formula | text |
Primary | boolean |
Tags | array |
Type | text |
Validation | boolean |
Version | number |
| Field | Type |
|---|---|
Contact IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Confirmed | boolean |
Email |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Access level | text |
ID | number |
Comments | array |
Comment attachments | array |
Comment count | number |
Created by | object |
Email | text |
Name | text |
Last commented at | text |
Last commented user | object |
Email | text |
Name | text |
Parent ID | number |
Parent type | text |
Read only | boolean |
Title | text |
| Field | Type |
|---|---|
Group IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Name | text |
Description | text |
Owner | text |
Owner ID | number |
Created at | date |
Modified at | date |
Members | array |
| Field | Type |
|---|---|
User IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Confirmed | boolean |
Email |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Parent ID | number |
Attachment type | text |
Attachment sub type | text |
Mime type | text |
Parent type | text |
Created at | date |
Created by | object |
Email | |
Name | text |
Name | text |
Size in kb | number |
URL | url |
URL expires in millis | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Action | text |
Created at | date |
Created by | object |
Email | |
Name | text |
Disabled reason | text |
Disabled reason text | text |
Enabled | boolean |
Modified at | date |
Modified by | object |
Email | text |
Name | text |
Name | text |
User can modify | boolean |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Include | choice |
| Field | Type |
|---|---|
ID | number |
Original ID | number |
Name | text |
Type | text |
Document type | text |
Proof request URL | url |
Version | number |
Last updated at | date |
Last updated by | object |
Email | |
Name | text |
Is completed | boolean |
Attachments | array |
Discussions | array |
| Field | Type |
|---|---|
Report IDRequired | choice |
Access API Level | choice |
Include | choice |
Exclude | choice |
| Field | Type |
|---|---|
ID | number |
Name | text |
Access level | text |
Permalink | url |
Is summary report | boolean |
Columns | array |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Row number | number |
Parent row number | number |
Parent ID | number |
Expanded | boolean |
Created at | date |
Modified at | date |
Cells | array |
Version | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
From ID | number |
Owner ID | number |
Access level | text |
Attachments | array |
Cell image upload enabled | boolean |
Columns | array |
Created at | date |
Cross sheet references | array |
Dependencies enabled | boolean |
Discussions | array |
Effective attachment options | array |
Favorite | boolean |
Gantt enabled | boolean |
Has summary fields | boolean |
Is multi picklist enabled | boolean |
| Field | Type |
|---|---|
User IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Admin | boolean |
Custom welcome screen viewed | date |
Email | |
First name | text |
Group admin | boolean |
Is internal | boolean |
Last login | date |
Last name | text |
Licensed sheet creator | boolean |
Name | text |
Profile image | object |
Image ID | text |
Height | number |
Width | number |
Provisional expiration date | date |
Resource viewer | boolean |
Seat type | text |
Seat type last changed at | date |
| Field | Type |
|---|---|
Workspace IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Name | text |
Permalink | text |
Created at | date |
Modified at | date |
Access level | text |
| Field | Type |
|---|---|
ID | number |
Admin | boolean |
Custom welcome screen viewed | date |
Email | |
First name | text |
Group admin | boolean |
Is internal | boolean |
Last login | date |
Last name | text |
Licensed sheet creator | boolean |
Name | text |
Profile image | object |
Image ID | text |
Height | number |
Width | number |
Provisional expiration date | date |
Resource viewer | boolean |
Seat type | text |
Seat type last changed at | date |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Limit | number |
| Field | Type |
|---|---|
ID | number |
Parent ID | number |
Attachment type | text |
Attachment sub type | text |
Mime type | text |
Parent type | text |
Created at | date |
Created by | object |
ID | text |
Name | text |
Email | |
Name | text |
Size in kb | number |
URL | url |
URL expires in millis | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Limit | number |
| Field | Type |
|---|---|
ID | number |
Action | text |
Created at | date |
Created by | object |
Email | |
Name | text |
Disabled reason | text |
Disabled reason text | text |
Enabled | boolean |
Modified at | date |
Modified by | object |
Email | text |
Name | text |
Name | text |
User can modify | boolean |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Level | choice |
Limit | number |
| Field | Type |
|---|---|
Description | text |
Format | text |
Hidden | boolean |
ID | number |
Index | number |
Locked | boolean |
Locked for user | boolean |
Title | text |
Width | number |
Formula | text |
Primary | boolean |
Tags | array |
Type | text |
Validation | boolean |
Version | number |
| Field | Type |
|---|---|
Limit | number |
| Field | Type |
|---|---|
ID | text |
Name | text |
Email |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Include | choice |
Limit | number |
| Field | Type |
|---|---|
Access level | text |
ID | number |
Comments | array |
Comment attachments | array |
Comment count | number |
Created by | object |
Email | text |
Name | text |
Last commented at | date |
Last commented user | object |
Email | text |
Name | text |
Parent ID | number |
Parent type | text |
Read only | boolean |
Title | text |
| Field | Type |
|---|---|
Modified Since | date |
Limit | number |
| Field | Type |
|---|---|
ID | number |
Name | text |
Description | text |
Owner | text |
Owner ID | number |
Created at | date |
Modified at | date |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Limit | number |
| Field | Type |
|---|---|
ID | number |
Original ID | number |
Name | text |
Type | text |
Document type | text |
Proof request URL | url |
Version | number |
Last updated at | date |
Last updated by | object |
Email | text |
Name | text |
Is completed | boolean |
Attachments | array |
Discussions | array |
| Field | Type |
|---|---|
Limit | number |
| Field | Type |
|---|---|
ID | number |
Name | text |
Access level | text |
Permalink | url |
Is summary report | boolean |
| Field | Type |
|---|---|
Modified Since | date |
Limit | number |
| Field | Type |
|---|---|
ID | number |
Access level | text |
Created at | date |
Modified at | date |
Name | text |
Permalink | url |
Version | number |
Source | object |
ID | number |
Type | text |
| Field | Type |
|---|---|
User IDRequired | choice |
Limit | number |
| Field | Type |
|---|---|
ID | number |
Confirmed | boolean |
Email |
| Field | Type |
|---|---|
EmailRequired | |
Include | choice |
Limit | number |
| Field | Type |
|---|---|
ID | number |
Admin | boolean |
Custom welcome screen viewed | date |
Email | |
First name | text |
Group admin | boolean |
Is internal | boolean |
Last login | date |
Last name | text |
Licensed sheet creator | boolean |
Name | text |
Profile image | object |
Image ID | text |
Height | number |
Width | number |
Provisional expiration date | text |
Resource viewer | boolean |
Seat type | text |
Seat type last changed at | date |
| Field | Type |
|---|---|
Limit | number |
| Field | Type |
|---|---|
ID | number |
Name | text |
Access level | text |
Permalink | url |
Actions
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Column | object |
IndexRequired | number |
TitleRequired | text |
TypeRequired | choice |
Description | text |
Format | text |
Hidden | boolean |
Locked | boolean |
Width | number |
System Column Type | text |
Auto Number Format | object |
| Field | Type |
|---|---|
Description | text |
Format | text |
Hidden | boolean |
ID | number |
Index | number |
Locked | boolean |
Locked for user | boolean |
Title | text |
Width | number |
Formula | text |
Primary | boolean |
Tags | array |
Type | text |
Validation | boolean |
Version | number |
| Field | Type |
|---|---|
User IDRequired | choice |
EmailRequired |
| Field | Type |
|---|---|
Message | text |
Result code | number |
Data | array |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Rows | array |
| Field | Type |
|---|---|
ID | number |
Row number | number |
Parent row number | number |
Parent ID | number |
Expanded | boolean |
Created at | date |
Modified at | date |
Cells | array |
Version | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
NameRequired | text |
URLRequired | url |
Attachment TypeRequired | choice |
Attachment Sub Type | choice |
Description | text |
| Field | Type |
|---|---|
ID | number |
Parent ID | number |
Attachment type | text |
Attachment sub type | text |
Mime type | text |
Parent type | text |
Created at | date |
Created by | object |
ID | text |
Name | text |
Name | text |
Size in kb | number |
URL | url |
URL expires in millis | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
NameRequired | text |
URLRequired | url |
Attachment TypeRequired | choice |
Attachment Sub Type | choice |
Description | text |
| Field | Type |
|---|---|
ID | number |
Parent ID | number |
Attachment type | text |
Attachment sub type | text |
Mime type | text |
Parent type | text |
Created at | date |
Created by | object |
ID | text |
Name | text |
Name | text |
Size in kb | number |
URL | url |
URL expires in millis | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Destination TypeRequired | choice |
Destination IDRequired | number |
New Sheet Name | text |
Include | array |
| Field | Type |
|---|---|
ID | number |
Access level | text |
Name | text |
Permalink | url |
| Field | Type |
|---|---|
Workspace IDRequired | choice |
Workspace New NameRequired | text |
| Field | Type |
|---|---|
ID | number |
Name | text |
Access level | text |
Permalink | url |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Row IDsRequired | array |
Row ID | number |
DestinationRequired | object |
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Destination sheet ID | number |
Row mappings | array |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
CommentRequired | object |
TextRequired | text |
File | text |
| Field | Type |
|---|---|
Access level | text |
ID | number |
Comments | array |
Comment attachments | array |
Comment count | number |
Created by | object |
Email | text |
Name | text |
Last commented at | text |
Last commented user | object |
Email | text |
Name | text |
Parent ID | number |
Parent type | text |
Read only | boolean |
Title | text |
| Field | Type |
|---|---|
NameRequired | text |
Description | text |
Members | array |
| Field | Type |
|---|---|
ID | number |
Name | text |
Description | text |
Owner | text |
Owner ID | number |
Created at | date |
Modified at | date |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
File | text |
| Field | Type |
|---|---|
ID | number |
Original ID | number |
Name | text |
Type | text |
Document type | text |
Proof request URL | url |
Version | number |
Last updated at | date |
Last updated by | object |
Email | text |
Name | text |
Is completed | boolean |
Attachments | array |
Discussions | array |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Is Downloadable | boolean |
CC Me | boolean |
Message | text |
Send To | array |
Subject | text |
| Field | Type |
|---|---|
ID | number |
Proof ID | number |
Sent by | object |
Email | |
Name | text |
Sent at | date |
Is downloadable | boolean |
Status | text |
Cc me | boolean |
Message | text |
Send to | array |
Subject | text |
| Field | Type |
|---|---|
Report NameRequired | text |
DestinationRequired | object |
Destination IDRequired | number |
Destination TypeRequired | choice |
ColumnsRequired | array |
ScopeRequired | array |
Report Definition | object |
Filters | object |
Grouping Criteria | array |
Summarizing Criteria | array |
Sorting Criteria | array |
Is Summary Report | boolean |
| Field | Type |
|---|---|
ID | number |
Name | text |
Access level | text |
Permalink | url |
Is summary report | boolean |
Columns | array |
| Field | Type |
|---|---|
Folder IDRequired | text |
Sheet NameRequired | text |
Columns | array |
Template ID | text |
| Field | Type |
|---|---|
Access level | text |
Columns | array |
ID | number |
Name | text |
Permalink | url |
| Field | Type |
|---|---|
Workspace IDRequired | choice |
Sheet NameRequired | text |
Columns | array |
Template ID | number |
| Field | Type |
|---|---|
Access level | text |
Columns | array |
ID | number |
Name | text |
Permalink | url |
| Field | Type |
|---|---|
EmailRequired | |
First NameRequired | text |
Last NameRequired | text |
StatusRequired | choice |
Send EmailRequired | boolean |
Admin | boolean |
Group Admin | boolean |
Licensed Sheet Creator | boolean |
Resource Viewer | boolean |
Profile Image | object |
Image ID | text |
Height | number |
Width | number |
| Field | Type |
|---|---|
ID | number |
Admin | boolean |
Custom welcome screen viewed | date |
Email | |
First name | text |
Group admin | boolean |
Is internal | boolean |
Last login | date |
Last name | text |
Licensed sheet creator | boolean |
Name | text |
Profile image | object |
Image ID | text |
Height | number |
Width | number |
Provisional expiration date | date |
Resource viewer | boolean |
Seat type | text |
Seat type last changed at | date |
| Field | Type |
|---|---|
Workspace NameRequired | text |
| Field | Type |
|---|---|
ID | number |
Name | text |
Access level | text |
Permalink | url |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Group IDRequired | choice |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
User IDRequired | choice |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Report IDRequired | choice |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Workspace IDRequired | choice |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
FormatRequired | choice |
Paper Size | choice |
| Field | Type |
|---|---|
File Data | text |
| Field | Type |
|---|---|
User IDRequired | choice |
| Field | Type |
|---|---|
URLRequired | text |
MethodRequired | choice |
Headers | array |
Header | object |
Query String | array |
Parameter | object |
Body | text |
| Field | Type |
|---|---|
Body | text |
Headers | object |
Status code | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Destination TypeRequired | choice |
Destination IDRequired | number |
| Field | Type |
|---|---|
ID | number |
Access level | text |
Name | text |
Permalink | url |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Row IDsRequired | array |
Row ID | number |
DestinationRequired | object |
Sheet IDRequired | choice |
| Field | Type |
|---|---|
Destination sheet ID | number |
Row mappings | array |
| Field | Type |
|---|---|
User IDRequired | choice |
Transfer To User IDRequired | text |
Remove From SharingRequired | boolean |
| Field | Type |
|---|---|
Report IDRequired | choice |
FormatRequired | choice |
Format Details | object |
CC Me | boolean |
Message | text |
Send To | array |
Subject | text |
| Field | Type |
|---|---|
Version | number |
Failed items | array |
Message | text |
Result code | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Send ToRequired | array |
Subject | text |
Message | text |
CC Me | boolean |
Format | choice |
Format Details | object |
Paper Size | choice |
| Field | Type |
|---|---|
Message | text |
Result code | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Send ToRequired | array |
SubjectRequired | text |
MessageRequired | text |
Row IDsRequired | array |
Row ID | number |
CC Me | boolean |
Column IDs | array |
Column ID | number |
Include Attachments | boolean |
Include Discussions | boolean |
| Field | Type |
|---|---|
Message | text |
Result code | number |
| Field | Type |
|---|---|
Group IDRequired | choice |
Name | text |
Description | text |
Members | array |
| Field | Type |
|---|---|
ID | number |
Name | text |
Description | text |
Owner | text |
Owner ID | number |
Created at | date |
Modified at | date |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Action | object |
TypeRequired | choice |
Notify All Shared Users | boolean |
Included Column IDs | array |
Frequency | choice |
Include All Columns | boolean |
Include Attachments | boolean |
Include Discussions | boolean |
Message | text |
Subject | text |
Created By | object |
Email | |
Disabled Reason | choice |
Disabled Reason Text | text |
Enabled | boolean |
Modified By | object |
Email | |
Name | text |
User Can Modify | boolean |
| Field | Type |
|---|---|
ID | number |
Action | text |
Created at | date |
Created by | object |
Email | |
Name | text |
Disabled reason | text |
Disabled reason text | text |
Enabled | boolean |
Modified at | date |
Modified by | object |
Email | text |
Name | text |
Name | text |
User can modify | boolean |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
Is CompletedRequired | boolean |
| Field | Type |
|---|---|
ID | number |
Original ID | number |
Name | text |
Type | text |
Document type | text |
Proof request URL | url |
Version | number |
Last updated at | date |
Last updated by | object |
Email | |
Name | text |
Is completed | boolean |
Attachments | array |
Discussions | array |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
| Field | Type |
|---|---|
ID | number |
Row number | number |
Parent row number | number |
Parent ID | number |
Expanded | boolean |
Created at | date |
Modified at | date |
Cells | array |
Version | number |
| Field | Type |
|---|---|
Sheet IDRequired | choice |
New Sheet Name | text |
User Settings | object |
Critical Path EnabledRequired | boolean |
Project Settings | object |
Working DaysRequired | array |
Non-Working Days | array |
Length of DayRequired | number |
| Field | Type |
|---|---|
ID | number |
From ID | number |
Owner ID | number |
Access level | text |
Attachments | array |
Cell image upload enabled | boolean |
Columns | array |
Created at | date |
Cross sheet references | array |
Dependencies enabled | boolean |
Discussions | array |
Effective attachment options | array |
Favorite | boolean |
Gantt enabled | boolean |
Has summary fields | boolean |
Is multi picklist enabled | boolean |
| Field | Type |
|---|---|
User IDRequired | choice |
Email | |
First Name | text |
Last Name | text |
Status | choice |
Admin | boolean |
Group Admin | boolean |
Licensed Sheet Creator | boolean |
Resource Viewer | boolean |
Profile Image | object |
Image ID | text |
Height | number |
Width | number |
| Field | Type |
|---|---|
ID | number |
Admin | boolean |
Custom welcome screen viewed | date |
Email | |
First name | text |
Group admin | boolean |
Is internal | boolean |
Last login | date |
Last name | text |
Licensed sheet creator | boolean |
Name | text |
Profile image | object |
Image ID | text |
Height | number |
Width | number |
Provisional expiration date | date |
Resource viewer | boolean |
Seat type | text |
Seat type last changed at | date |
| Field | Type |
|---|---|
Workspace IDRequired | choice |
Workspace NameRequired | text |
| Field | Type |
|---|---|
ID | number |
Name | text |
Access level | text |
Permalink | url |