Smartsheet integration | Zervanor
← All connectors

Smartsheet

Also an agent tool
productivity

Smartsheet API 2.0: Sheets (list/get/create/create-from-template/copy/update/delete, get as PDF/Excel/CSV, get version, send, move, get/set publish), Rows (add/update/delete/get/copy/move/send), Columns (list/get/add/update/delete), Cells (history, add image), Attachments (list/get/attach file+URL/delete), Discussions (list/get/create/delete) + Comments (get/add/edit/delete), Reports (list/get/PDF/Excel/send), Dashboards/Sights (list/get/copy/update/delete/share), Workspaces (list/get/create/update/delete/copy/shares/share), Folders (get/create/update/delete/list), Home (list contents), Templates (public/user), Users (list/get/me/add/update/remove/list sheets), Groups (list/get/create/update/delete/members), Webhooks (list/get/create/update/delete/reset shared secret), Automation Rules (list/get/update/delete), Contacts (list/get), Favorites (list/add/delete), Search (all/sheet), Server Info, Events (audit stream), and Update Requests. Base URL is static https://api.smartsheet.com/2.0. Auth is a Bearer access token (Authorization: Bearer <access_token>). List Sheets is the polling trigger: page/pageSize offset pagination over the {pageNumber,totalPages,data} envelope. Smartsheet signs webhook callbacks as HMAC-SHA256 (hex) over the raw request body using the webhook shared secret, in the Smartsheet-Hmac-SHA256 header — this matches the generic_hmac handler (sha256/hex/raw_body), so change events are delivered as webhook triggers; webhook CRUD is also exposed as actions.

107 actions · 15 triggers

The Smartsheet integration lets you connect Smartsheet to your automations with 107 actions and 15 triggers — and every action is also a tool an AI agent can call. Examples: Get Current User, List Sheets, Get Sheet, Create Sheet, Create Sheet From Template. No blank-canvas wiring — connect it and use it in your workflows.

Every action below is also a tool an AI agent can call — the same pack powers your workflows and your agents.

Triggers 15

Events in Smartsheet that can start a workflow.

webhook

Sheet Created

Fires when a sheet is created within the webhook's scope (Smartsheet event eventType=created, objectType=sheet).

webhook

Sheet Updated

Fires when a sheet is updated (eventType=updated, objectType=sheet).

webhook

Sheet Deleted

Fires when a sheet is deleted (eventType=deleted, objectType=sheet).

webhook

Row Created

Fires when a row is created on a watched sheet (eventType=created, objectType=row).

webhook

Row Updated

Fires when a row is updated on a watched sheet (eventType=updated, objectType=row).

webhook

Row Deleted

Fires when a row is deleted on a watched sheet (eventType=deleted, objectType=row).

webhook

Column Created

Fires when a column is created on a watched sheet (eventType=created, objectType=column).

webhook

Column Updated

Fires when a column is updated on a watched sheet (eventType=updated, objectType=column).

webhook

Column Deleted

Fires when a column is deleted on a watched sheet (eventType=deleted, objectType=column).

webhook

Cell Updated

Fires when a cell value changes on a watched sheet (eventType=updated, objectType=cell).

webhook

Attachment Created

Fires when an attachment is added on a watched sheet (eventType=created, objectType=attachment).

webhook

Attachment Deleted

Fires when an attachment is removed on a watched sheet (eventType=deleted, objectType=attachment).

webhook

Discussion Created

Fires when a discussion is created on a watched sheet (eventType=created, objectType=discussion).

webhook

Discussion Deleted

Fires when a discussion is deleted on a watched sheet (eventType=deleted, objectType=discussion).

polling

New or updated Smartsheet sheets (polled)

Polls GET /sheets with a modifiedSince watermark on a schedule; results are the data[] array of the {pageNumber,totalPages,data} envelope, paged via page / pageSize.

Actions 107

What Zervanor can do in Smartsheet.

Sheets50

GET

List Sheets

List all sheets the user has access to (GET /sheets). Offset pagination (page/pageSize) over the {pageNumber,totalPages,totalCount,data} envelope. Used as the polling trigger.

GET

Get Sheet

Get a sheet by id, including its rows, columns, and cells (GET /sheets/{sheetId}).

POST

Create Sheet

Create a new sheet from scratch in the user's Sheets folder (POST /sheets). Requires a name and columns[].

POST

Create Sheet From Template

Create a sheet from an existing template (POST /sheets with fromId).

POST

Copy Sheet

Create a copy of a sheet in the specified destination (POST /sheets/{sheetId}/copy).

PUT

Update Sheet

Update a sheet's name or user settings (PUT /sheets/{sheetId}).

DELETE

Delete Sheet

Delete a sheet (DELETE /sheets/{sheetId}). The sheet is moved to Deleted Items.

POST

Move Sheet

Move a sheet to a different folder or workspace (POST /sheets/{sheetId}/move).

GET

Get Sheet As PDF

Download a sheet as a PDF (GET /sheets/{sheetId} with Accept: application/pdf).

GET

Get Sheet As Excel

Download a sheet as an Excel file (GET /sheets/{sheetId} with Accept: application/vnd.ms-excel).

GET

Get Sheet As CSV

Download a sheet as a CSV file (GET /sheets/{sheetId} with Accept: text/csv).

GET

Get Sheet Version

Get the current version number of a sheet (GET /sheets/{sheetId}/version).

POST

Send Sheet

Send a sheet as an attachment via email (POST /sheets/{sheetId}/emails).

GET

Get Sheet Publish Status

Get a sheet's publish settings (GET /sheets/{sheetId}/publish).

PUT

Set Sheet Publish Status

Set a sheet's publish settings (PUT /sheets/{sheetId}/publish).

GET

Get Row

Get a single row from a sheet (GET /sheets/{sheetId}/rows/{rowId}).

POST

Add Rows

Add one or more rows to a sheet (POST /sheets/{sheetId}/rows). Body is a single row object or an array of rows.

PUT

Update Rows

Update one or more rows in a sheet (PUT /sheets/{sheetId}/rows). Each row must include its id.

DELETE

Delete Rows

Delete one or more rows from a sheet (DELETE /sheets/{sheetId}/rows?ids=...).

POST

Copy Rows

Copy rows from one sheet to another (POST /sheets/{sheetId}/rows/copy).

POST

Move Rows

Move rows from one sheet to another (POST /sheets/{sheetId}/rows/move).

POST

Send Rows

Send one or more rows via email (POST /sheets/{sheetId}/rows/emails).

GET

List Columns

List the columns of a sheet (GET /sheets/{sheetId}/columns). Offset pagination.

GET

Get Column

Get a single column of a sheet (GET /sheets/{sheetId}/columns/{columnId}).

POST

Add Columns

Add one or more columns to a sheet (POST /sheets/{sheetId}/columns).

PUT

Update Column

Update a column's properties (PUT /sheets/{sheetId}/columns/{columnId}).

DELETE

Delete Column

Delete a column from a sheet (DELETE /sheets/{sheetId}/columns/{columnId}).

GET

Get Cell History

Get the modification history of a cell (GET /sheets/{sheetId}/rows/{rowId}/columns/{columnId}/history).

POST

Add Image To Cell

Upload and set an image on a cell (POST /sheets/{sheetId}/rows/{rowId}/columns/{columnId}/cellimages). Uses multipart/form-data.

GET

List Sheet Attachments

List the attachments on a sheet (GET /sheets/{sheetId}/attachments). Offset pagination.

GET

Get Attachment

Get an attachment, including a temporary download URL (GET /sheets/{sheetId}/attachments/{attachmentId}).

POST

Attach File To Sheet

Upload and attach a file to a sheet (POST /sheets/{sheetId}/attachments). Uses multipart/form-data.

POST

Attach URL To Sheet

Attach a URL (link, or Google/Box/Dropbox/OneDrive file) to a sheet (POST /sheets/{sheetId}/attachments).

DELETE

Delete Attachment

Delete an attachment from a sheet (DELETE /sheets/{sheetId}/attachments/{attachmentId}).

GET

List Discussions

List the discussions on a sheet (GET /sheets/{sheetId}/discussions). Offset pagination.

GET

Get Discussion

Get a single discussion (GET /sheets/{sheetId}/discussions/{discussionId}).

POST

Create Discussion On Sheet

Create a discussion on a sheet (POST /sheets/{sheetId}/discussions). Requires an initial comment.

POST

Create Discussion On Row

Create a discussion on a specific row (POST /sheets/{sheetId}/rows/{rowId}/discussions).

DELETE

Delete Discussion

Delete a discussion from a sheet (DELETE /sheets/{sheetId}/discussions/{discussionId}).

GET

Get Comment

Get a single comment (GET /sheets/{sheetId}/comments/{commentId}).

POST

Add Comment To Discussion

Add a comment to an existing discussion (POST /sheets/{sheetId}/discussions/{discussionId}/comments).

PUT

Edit Comment

Edit the text of a comment (PUT /sheets/{sheetId}/comments/{commentId}).

DELETE

Delete Comment

Delete a comment (DELETE /sheets/{sheetId}/comments/{commentId}).

GET

List Automation Rules

List the automation rules on a sheet (GET /sheets/{sheetId}/automationrules).

GET

Get Automation Rule

Get a single automation rule on a sheet (GET /sheets/{sheetId}/automationrules/{automationRuleId}).

PUT

Update Automation Rule

Update an automation rule, most commonly to enable/disable it (PUT /sheets/{sheetId}/automationrules/{automationRuleId}).

DELETE

Delete Automation Rule

Delete an automation rule from a sheet (DELETE /sheets/{sheetId}/automationrules/{automationRuleId}).

GET

List Update Requests

List the update requests on a sheet (GET /sheets/{sheetId}/updaterequests).

POST

Create Update Request

Create an update request that asks recipients to update specified rows (POST /sheets/{sheetId}/updaterequests).

GET

List Sent Update Requests

List the sent update requests on a sheet (GET /sheets/{sheetId}/sentupdaterequests).

Workspaces8

GET

List Workspaces

List all workspaces the user has access to (GET /workspaces). Offset pagination.

GET

Get Workspace

Get a workspace by id, including its sheets, folders, reports, and dashboards (GET /workspaces/{workspaceId}).

POST

Create Workspace

Create a new workspace (POST /workspaces).

PUT

Update Workspace

Update a workspace's name (PUT /workspaces/{workspaceId}).

DELETE

Delete Workspace

Delete a workspace and all of its contents (DELETE /workspaces/{workspaceId}).

POST

Copy Workspace

Create a copy of a workspace (POST /workspaces/{workspaceId}/copy).

GET

List Workspace Shares

List the shares of a workspace (GET /workspaces/{workspaceId}/shares).

POST

Share Workspace

Share a workspace with users or groups (POST /workspaces/{workspaceId}/shares).

Groups7

GET

List Groups

List the groups in the organization (GET /groups). Requires group admin.

GET

Get Group

Get a group by id, including its members (GET /groups/{groupId}).

POST

Create Group

Create a group (POST /groups). Requires group admin.

PUT

Update Group

Update a group's name, description, or owner (PUT /groups/{groupId}).

DELETE

Delete Group

Delete a group (DELETE /groups/{groupId}).

POST

Add Group Members

Add one or more members to a group (POST /groups/{groupId}/members).

DELETE

Remove Group Member

Remove a member from a group (DELETE /groups/{groupId}/members/{userId}).

Sights7

GET

List Dashboards

List all dashboards (Sights) the user has access to (GET /sights). Offset pagination.

GET

Get Dashboard

Get a dashboard (Sight) by id, including its widgets (GET /sights/{sightId}).

POST

Copy Dashboard

Create a copy of a dashboard (POST /sights/{sightId}/copy).

PUT

Update Dashboard

Update a dashboard's name or settings (PUT /sights/{sightId}).

DELETE

Delete Dashboard

Delete a dashboard (DELETE /sights/{sightId}).

GET

List Dashboard Shares

List the shares of a dashboard (GET /sights/{sightId}/shares).

POST

Share Dashboard

Share a dashboard with users or groups (POST /sights/{sightId}/shares).

Users7

GET

Get Current User

Get the currently authenticated user (GET /users/me). Identity + connectivity probe.

GET

List Users

List the users in the organization (GET /users). Requires admin. Offset pagination.

GET

Get User

Get a user by id (GET /users/{userId}).

POST

Add User

Add a user to the organization (POST /users). Requires admin.

PUT

Update User

Update a user's properties (PUT /users/{userId}). Requires admin.

DELETE

Remove User

Remove a user from the organization (DELETE /users/{userId}). Requires admin.

GET

List User Sheets

List the sheets owned by or shared to a user (GET /users/{userId}/sheets). Requires admin.

Webhooks6

GET

List Webhooks

List the webhooks owned by the access token (GET /webhooks). Offset pagination.

GET

Get Webhook

Get a webhook by id (GET /webhooks/{webhookId}).

POST

Create Webhook

Create a webhook (POST /webhooks). Provide a callback URL, scope (sheet), scopeObjectId, and events. Smartsheet returns a sharedSecret used to sign callbacks.

PUT

Update Webhook

Update a webhook — most importantly to enable/disable it (PUT /webhooks/{webhookId}). Setting enabled: true triggers the verification callback.

DELETE

Delete Webhook

Delete a webhook (DELETE /webhooks/{webhookId}).

POST

Reset Webhook Shared Secret

Reset a webhook's shared secret (POST /webhooks/{webhookId}/resetsharedsecret). Returns a new sharedSecret.

Folders5

GET

Get Folder

Get a folder by id, including its contents (GET /folders/{folderId}).

GET

List Folders In Folder

List the child folders of a folder (GET /folders/{folderId}/folders).

POST

Create Folder

Create a folder inside another folder (POST /folders/{folderId}/folders).

PUT

Update Folder

Update a folder's name (PUT /folders/{folderId}).

DELETE

Delete Folder

Delete a folder and all of its contents (DELETE /folders/{folderId}).

Reports5

GET

List Reports

List all reports the user has access to (GET /reports). Offset pagination.

GET

Get Report

Get a report by id, including its rows and columns (GET /reports/{reportId}).

GET

Get Report As Excel

Download a report as an Excel file (GET /reports/{reportId} with Accept: application/vnd.ms-excel).

GET

Get Report As PDF

Download a report as a PDF (GET /reports/{reportId} with Accept: application/pdf).

POST

Send Report

Send a report as an attachment via email (POST /reports/{reportId}/emails).

Favorites3

GET

List Favorites

List the current user's favorites (GET /favorites). Offset pagination.

POST

Add Favorites

Add one or more items to the user's favorites (POST /favorites).

DELETE

Delete Favorite

Remove an item from the user's favorites (DELETE /favorites/{favoriteType}/{objectId}).

Contacts2

GET

List Contacts

List the current user's contacts (GET /contacts). Offset pagination.

GET

Get Contact

Get a single contact by id (GET /contacts/{contactId}).

Search2

GET

Search Everything

Search across all sheets, reports, and dashboards the user has access to (GET /search).

GET

Search Sheet

Search within a single sheet (GET /search/sheets/{sheetId}).

Templates2

GET

List Public Templates

List the public templates in the Smartsheet template gallery (GET /templates/public).

GET

List User Templates

List the current user's own templates (GET /templates).

Events1

GET

List Events

Stream the organization's audit events (GET /events). Token-cursor pagination: pass the previous response's nextStreamPosition as streamPosition to continue. Requires an Event Reporting-enabled plan.

Home1

GET

List Home Contents

List all top-level items (sheets, folders, reports, dashboards, templates) in the user's Home (GET /home).

Serverinfo1

GET

Get Server Info

Get Smartsheet application constants — feature flags, formats, and supported values (GET /serverinfo).

Automations using Smartsheet

Build your own automation with Smartsheet in the visual builder.

Frequently asked questions

What can I automate with Smartsheet?

107 actions are available — for example: Get Current User, List Sheets, Get Sheet, Create Sheet, Create Sheet From Template, and more.

Which Smartsheet events can start a workflow?

15 triggers — for example: Sheet Created, Sheet Updated, Sheet Deleted, Row Created.

Can Smartsheet be used as an AI agent tool?

Yes. Every Smartsheet action automatically becomes a tool an AI agent can call — the same pack powers both your workflows and your agents.

How is the Smartsheet integration modelled?

Smartsheet is modelled as a versioned connector pack, and the steps that need reasoning fall to first-party agents hosted in the same runtime as the workflows.