Integrate Smartsheet with Azure DevOps to automate your work

Start with Google for free

1. Choose a Trigger

An event that starts an automation

2. Choose an Action

The event an automation performs after it's triggered

Endless possibilities

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Zapier makes it easy to integrate Smartsheet with Azure DevOps - no code necessary. See how you can get setup in minutes.

Select a trigger from Smartsheet

A trigger is an event that starts your Zap and runs the workflow. For example, with Smartsheet, a trigger could be "Updated Row."

A trigger is the event that kicks off your automated workflow.

Setup an action from Azure DevOps

An action is what takes place after the automation is triggered. For example, with Azure DevOps, the action could be "Trigger Build."

An action is the event that your automated workflow performs when triggered.

That’s it! You just connected Smartsheet to Azure DevOps

With Zapier, it’s never been easier to connect your apps together and automate your most tedious work. Save hours every month.

Triggers and actions are the main components of every automated workflow.

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Most Implementable - Winter 2024

G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Set up your first integration

Quickly connect Smartsheet to Azure DevOps with a Zapier template.

Our most popular template

Create Azure DevOps work items for new Smartsheet rows
Details
Try it
Smartsheet + Azure DevOps
Create new Smartsheet rows for new Azure DevOps work items
Details
Try it
Azure DevOps + Smartsheet
Create Azure DevOps work items from updated Smartsheet rows
Details
Try it
Smartsheet + Azure DevOps
Update work items in Azure DevOps and trigger new row updates in Smartsheet
Details
Try it
Azure DevOps + Smartsheet

Create Azure DevOps work items for new Smartsheet rows

Details

Try it

Smartsheet + Azure DevOps

Create new Smartsheet rows for new Azure DevOps work items

Details

Try it

Azure DevOps + Smartsheet

Create Azure DevOps work items from updated Smartsheet rows

Details

Try it

Smartsheet + Azure DevOps

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

Details

Try it

Azure DevOps + Smartsheet

Make work flow with AI

Level up your Smartsheet to Azure DevOps integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.

Learn about AI automation

Illustration of AI enhancing Zapier workflows with automation and app integrations.

Frequently Asked Questions about Smartsheet + Azure DevOps integrations

New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Smartsheet and Azure DevOps

How can I set up a workflow between Azure DevOps and Smartsheet?

To set up a workflow between Azure DevOps and Smartsheet, you need to create automation rules that define the triggers and actions in both systems. For example, you can set Azure DevOps to trigger an update in Smartsheet whenever a work item is completed.

What triggers are available when integrating Azure DevOps with Smartsheet?

There are several triggers available. In Azure DevOps, you can use triggers such as 'Work Item Created', 'Work Item Updated', or 'Build Completed'. These can then initiate actions in Smartsheet such as creating a new row or updating an existing one.

What actions can be performed in Smartsheet with this integration?

When integrating with Azure DevOps, actions in Smartsheet might include creating new rows, updating cell values based on project updates from DevOps, or sending alerts when certain conditions are met.

Can I automatically update tasks in Azure DevOps from changes made in Smartsheet?

Yes, it's possible to automate task updates. If there's a change in specified Smartsheet rows, we can trigger updates to sync back into Azure DevOps work items.

Is it possible to sync comments between work items and sheets?

Currently, syncing comments directly might require additional custom setups or third-party tools. Standard integrations focus more on data fields like task status or priority changes.

How do I handle errors during sync between Azure DevOps and Smartsheet?

We recommend setting up notifications for failed automation runs so that any errors can be quickly addressed by checking the logs and adjusting the workflow logic accordingly.

Are there limitations on data types that can be transferred between these two platforms?

Yes, while most standard data types such as text and number fields are supported, complex object types may require additional processing to ensure compatibility between both platforms.

Connect Smartsheet and Azure DevOps to integrate crucial parts of your business

With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.

Automate your lead management and improve conversions

With Zapier, you can automate every part of your lead funnel and give yourself the best chance at converting leads. Automate everything from lead capture to outreach to reporting—and close more deals as a result.

An illustration representing how to automate lead management with Zapier.

Create more impactful campaigns with automation

Measuring campaign performance across platforms can get chaotic. Plus, digging up the right metrics costs you precious time and effort. With Zapier, you can create a centralized view of your performance, skillfully manage your lists, and ensure your campaigns drive ROI across the business.

An illustration representing how to measure campaign impact with Zapier.

Provide world-class support with a little help from automation

Support reps can't be productive when they have to track down crucial information for every incident or ticket. With Zapier, you can automatically send your reps the context they need to resolve tickets quickly and create a seamless customer experience.

An illustration representing how to automate customer support with Zapier.

Automate your way to actionable, up-to-date data

The days of manually exporting and importing data are over. With Zapier, you can send data where it needs to go, in the format you need it—so you can centralize your data and unlock more insights.

An illustration representing how to move and manage data with Zapier.

Resolve incidents faster with automation

Your technical support team wants to focus on tech tickets rather than admin work. With Zapier, you can automate everything from ticket creation to routing to inter-team communication—eliminating friction from incident management and increasing speed to resolution.

An illustration of a flow chart representing how to resolve tickets and incidents with Zapier.

Connect Smartsheet and Azure DevOps to unlock the power of automation

With Zapier's 7,000 integrations, you can unify your tools within a connected system to improve your team's efficiency and deepen their impact.

Choose a Trigger

Start here

Choose an Action

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

- Choose a Sheet
  Required
Trigger
Scheduled
Try It
- Choose a Sheet
  Required
Trigger
Scheduled
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 Folder Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Destination
  Required
- Choose a Sheet
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write

- Choose a Sheet
  Required
- Row
  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)
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row
Find a row in a specified sheet using a query.
Action
Write
- 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 Path
- Iteration
- Assigned To
- Description
Action
Write
- Project
  Required
- Work Item Number
  Required
- Link
  Required
- Comment
  Required
Action
Write
- Project
  Required
- Team
  Required
- Would you like to setup the query here or use an existing query?
  Required
Action
Search

- Choose a Sheet
  Required
Trigger
Scheduled
Try It
- Choose a Sheet
  Required
Trigger
Scheduled
Try It
- Choose a Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose a Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Choose a 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)
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api_docs_info
- HTTP Method
  Required
- URL
  Required
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Build Definition
  Required
- Build Status
- Project
  Required
Trigger
Instant
Try It
- Project
  Required
- Repository
  Required
- 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
- Type
  Required
- Work Item
  Required
- Do you want to supress notifications for this update?
Action
Write
- HTTP Method
  Required
- URL
  Required
- Query String Parameters
- Headers
- 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 Path
- Iteration
- Assigned To
- Description
Action
Search or write

Learn how to automate Smartsheet on the Zapier blog

Learn how to automate Azure DevOps on the Zapier blog

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.

Help

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

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

Integrate Smartsheet with Azure DevOps to automate your work

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Select a trigger from Smartsheet

Setup an action from Azure DevOps

That’s it! You just connected Smartsheet to Azure DevOps

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

Set up your first integration

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

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

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

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

Make work flow with AI

Frequently Asked Questions about Smartsheet + Azure DevOps integrations

Connect Smartsheet and Azure DevOps to integrate crucial parts of your business

Automate your lead management and improve conversions

Create more impactful campaigns with automation

Provide world-class support with a little help from automation

Automate your way to actionable, up-to-date data

Resolve incidents faster with automation

Connect Smartsheet and Azure DevOps to unlock the power of automation

Supported triggers and actions

Learn how to automate Smartsheet on the Zapier blog

7 ways to automate Smartsheet with Zapier

Learn how to automate Azure DevOps on the Zapier blog

Connect Smartsheet to Azure DevOps on the world's largest no-code automation platform