Sync Azure DevOps Work Items to GitHub Issues with Google Sheets Tracking — n8n 工作流

中复杂度🔗 Webhook12 个节点🏷️ Project Management作者：ConceptRecall

概览

Who is this for?

This workflow is designed for software teams, project managers, and developers who manage work across Azure DevOps and GitHub. It helps organizations that use Azure DevOps for work item tracking but rely on GitHub for issue management and collaboration.

If you need to ensure that your DevOps Stories and Tasks are mirrored in GitHub issues while keeping a single source of truth in Google Sheets, this workflow is for you.

What problem is this workflow solving? / Use case

Manag

使用的节点

GitHubGoogle SheetsHTTP RequestCode

工作流预览

📌 Workflow Purpose

This workflow automates the connection between Microsof

and Google Sheets to streamline project tracking.

1. When a new Story is created in Azure DevOps, a

🔔 Trigger for Azure DevOps Story events.

Receives POST requests whenever a new Story

work item is created/updated in Azure DevOps.

🧹 Cleans and structures Story data from Azur

Extracts fields like: ID, Title, Description, CreatedBy

Passes simplified object for GitHub Issue creation.

📄 Creates a new GitHub Issue in the reposito

(based on Story Title and Description from Azure DevOps

📡 Calls GitHub API to fetch repository colla

Used to determine possible assignees for the new issue.

🎲 Selects a random collaborator from the lis

of repository members and prepares the assignee value.

✏️ Updates the GitHub Issue using PATCH reque

Assigns the randomly selected collaborator.

📊 Appends mapping between Azure DevOps Story

GitHub Issue number, and Issue URL into the Google Shee

Acts as a central cross-reference.

🔔 Trigger for Azure DevOps Task events.

Receives POST requests whenever a new Task

is created/updated in Azure DevOps.

🧹 Cleans and structures Task data from Azure

Extracts Task ID, Title, Description, Parent Story ID,

and Task URL for mapping back to GitHub Issue.

🔍 Looks up the parent Story’s mapping in Goo

(using AzureID as the key) to find the corresponding

GitHub Issue ID.

📥 Retrieves details of the GitHub Issue asso

with the parent Story from the mapping found in Sheets.

➕ Updates the GitHub Issue body.

Appends a clickable Task link (with Azure DevOps Task I

as a bullet point under the parent GitHub Issue.

⚡

Webhook1

HTTP Request1

Code2

HTTP Request2

⚡

Webhook2

Google Sheets

Google Sheets1

Create Github Issue

Filter Story Data

Filter Task Data

GitHub1

GitHub2

12 nodes10 edges

工作原理

1
触发器
工作流由 webhook 触发器启动。
2
处理
数据流经 12 个节点, connecting code, github, googlesheets。
3
输出
工作流完成自动化并将结果发送到配置的目标。

节点详情 (12)

GitHub

github

Google Sheets

googleSheets

HTTP Request

httpRequest

Code

code

如何导入此工作流

1点击右侧 下载 JSON 按钮保存工作流文件。
2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
3选择下载的 sync-azure-devops-work-items-to-github-issues-with-google-sheets-tracking 文件并点击导入。
4为每个服务节点配置凭证（API 密钥、OAuth 等）。
5点击 测试工作流 验证一切正常，然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴：

{ "name": "Sync Azure DevOps Work Items to GitHub Issues with Google Sheets Tracking", "nodes": [...], ...}

集成

codegithubgooglesheetshttprequestwebhook

获取此工作流

一键下载并导入

下载 JSON 在 n8n.io 上查看

节点12

复杂度medium

触发器webhook

分类Project Management

创建者

ConceptRecall

@conceptrecallcom

n8n 新手？

n8n 是一款免费开源的工作流自动化工具，支持自托管或使用云版本。

免费获取 n8n →