Azure DevOps + Smartsheet

Update work items in Azure DevOps and trigger new row updates in Smartsheet

Keep your project management seamless and efficient with this workflow. Whenever there is an update to a work item in Azure DevOps, it simultaneously revises the corresponding row in Smartsheet. This ensures your data always reflects the most recent developments, saving you time while upholding accuracy and consistency across platforms. This is a handy solution for teams seeking to streamline their work updates without the need for manual intervention.

When this happens...
Updated Work Item
Triggers when a work item is updated.
TriggerInstant
automatically do this!
Update Row
Update an existing row with new values. Requires a row ID.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Build DefinitionRequired
- Build Status
- ProjectRequired
Trigger
Instant
Try It
- ProjectRequired
- Repository
- Branch
Trigger
Instant
Try It
- ProjectRequired
- Area Path
- Work Item Type
Trigger
Instant
Try It
- ProjectRequired
- Build DefinitionRequired
Action
Write
- ProjectRequired
- Work Item TypeRequired
- Work ItemRequired
- Do you want to supress notifications for this update?
Action
Write

- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- ProjectRequired
- TeamRequired
- Would you like to setup the query here or use an existing query?Required
- ProjectRequired
- TypeRequired
- TitleRequired
- Area
- Iteration
- Assigned To
- Description
Action
Search or write

- Choose a SheetRequired
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- SheetRequired
- RowRequired
- File AttachmentRequired
Action
Write
- Choose a SheetRequired
- Add Row to Top or Bottom
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- SheetRequired
- ColumnRequired
- Parent Row
Action
Write
- DestinationRequired
- Sheet to CopyRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Row IDRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- FormatRequired
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a WorkspaceRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet IDRequired
- QueryRequired
Action
Search

- ProjectRequired
- PathRequired
Trigger
Instant
Try It
- ProjectRequired
- Area Path
- Work Item Type
- Contains StringRequired
Trigger
Instant
Try It
- ProjectRequired
- Area Path
- Work Item Type
- Changed Field
Trigger
Instant
Try It
- ProjectRequired
- TypeRequired
- TitleRequired
- Area
- Iteration
- Assigned To
- Description
Action
Write
- ProjectRequired
- Work Item NumberRequired
- LinkRequired
- Comment
Action
Write
- ProjectRequired
- TeamRequired
- Would you like to setup the query here or use an existing query?Required
Action
Search
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
- Select a ReportRequired
Trigger
Polling
Try It
- Workspace NameRequired
Action
Write
- Choose a SheetRequired
- RowRequired
- TitleRequired
- CommentRequired
Action
Write
- Source FolderRequired
- Destination FolderRequired
- New Folder NameRequired
Action
Write
- WorkspaceRequired
- New NameRequired
- What to Include?
- Skip Remap
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- DestinationRequired
- TemplateRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- Choose RowRequired
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a SheetRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet IDRequired
- Row IDRequired
Action
Search

About Azure DevOps

Azure DevOps is where teams manage, develop, and deliver software in the cloud. Azure DevOps provides free, private Git project hosting for up to 5 users, project and test management tools, build and CI, and team collaboration. Connect using the development tools of your choice, including Visual Studio, Eclipse, Xcode, and more.

Related categories

Similar apps

GitHub

Developer Tools

Jira Software Server

Project Management

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.