Smartsheet

App · 26 actions

Work with Smartsheet from workflows: add, update and find rows by column name, create and copy sheets, add columns, comment, attach links, share sheets and read reports, and start a workflow when a row is added or changed.

Actions

ActionWhat it does
Add columnAdd a column at the right of a sheet: text, date, checkbox, dropdown or contact.
Add commentAdd a comment to a row, or to the sheet itself.
Add rowAdd a row to a sheet, filling in its cells by column name.
Attach linkAttach a link to a row, or to the sheet itself.
Copy rows to another sheetCopy rows to the bottom of another sheet, leaving them where they are.
Copy sheetCopy a sheet into a workspace or folder under a new name, such as a template for each new project.
Create sheetCreate a sheet in a workspace or one of its folders, with the columns you name.
Delete rowDelete a row from a sheet.
Delete sheetDelete a sheet with all its rows, comments and attachments.
Find rowsFind the rows whose value in a column is, or contains, what you give (not case-sensitive).
Get cell historyGet how one cell changed over time: each value, when and by whom, newest first.
Get my accountGet the Smartsheet account this connection uses: name, email address, time zone and organization.
Get reportGet a report's rows, gathered from the sheets it covers, each row's cells by column name.
Get rowGet one row with its cells by column name.
Get sheetGet a sheet with its columns and rows, each row's cells by column name.
List attachmentsList the attachments on a sheet, its rows and its comments.
List columnsList a sheet's columns with their types and dropdown choices.
List commentsList the comments on a sheet and its rows, or on one row.
List reportsList the reports you can open.
List sheetsList the sheets you can open, alphabetically, optionally only those changed since a date and time.
List workspacesList the workspaces you can open, with your access to each.
Move rows to another sheetMove rows, with their comments and attachments, to the bottom of another sheet, such as an archive.
SearchSearch everything you can open in Smartsheet (sheets, rows, reports, comments and attachments) for some words.
Send rows by emailEmail rows of a sheet to people.
Share sheetShare a sheet with someone by email address, as a viewer, commenter, editor or admin.
Update rowChange cells of a row by column name.

Add column

Add a column at the right of a sheet: text, date, checkbox, dropdown or contact.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
NametitletextRequired
The column's name. It must differ from the others.
Typecolumn_typetext
What it holds. Defaults to text or number.One of: TEXT_NUMBER (Text or number (default)), DATE, CHECKBOX, PICKLIST (Dropdown, one choice), MULTI_PICKLIST (Dropdown, several choices), CONTACT_LIST (Contact), MULTI_CONTACT_LIST (Contacts, several). Default: TEXT_NUMBER.
Choicesoptionslist
The dropdown's choices, in order.Only when Type is Dropdown, one choice or Dropdown, several choices.
Descriptiondescriptiontext
What the column is for, shown in Smartsheet.

Outputs

columnobject
The new column
Example output
{
  "column": {
    "description": "",
    "formula": "",
    "hidden": false,
    "id": "642523719853956",
    "index": 1,
    "options": [
      "Open",
      "In progress",
      "Done"
    ],
    "primary": false,
    "system_type": "",
    "title": "Status",
    "type": "PICKLIST"
  }
}

Add comment

Add a comment to a row, or to the sheet itself.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
CommenttexttextRequired
What to say.
Rowrow_idtext
The row to comment on. Leave blank to comment on the sheet.

Outputs

commentobject
A comment
Example output
{
  "comment": {
    "author_email": "jane.doe@smartsheet.com",
    "author_name": "Jane Doe",
    "created_at": "2026-10-24T09:25:00Z",
    "discussion_id": "3962273862576004",
    "id": "4952999069833092",
    "row_id": "2361756178769796",
    "text": "Sent on Friday."
  }
}

Add row

Add a row to a sheet, filling in its cells by column name.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
CellscellsobjectRequired
A value for each column to fill in, by column name, such as {"Status": "Approved"}. This is what the step writes, so give at least one column: with none, the step fails. Leave a column out, or blank, to leave it as it is. A checkbox takes yes or no; a multi-choice dropdown or a column of several contacts takes values separated by commas.
Wherepositiontext
Where the row goes. Defaults to the bottom.One of: bottom (At the bottom (default)), top (At the top). Default: bottom.

Outputs

rowobject
The row
Example output
{
  "row": {
    "cells": {
      "Created": "2026-10-24T09:12:31Z",
      "Done": false,
      "Due": "2026-10-31",
      "Owners": "Jane Doe",
      "Status": "Open",
      "Tags": "Urgent, Client",
      "Task": "Send the proposal"
    },
    "created_at": "2026-10-24T09:12:31Z",
    "created_by": "jane.doe@smartsheet.com",
    "id": "2361756178769796",
    "modified_at": "2026-10-24T09:15:02Z",
    "modified_by": "jane.doe@smartsheet.com",
    "parent_id": "",
    "permalink": "https://app.smartsheet.com/sheets/abc?rowId=2361756178769796",
    "row_number": 1,
    "sheet_id": "4583173393803140"
  }
}

Attach a link to a row, or to the sheet itself.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
LinkurltextRequired
The web address, starting with https://.
Namenametext
What Smartsheet shows for it. Defaults to the link itself.
Rowrow_idtext
The row to attach it to. Leave blank to attach it to the sheet.

Outputs

attachmentobject
An attachment
Example output
{
  "attachment": {
    "attachment_type": "LINK",
    "created_at": "2026-10-24T09:20:00Z",
    "created_by": "jane.doe@smartsheet.com",
    "id": "1205473673275268",
    "name": "Proposal",
    "parent_id": "2361756178769796",
    "parent_type": "ROW",
    "url": "https://example.com/proposal"
  }
}

Copy rows to another sheet

Copy rows to the bottom of another sheet, leaving them where they are.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rowsrow_idslistRequired
The ids of the rows, from 'Find rows' or an earlier step. One id, or several separated by commas.
To sheetdestination_sheet_idtextRequired
The sheet the rows go to, at the bottom. Cells go into its columns of the same name.

Outputs

destination_sheet_idtext
The sheet the rows went to
row_idslist
The rows' ids in the other sheet
rowslist
Each row and its id in the other sheet
Example output
{
  "destination_sheet_id": "2258256056870788",
  "row_ids": [
    "4685452237203332"
  ],
  "rows": [
    {
      "from_row_id": "2361756178769796",
      "to_row_id": "4685452237203332"
    }
  ]
}

Copy sheet

Copy a sheet into a workspace or folder under a new name, such as a template for each new project.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
New namenew_nametextRequired
The copy's name, up to 50 characters.
Workspaceworkspace_idtextRequired
The workspace it goes in.
Folderfolder_idtext
A folder in the workspace. Leave blank for the top of the workspace.
Copycontentstext
What to bring along. Sharing is never copied.One of: everything (Everything: rows, comments, attachments and automations), structure (Columns only, no rows). Default: everything.

Outputs

sheetobject
The copy
Example output
{
  "sheet": {
    "access_level": "OWNER",
    "created_at": "2026-10-20T08:00:00Z",
    "id": "4583173393803140",
    "modified_at": "2026-10-24T09:15:02Z",
    "name": "Project plan (copy)",
    "permalink": "https://app.smartsheet.com/sheets/abc"
  }
}

Create sheet

Create a sheet in a workspace or one of its folders, with the columns you name. Add typed columns (dates, dropdowns) with 'Add column'.

Inputs

NamenametextRequired
The sheet's name, up to 50 characters.
Workspaceworkspace_idtextRequired
The workspace it goes in.
Folderfolder_idtext
A folder in the workspace. Leave blank for the top of the workspace.
Columnscolumnslist
The column names, left to right. The first is the sheet's primary column. Defaults to one column, Name.

Outputs

sheetobject
The new sheet
Example output
{
  "sheet": {
    "access_level": "OWNER",
    "columns": [
      {
        "description": "",
        "formula": "",
        "hidden": false,
        "id": "7960873114331012",
        "index": 0,
        "options": [],
        "primary": true,
        "system_type": "",
        "title": "Task",
        "type": "TEXT_NUMBER"
      }
    ],
    "created_at": "2026-10-20T08:00:00Z",
    "id": "4583173393803140",
    "modified_at": "2026-10-24T09:15:02Z",
    "name": "Project plan",
    "permalink": "https://app.smartsheet.com/sheets/abc"
  }
}

Delete row

Delete a row from a sheet.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rowrow_idtextRequired
The row's id, from 'Add row', 'Find rows' or a trigger (the id of 'New row' or 'Row changed').

Outputs

deletedtrue/false
True once deleted
row_idtext
The row deleted
Example output
{
  "deleted": true,
  "row_id": "2361756178769796"
}

Delete sheet

Delete a sheet with all its rows, comments and attachments. Only its owner or an admin can.

Inputs

Sheetsheet_idtextRequired
The sheet to use.

Outputs

deletedtrue/false
True once deleted
sheet_idtext
The sheet deleted
Example output
{
  "deleted": true,
  "sheet_id": "4583173393803140"
}

Find rows

Find the rows whose value in a column is, or contains, what you give (not case-sensitive). Looks through up to 10,000 rows.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
ColumncolumntextRequired
The column, by name.
Valuevaluetext
What the cell holds. Leave blank to find rows where it is empty.
Matchmatchtext
Whether the cell is exactly the value or contains it.One of: is (Is exactly (default)), contains. Default: is.
Most to returnlimitnumber
How many rows to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.

Outputs

countnumber
How many are returned
rowslist
The matching rows, top to bottom
rows_searchednumber
How many rows were looked at
Example output
{
  "count": 1,
  "rows": [
    {
      "cells": {
        "Created": "2026-10-24T09:12:31Z",
        "Done": false,
        "Due": "2026-10-31",
        "Owners": "Jane Doe",
        "Status": "Open",
        "Tags": "Urgent, Client",
        "Task": "Send the proposal"
      },
      "created_at": "2026-10-24T09:12:31Z",
      "created_by": "jane.doe@smartsheet.com",
      "id": "2361756178769796",
      "modified_at": "2026-10-24T09:15:02Z",
      "modified_by": "jane.doe@smartsheet.com",
      "parent_id": "",
      "permalink": "https://app.smartsheet.com/sheets/abc?rowId=2361756178769796",
      "row_number": 1,
      "sheet_id": "4583173393803140"
    }
  ],
  "rows_searched": 1
}

Get cell history

Get how one cell changed over time: each value, when and by whom, newest first.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rowrow_idtextRequired
The row's id, from 'Add row', 'Find rows' or a trigger (the id of 'New row' or 'Row changed').
ColumncolumntextRequired
The column, by name.

Outputs

changeslist
Each version, newest first
columntext
The column's name
countnumber
How many are returned
Example output
{
  "changes": [
    {
      "display_value": "Done",
      "modified_at": "2026-10-24T09:15:02Z",
      "modified_by_email": "jane.doe@smartsheet.com",
      "modified_by_name": "Jane Doe",
      "value": "Done"
    }
  ],
  "column": "Status",
  "count": 1
}

Get my account

Get the Smartsheet account this connection uses: name, email address, time zone and organization.

Inputs

None.

Outputs

userobject
The Smartsheet account the token belongs to
Example output
{
  "user": {
    "account_name": "Acme Corp",
    "admin": true,
    "email": "jane.doe@smartsheet.com",
    "first_name": "Jane",
    "id": "48569348493401200",
    "last_name": "Doe",
    "licensed_sheet_creator": true,
    "locale": "en_US",
    "time_zone": "US/Pacific"
  }
}

Get report

Get a report's rows, gathered from the sheets it covers, each row's cells by column name.

Inputs

Reportreport_idtextRequired
The report to read.
Rows per pagelimitnumber
How many rows to return, 1 to 1000. Defaults to 100.From 1 to 1000.
Pagepagenumber
Which page, from 1. Use it when 'has_more' says there is more.At least 1.

Outputs

columnslist
The report's column names
has_moretrue/false
True when a later page has more
idtext
Report id
nametext
Report name
pagenumber
The page returned
permalinktext
Link to the report
rowslist
This page of rows
total_row_countnumber
How many rows it has
Example output
{
  "columns": [
    "Task",
    "Status"
  ],
  "has_more": false,
  "id": "8166690897684356",
  "name": "Open tasks",
  "page": 1,
  "permalink": "https://app.smartsheet.com/reports/jkl",
  "rows": [
    {
      "cells": {
        "Status": "Open",
        "Task": "Send the proposal"
      },
      "id": "2361756178769796",
      "modified_at": "2026-10-24T09:15:02Z",
      "row_number": 1,
      "sheet_id": "4583173393803140"
    }
  ],
  "total_row_count": 1
}

Get row

Get one row with its cells by column name.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rowrow_idtextRequired
The row's id, from 'Add row', 'Find rows' or a trigger (the id of 'New row' or 'Row changed').

Outputs

rowobject
The row
Example output
{
  "row": {
    "cells": {
      "Created": "2026-10-24T09:12:31Z",
      "Done": false,
      "Due": "2026-10-31",
      "Owners": "Jane Doe",
      "Status": "Open",
      "Tags": "Urgent, Client",
      "Task": "Send the proposal"
    },
    "created_at": "2026-10-24T09:12:31Z",
    "created_by": "jane.doe@smartsheet.com",
    "id": "2361756178769796",
    "modified_at": "2026-10-24T09:15:02Z",
    "modified_by": "jane.doe@smartsheet.com",
    "parent_id": "",
    "permalink": "https://app.smartsheet.com/sheets/abc?rowId=2361756178769796",
    "row_number": 1,
    "sheet_id": "4583173393803140"
  }
}

Get sheet

Get a sheet with its columns and rows, each row's cells by column name. Large sheets come a page at a time.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rows per pagelimitnumber
How many rows to return, 1 to 1000. Defaults to 100.From 1 to 1000.
Pagepagenumber
Which page, from 1. Use it when 'has_more' says there is more.At least 1.

Outputs

columnslist
The sheet's columns
has_moretrue/false
True when a later page has more
idtext
Sheet id
nametext
Sheet name
pagenumber
The page returned
permalinktext
Link to the sheet
rowslist
This page of rows
total_row_countnumber
How many rows the sheet has
Example output
{
  "columns": [
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "7960873114331012",
      "index": 0,
      "options": [],
      "primary": true,
      "system_type": "",
      "title": "Task",
      "type": "TEXT_NUMBER"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "642523719853956",
      "index": 1,
      "options": [
        "Open",
        "In progress",
        "Done"
      ],
      "primary": false,
      "system_type": "",
      "title": "Status",
      "type": "PICKLIST"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "5146123347224452",
      "index": 2,
      "options": [],
      "primary": false,
      "system_type": "",
      "title": "Due",
      "type": "DATE"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "2894323533539204",
      "index": 3,
      "options": [],
      "primary": false,
      "system_type": "",
      "title": "Done",
      "type": "CHECKBOX"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "7397923160909700",
      "index": 4,
      "options": [
        "Urgent",
        "Client"
      ],
      "primary": false,
      "system_type": "",
      "title": "Tags",
      "type": "MULTI_PICKLIST"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "1768423626696580",
      "index": 5,
      "options": [],
      "primary": false,
      "system_type": "",
      "title": "Owners",
      "type": "MULTI_CONTACT_LIST"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "6272023254067076",
      "index": 6,
      "options": [],
      "primary": false,
      "system_type": "CREATED_DATE",
      "title": "Created",
      "type": "DATETIME"
    }
  ],
  "has_more": false,
  "id": "4583173393803140",
  "name": "Project plan",
  "page": 1,
  "permalink": "https://app.smartsheet.com/sheets/abc",
  "rows": [
    {
      "cells": {
        "Created": "2026-10-24T09:12:31Z",
        "Done": false,
        "Due": "2026-10-31",
        "Owners": "Jane Doe",
        "Status": "Open",
        "Tags": "Urgent, Client",
        "Task": "Send the proposal"
      },
      "created_at": "2026-10-24T09:12:31Z",
      "created_by": "jane.doe@smartsheet.com",
      "id": "2361756178769796",
      "modified_at": "2026-10-24T09:15:02Z",
      "modified_by": "jane.doe@smartsheet.com",
      "parent_id": "",
      "permalink": "https://app.smartsheet.com/sheets/abc?rowId=2361756178769796",
      "row_number": 1,
      "sheet_id": "4583173393803140"
    }
  ],
  "total_row_count": 1
}

List attachments

List the attachments on a sheet, its rows and its comments.

Inputs

Sheetsheet_idtextRequired
The sheet to use.

Outputs

attachmentslist
The attachments
countnumber
How many are returned
Example output
{
  "attachments": [
    {
      "attachment_type": "LINK",
      "created_at": "2026-10-24T09:20:00Z",
      "created_by": "jane.doe@smartsheet.com",
      "id": "1205473673275268",
      "name": "Proposal",
      "parent_id": "2361756178769796",
      "parent_type": "ROW",
      "url": "https://example.com/proposal"
    }
  ],
  "count": 1
}

List columns

List a sheet's columns with their types and dropdown choices.

Inputs

Sheetsheet_idtextRequired
The sheet to use.

Outputs

columnslist
The columns, left to right
countnumber
How many are returned
Example output
{
  "columns": [
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "7960873114331012",
      "index": 0,
      "options": [],
      "primary": true,
      "system_type": "",
      "title": "Task",
      "type": "TEXT_NUMBER"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "642523719853956",
      "index": 1,
      "options": [
        "Open",
        "In progress",
        "Done"
      ],
      "primary": false,
      "system_type": "",
      "title": "Status",
      "type": "PICKLIST"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "5146123347224452",
      "index": 2,
      "options": [],
      "primary": false,
      "system_type": "",
      "title": "Due",
      "type": "DATE"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "2894323533539204",
      "index": 3,
      "options": [],
      "primary": false,
      "system_type": "",
      "title": "Done",
      "type": "CHECKBOX"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "7397923160909700",
      "index": 4,
      "options": [
        "Urgent",
        "Client"
      ],
      "primary": false,
      "system_type": "",
      "title": "Tags",
      "type": "MULTI_PICKLIST"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "1768423626696580",
      "index": 5,
      "options": [],
      "primary": false,
      "system_type": "",
      "title": "Owners",
      "type": "MULTI_CONTACT_LIST"
    },
    {
      "description": "",
      "formula": "",
      "hidden": false,
      "id": "6272023254067076",
      "index": 6,
      "options": [],
      "primary": false,
      "system_type": "CREATED_DATE",
      "title": "Created",
      "type": "DATETIME"
    }
  ],
  "count": 7
}

List comments

List the comments on a sheet and its rows, or on one row.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rowrow_idtext
Only this row's comments. Leave blank for the whole sheet.

Outputs

commentslist
The comments
countnumber
How many are returned
Example output
{
  "comments": [
    {
      "author_email": "jane.doe@smartsheet.com",
      "author_name": "Jane Doe",
      "created_at": "2026-10-24T09:25:00Z",
      "discussion_id": "3962273862576004",
      "id": "4952999069833092",
      "row_id": "2361756178769796",
      "text": "Sent on Friday."
    }
  ],
  "count": 1
}

List reports

List the reports you can open.

Inputs

None.

Outputs

countnumber
How many are returned
reportslist
The reports
Example output
{
  "count": 1,
  "reports": [
    {
      "access_level": "OWNER",
      "id": "8166690897684356",
      "name": "Open tasks",
      "permalink": "https://app.smartsheet.com/reports/jkl"
    }
  ]
}

List sheets

List the sheets you can open, alphabetically, optionally only those changed since a date and time.

Inputs

Changed sincemodified_sincedate and time
Only sheets changed at or after this time.
Page sizelimitnumber
How many to return, 1 to 1000. Defaults to 100.From 1 to 1000.
Pagepagenumber
Which page, from 1. Use it when 'has_more' says there is more.At least 1.

Outputs

countnumber
How many are returned
has_moretrue/false
True when a later page has more
pagenumber
The page returned
sheetslist
The sheets
totalnumber
How many sheets in all
Example output
{
  "count": 1,
  "has_more": false,
  "page": 1,
  "sheets": [
    {
      "access_level": "OWNER",
      "created_at": "2026-10-20T08:00:00Z",
      "id": "4583173393803140",
      "modified_at": "2026-10-24T09:15:02Z",
      "name": "Project plan",
      "permalink": "https://app.smartsheet.com/sheets/abc"
    }
  ],
  "total": 1
}

List workspaces

List the workspaces you can open, with your access to each.

Inputs

None.

Outputs

countnumber
How many are returned
workspaceslist
The workspaces
Example output
{
  "count": 1,
  "workspaces": [
    {
      "access_level": "OWNER",
      "id": "7116448184199044",
      "name": "Operations",
      "permalink": "https://app.smartsheet.com/workspaces/def"
    }
  ]
}

Move rows to another sheet

Move rows, with their comments and attachments, to the bottom of another sheet, such as an archive.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rowsrow_idslistRequired
The ids of the rows, from 'Find rows' or an earlier step. One id, or several separated by commas.
To sheetdestination_sheet_idtextRequired
The sheet the rows go to, at the bottom. Cells go into its columns of the same name.

Outputs

destination_sheet_idtext
The sheet the rows went to
row_idslist
The rows' ids in the other sheet
rowslist
Each row and its id in the other sheet
Example output
{
  "destination_sheet_id": "2258256056870788",
  "row_ids": [
    "4685452237203332"
  ],
  "rows": [
    {
      "from_row_id": "2361756178769796",
      "to_row_id": "4685452237203332"
    }
  ]
}

Search everything you can open in Smartsheet (sheets, rows, reports, comments and attachments) for some words. Smartsheet may take a few minutes to find something just added.

Inputs

Search forquerytextRequired
The words to find. Put them in double quotes to match them exactly.

Outputs

countnumber
How many are returned
resultslist
What matched
totalnumber
How many matched in all
Example output
{
  "count": 1,
  "results": [
    {
      "context": "Row 1",
      "object_id": "2361756178769796",
      "object_type": "row",
      "text": "Send the proposal"
    }
  ],
  "total": 1
}

Send rows by email

Email rows of a sheet to people. Smartsheet sends it from your account, with the rows laid out as in the sheet.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rowsrow_idslistRequired
The ids of the rows, from 'Find rows' or an earlier step. One id, or several separated by commas.
TotolistRequired
Who to send it to: one email address, or several separated by commas.
Subjectsubjecttext
The email's subject. Leave blank for Smartsheet's own.
Messagemessagetext
A note above the rows. Leave blank for none.
Send me a copycc_metrue/false
Also send the email to you. Off unless turned on.Default: false.

Outputs

resulttext
SUCCESS, or PARTIAL_SUCCESS if some of it couldn't be sent.
row_idslist
The rows sent.
senttrue/false
Whether Smartsheet sent the email.
tolist
Who it was sent to.
Example output
{
  "result": "SUCCESS",
  "row_ids": [
    "2361756178769796"
  ],
  "sent": true,
  "to": [
    "pat@example.com"
  ]
}

Share sheet

Share a sheet with someone by email address, as a viewer, commenter, editor or admin.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Email addressemailtextRequired
Who to share it with.
Accessaccess_leveltext
What they can do. Defaults to Viewer.One of: VIEWER (Viewer (default)), COMMENTER, EDITOR, EDITOR_SHARE (Editor, can share), ADMIN. Default: VIEWER.
Email themsend_emailtrue/false
Let them know by email. On unless turned off.Default: true.
Messagemessagetext
A note for the email.Only when Email them is true.

Outputs

shareobject
The share
Example output
{
  "share": {
    "access_level": "EDITOR",
    "email": "john.doe@smartsheet.com",
    "id": "AAAQSF82F1eE",
    "name": "John Doe",
    "type": "USER"
  }
}

Update row

Change cells of a row by column name. Columns left blank keep their value.

Inputs

Sheetsheet_idtextRequired
The sheet to use.
Rowrow_idtextRequired
The row's id, from 'Add row', 'Find rows' or a trigger (the id of 'New row' or 'Row changed').
CellscellsobjectRequired
A value for each column to fill in, by column name, such as {"Status": "Approved"}. This is what the step writes, so give at least one column: with none, the step fails. Leave a column out, or blank, to leave it as it is. A checkbox takes yes or no; a multi-choice dropdown or a column of several contacts takes values separated by commas.

Outputs

rowobject
The row
Example output
{
  "row": {
    "cells": {
      "Created": "2026-10-24T09:12:31Z",
      "Done": false,
      "Due": "2026-10-31",
      "Owners": "Jane Doe",
      "Status": "Open",
      "Tags": "Urgent, Client",
      "Task": "Send the proposal"
    },
    "created_at": "2026-10-24T09:12:31Z",
    "created_by": "jane.doe@smartsheet.com",
    "id": "2361756178769796",
    "modified_at": "2026-10-24T09:15:02Z",
    "modified_by": "jane.doe@smartsheet.com",
    "parent_id": "",
    "permalink": "https://app.smartsheet.com/sheets/abc?rowId=2361756178769796",
    "row_number": 1,
    "sheet_id": "4583173393803140"
  }
}

On this page