Skip to content

Connect Azure DevOps and Smartsheet to unlock the power of automation

  • No credit card required
  • Free forever for core features
  • 14-day trial for premium features and apps
Choose a Trigger
Choose an Action
Google Logo Start with Google for free

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 Azure DevOps with Smartsheet - no code necessary. See how you can get setup in minutes.

100%
Help
Azure DevOps logo
Azure DevOps
Azure DevOps logo
Azure DevOps
1. Choose trigger event
Smartsheet logo
Smartsheet
Smartsheet logo
Smartsheet
2. Choose action
Azure DevOps logo
1. Select the event
Setup
Test
Azure DevOps logo
Azure DevOps
Choose a trigger event

Choose a trigger

A trigger is the event that starts your Zap—like a "Completed Build" from Azure DevOps.

Add your action

An action happens after the trigger—such as "Create Workspace" in Smartsheet.

You’re connected!

Zapier seamlessly connects Azure DevOps and Smartsheet, automating your workflow.

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.

    • 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
    • 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

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

G2 Badge - Best Est. ROI - Winter 2024
G2 Badge - Best Results - Winter 2024
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

Practical ways you can use Azure DevOps and Smartsheet

Create Azure DevOps work items for new Smartsheet rows.

Turn customer feedback into actionable development work. When a new row is added in Smartsheet—such as a customer issue logged manually—Zapier instantly creates a corresponding work item in Azure DevOps, ensuring developers have the context they need and reducing back-and-forth communication.

Customer Support Ops
Try it
Track Azure DevOps code pushes in Smartsheet.

Ensure your team gets visibility on changes. When code is pushed to a Git repository in Azure DevOps, Zapier automatically logs the update in Smartsheet, helping the team stay informed without constant manual updates.

IT
Log new Azure DevOps work items in Smartsheet.

Easily keep your project tracking sheet up-to-date. When a new work item is created in Azure DevOps, Zapier automatically logs it as a new row in Smartsheet, ensuring the team has a central live reference for every new task, reducing manual data entry and saving time.

Project Management

Learn how to automate Smartsheet on the Zapier blog

Make work flow with AI

Level up your Azure DevOps to Smartsheet integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Illustration of AI enhancing Zapier workflows with automation and app integrations.

Frequently Asked Questions about Azure DevOps + Smartsheet integrations

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

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.

azure-devops logo
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 integrationsGitHub integrations
GitHub
Developer Tools
Jira Software Server integrationsJira Software Server integrations
Jira Software Server
Project Management
smartsheet logo
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.
Related categories
Similar apps
MySQL integrationsMySQL integrations
MySQL
Databases
Zoho Creator integrationsZoho Creator integrations
Zoho Creator
App Builder, Zoho
Knack integrationsKnack integrations
Knack
Databases

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

Google Logo Sign up with Google