Unique Features

• A simplified and secure connection manager makes it easy to communicate with Smartsheet.
• Supports Smartsheet's numerous APIs including Attachments, Cells, Comments, Cross-Sheet References, Discussions, Folders, Reports, Templates, and, Workspaces.
• Read data from over 20 Smartsheet source objects including Automation Rules, Columns, Contacts, Groups, Rows, Search, Server Information, Sharing, Sheets, Sights, and, Users.
• Retrieve data from Smartsheet with several advanced filtering capabilities for further data retrieval refinement.
• Smartsheet Destination Component supports massive data manipulation of the following objects:
  • Attachments - Attach File to Comment, Row, or, Sheet, Attach URL to Comment, Row, or, Sheet, Attach New Version, Delete Attachments, or, Delete All Version.
  • Automation Rules - Delete or Update an Automation Rule.
  • Columns - Add, Update, or, Delete.
  • Comments - Add, Edit, or, Delete.
  • Cross-Sheet References - Create.
    
  • Discussions - Create on Row, or on Sheet.
  • Favorites - Add Favorites, or, Remove Favorite Folder(s), Report(s), Sheet(s), Sight(s), Template(s), or, Workspace(s).
    
  • Folders - Copy, Update, Delete, or, Move Folder, or, Create Folder Sheets level, Subfolder, or, Workspace.
    
  • Group Members - Add or Remove.
    
  • Groups - Create, Update, or, Delete.
    
  • Import - Import Sheet from CSV / XLSX, or, Import Sheet into Folder or Workspace.
  • Reports - Set Report Publish Status, or, Send Report via Email.
  • Rows - Add, Update, or Delete Rows, or, Copy or Move Rows to Another Sheet, or, Send Rows via Email.
  • Send Via Email - Report, Rows, or Sheets.
  • Sharing - Share Report, Sheet, Sight, or, Workspace, Update Report Share, Sheet Share, Sight Share, or, Workspace Share, or, Delete Report Share, Sheet Share, Sight Share, or, Workspace Share.
    
  • Sheets - Copy, Move, Delete, or, Update Sheet, Create Sheet in Sheets Folder, in Folder, in Workspace, in Sheets Folder from Template, in Folder from Template, or, in Workspace from Template, Set Sheet Publish Status, Send Sheet via Email, or, Sort Rows in Sheet.
  • Sights - Copy, Update, Delete, or Move Sight, or, Set Sight Publish Status.
  • Update Requests - Create, Change, or, Delete Update Request, or, Delete Sent Update Request.
  • Users - Add, Update, or, Remove User, or, Update User Profile, or, Add, or Delete Alternate Email, or, Make Alternate Email Primary.
  • Workspaces - Create, Update, Delete, or, Copy.