Loading

Azure DevOps + Google Sheets

Add rows to Google Sheets for new Visual Studio Online work items

Clearing out your backlog quickly doesn't mean you can't create a log of your activities at the same time. All you need to do is set up this Zap, after which a new row will be added to the Google Sheet of your choice whenever a new work item is added on Visual Studio Online, tracking everything you do effortlessly so you can focus on the work itself.

Clearing out your backlog quickly doesn't mean you can't create a log of your activities at the same time. All you need to do is set up this Zap, after which a new row will be added to the Google Sheet of your choice whenever a new work item is added on Visual Studio Online, tracking everything you do effortlessly so you can focus on the work itself.

  1. When this happens...
    Azure DevOpsAzure DevOps
    New Work Item

    Triggers when a work item is created.

    TriggerInstant
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Build DefinitionRequired

    • Build Status

    • ProjectRequired

    Trigger
    Instant
    Try It
    • Repository

    • Branch

    • ProjectRequired

    Trigger
    Instant
    Try It
    • Area Path

    • Work Item Type

    • ProjectRequired

    Trigger
    Instant
    Try It
    • ProjectRequired

    • Build DefinitionRequired

    Action
    Write
    • ProjectRequired

    • PathRequired

    Trigger
    Instant
    Try It
    • Contains StringRequired

    • Area Path

    • Work Item Type

    • ProjectRequired

    Trigger
    Instant
    Try It
    • Area Path

    • Work Item Type

    • Changed Field

    • ProjectRequired

    Trigger
    Instant
    Try It
    • ProjectRequired

    • TypeRequired

    • TitleRequired

    • Area

    • Iteration

    • Assigned To

    • Description

    Action
    Write
azure-devops logo
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.
Help

Related categories

  • Developer Tools
  • Microsoft

Similar apps

GitHub integrationsGitHub integrations

GitHub

Developer Tools
Jira Software Server integrationsJira Software Server integrations

Jira Software Server

Project Management
Redmine integrationsRedmine integrations

Redmine

Project Management
google-sheets logo

Related categories

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets