Azure DevOps + Smartsheet

Azure DevOps + Smartsheet integrations

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 ItemTriggers when a work item is updated.
TriggerInstant
automatically do this!
Update RowUpdate an existing row with new values. Requires a row ID.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Azure DevOps and Smartsheet

Discover other triggers and actions you can use with Azure DevOps and Smartsheet

- Build Definition
  Required
- Build Status
- Project
  Required
Trigger
Instant
Try It
- Project
  Required
- Repository
- Branch
Trigger
Instant
Try It
- Project
  Required
- Area Path
- Work Item Type
Trigger
Instant
Try It
- Project
  Required
- Build Definition
  Required
Action
Write
- Project
  Required
- Work Item Type
  Required
- Work Item
  Required
- Do you want to supress notifications for this update?
Action
Write

- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project
  Required
- Team
  Required
- Would you like to setup the query here or use an existing query?
  Required
- Project
  Required
- Type
  Required
- Title
  Required
- Area
- Iteration
- Assigned To
- Description
Action
Search or write

- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- 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 ID
  Required
- Query
  Required
Action
Search

- Project
  Required
- Path
  Required
Trigger
Instant
Try It
- Project
  Required
- Area Path
- Work Item Type
- Contains String
  Required
Trigger
Instant
Try It
- Project
  Required
- Area Path
- Work Item Type
- Changed Field
Trigger
Instant
Try It
- Project
  Required
- Type
  Required
- Title
  Required
- Area
- Iteration
- Assigned To
- Description
Action
Write
- Project
  Required
- Work Item Number
  Required
- Link
  Required
- Comment
Action
Write
- Project
  Required
- Team
  Required
- 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 Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Folder
  Required
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
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.

HelpHelp

Related categories

Developer Tools

Microsoft

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.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Related Zap Templates

Create Azure DevOps work items for new Smartsheet rows

Create new Smartsheet rows for new Azure DevOps work items

Create Azure DevOps work items from updated Smartsheet rows