Connect Smartsheet to Siftree.
Dynamic work & collaboration software
Connect
Read from your Smartsheet account
Sign in once. Siftree reads your records and reacts to new events as they happen.
Get Comment
Retrieves a single comment from a Smartsheet sheet (GET /sheets/{sheetId}/comments/{commentId}), returning fields such as text, createdAt, and createdBy. Use List Discussions or Get Discussion to find a Comment ID.…
Get Current User
Get the authenticated user's identity - returns user ID, email, first/last name, and account details. Use this when the user says 'my sheets' or 'my account' to identify the owner. Example: takes no input and returns…
Get Discussion
Includes its embedded comments array (requested via include=comments ). Use List Discussions to find a Discussion ID. Example: {sheetId: "1234567890123456", discussionId: "3728427551461252"} returns {"title": "Velociraptor containment breach", "comments": [{"id": ..., "text": "..."}]}, and more
Get Row
Retrieve a single row from a sheet by row ID, with cell values keyed by column name instead of column ID. Returns a human-readable object like {"Species": "Velociraptor", "Status": "Monitoring"} plus row metadata. When…
Get Sheet
Get a sheet's full structure: column definitions (name, type, options, ID), all rows with cell values, and sheet metadata. This is the primary schema discovery tool - call it BEFORE Add Row to Sheet or Update Row to…
List Columns
List all columns in a sheet, returning each column's ID, title, type, options (for PICKLIST/CONTACT_LIST), validation, and position index. This is lighter-weight than Get Sheet when you only need the column schema and…
Includes rows, use Get Sheet instead, and more
List Workspace Templates
Lists the templates available across your workspaces, returning each template ID, name, and workspace. Use this to find a template ID for New Sheet From Template . When no workspace is set, a workspace that fails to…
Search
Full-text search across everything the account can see, or within a single sheet. This is the fastest way to find a sheet by name: results include whole objects, not just cell contents - each result carries an…
New Comment Added (Instant)Trigger
Emit new event when a comment is added in a sheet.
New Row Added (Instant)Trigger
Emit new event when a row is added to a sheet.
Show all 12Show fewer
New Row Deleted (Instant)Trigger
Emit new event when a row is deleted from a sheet.
New Row Updated (Instant)Trigger
Emit new event when a row is updated in a sheet.
Act
Take action in Smartsheet
Agents update records and send messages for you, automatically, as drafts, or after you approve.
Add Column
Includes its ID. Use List Columns to see the existing columns and their positions first. To change a column that already exists, use Update Column, and more
Add Comment
Adds a comment to an existing discussion on a Smartsheet sheet (POST /sheets/{sheetId}/discussions/{discussionId}/comments). Use List Discussions to find a Discussion ID.
Add Row to Sheet
Add one or more rows to a sheet, addressing cells by column NAME rather than column ID. Returns the created rows under result , each with its new row ID. Call Get Sheet or List Columns first to learn the column names.…
Copy Rows
Copy rows from one sheet to another. The rows stay in the source sheet and are duplicated in the destination. Cell values and formatting always come across; attachments and comments only if you ask for them via…
Copy Sheet
Copy an existing sheet to a new location. Creates a complete duplicate including all rows, columns, formatting, and attachments. Specify a destination workspace or folder, or omit both to copy to the user's home…
Includes all rows, columns, formatting, and attachments. Specify a destination workspace or folder, or omit both to copy to the user's home (Sheets folder). Returns the new sheet's ID and permalink. Use List Sheets to find the source sheet ID. To move a sheet instead (removing it from the original location), use Move Sheet, and more
Create Discussion
Creates a discussion on a Smartsheet sheet. If a Row ID is provided the discussion is attached to that row (POST /sheets/{sheetId}/rows/{rowId}/discussions); otherwise it is created at the sheet level (POST…
Create Sheet
Includes its ID and permalink. To create a sheet from an existing template instead of defining columns, use New Sheet From Template . To load a sheet from a CSV or XLSX file, use Import Sheet, and more
Delete Column
Permanently delete a column from a sheet. WARNING: This is irreversible - all cell data in the column is permanently destroyed. Use List Columns to find the column ID before deleting. Consider using Get Sheet to review…
Delete Comment
Permanently deletes a comment from a Smartsheet sheet (DELETE /sheets/{sheetId}/comments/{commentId}). This action is irreversible. Use Get Discussion to find a Comment ID. Example: {sheetId: "1234567890123456",…
Delete Discussion
Permanently deletes a discussion (and its comments) from a Smartsheet sheet. This action is irreversible. Use List Discussions to find a Discussion ID. Example: {sheetId: "1234567890123456", discussionId:…
Show all 21Show fewer
Delete Rows
Delete one or more rows from a sheet by row ID. This is permanent and cannot be undone. Use Get Sheet or Search to find row IDs first.
Delete Sheet
Permanently delete a sheet. This is irreversible - all data, rows, and columns are destroyed. Use List Sheets to find the sheet ID first.
Email Sheet
Send a sheet as an email attachment to one or more recipients. The sheet can be sent as PDF, Excel, or PDF Gantt format. Use List Sheets to find the sheet ID.
Import Sheet
Includes its ID and permalink. To create a sheet by defining columns yourself instead, use Create Sheet, and more
Move Rows
Move rows from one sheet to another. WARNING: the rows are permanently removed from the source sheet. Cell values and formatting always come across; attachments and comments only if you ask for them via Include.…
Move Sheet
Move a sheet to a different workspace, folder, or home. The sheet is removed from its current location. Use List Sheets to find the sheet ID. To copy a sheet instead (keeping the original), use Copy Sheet .
New Sheet From Template
Creates a new sheet from a template. Requires either a workspace or folder destination. Use List Workspace Templates to find template IDs. Use List Workspace Options to find workspace IDs. Use List Folder Options to…
Update Column
Update a column's title, type, or position in a sheet. Use List Columns to find the column ID and current properties before updating. Note: some type conversions may cause data loss.
Update Comment
Updates the text of an existing comment on a Smartsheet sheet (PUT /sheets/{sheetId}/comments/{commentId}). Use Get Discussion to find a Comment ID.
Update Row
Update one or more rows in a sheet by row ID, addressing cells by column NAME rather than column ID. Returns the updated rows under result . Call Get Sheet to find row IDs and column names first. To add new rows…
Update Sheet
Rename an existing sheet, leaving its rows, columns, attachments, and sharing untouched. Only the properties you supply are changed, and at least one must be supplied. Returns the updated sheet under result . To change…
More productivity and docs integrations
See all 559 →- Add to Calendar PROProductivity and docsConnectAct
- AirtableProductivity and docsConnectAct
- AsanaProductivity and docsConnectAct
- BoxProductivity and docsConnectAct
- ClickUpProductivity and docsConnectAct
- ClockifyProductivity and docsConnectAct
- DropboxProductivity and docsConnectAct
- Google CalendarProductivity and docsConnectAct
Need something from Smartsheet that isn't listed? Siftree can also collect from any public web page, or tell us what you need.