All integrationsProject Management

Smartsheet

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
25
triggers
2

Triggers

Start a workflow when something happens in Smartsheet.

  • New Smartsheet rowRuns when a row is added to a Smartsheet sheet.
  • Smartsheet row changedRuns when a row in a Smartsheet sheet is changed, once for each change.

Actions

Steps a workflow can run in Smartsheet.

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

Automate Smartsheet with Lodol.

Connect Smartsheet and ask your AI for your first workflow.

Free plan, no credit card