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.
⚡
W
Webhook1
HTTP Request1
Code2
HTTP Request2
⚡
W
Webhook2
Google Sheets
Google Sheets1
Create Github Issue
Filter Story Data
Filter Task Data
GitHub1
GitHub2
12 nodes10 edges

작동 원리

  1. 1

    트리거

    워크플로는 webhook 트리거로 시작합니다.

  2. 2

    처리

    데이터가 12개의 노드를 통해 흐릅니다, connecting code, github, googlesheets.

  3. 3

    출력

    워크플로가 자동화를 완료하고 구성된 대상에 결과를 전달합니다.

노드 세부 정보 (12)

GI

GitHub

github

#1
GO

Google Sheets

googleSheets

#2
HT

HTTP Request

httpRequest

#3
CO

Code

code

#4

이 워크플로 가져오는 방법

  1. 1오른쪽의 JSON 다운로드 버튼을 클릭하여 워크플로 파일을 저장합니다.
  2. 2n8n 인스턴스를 열고 워크플로 → 새로 만들기 → 파일에서 가져오기로 이동합니다.
  3. 3다운로드된 sync-azure-devops-work-items-to-github-issues-with-google-sheets-tracking 파일을 선택하고 가져오기를 클릭합니다.
  4. 4각 서비스 노드에 대한 자격 증명（API 키, OAuth 등）을 설정합니다.
  5. 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

ConceptRecall

@conceptrecallcom

태그

codegithubgooglesheetshttprequestwebhook
⚡

n8n을 처음 사용하시나요?

n8n은 무료 오픈소스 워크플로 자동화 도구입니다. 자체 호스팅하거나 클라우드 버전을 사용하세요.

n8n 무료로 시작하기 →