Sync Azure DevOps Work Items to GitHub Issues with Google Sheets Tracking — Flujo de trabajo n8n

Media complejidad🔗 Webhook12 nodos🏷️ Project Managementpor ConceptRecall

Descripción general

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

Nodos utilizados

GitHubGoogle SheetsHTTP RequestCode

Vista previa del flujo de trabajo

📌 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

Cómo funciona

1
Disparador
El flujo de trabajo comienza con un disparador webhook.
2
Procesamiento
Los datos fluyen a través de 12 nodos, connecting code, github, googlesheets.
3
Salida
El flujo de trabajo completa su automatización y entrega el resultado al destino configurado.

Detalles de nodos (12)

GitHub

github

Google Sheets

googleSheets

HTTP Request

httpRequest

Code

code

Cómo importar este flujo de trabajo

1Haz clic en el botón Descargar JSON a la derecha para guardar el archivo del flujo de trabajo.
2Abre tu instancia de n8n. Ve a Flujos de trabajo → Nuevo → Importar desde archivo.
3Selecciona el archivo sync-azure-devops-work-items-to-github-issues-with-google-sheets-tracking descargado y haz clic en Importar.
4Configura las credenciales para cada nodo de servicio (claves API, OAuth, etc.).
5Haz clic en Probar flujo de trabajo para verificar que todo funcione, luego actívalo.

O pega directamente en n8n → Importar desde JSON:

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

Integraciones

codegithubgooglesheetshttprequestwebhook

Obtener este flujo de trabajo

Descarga e importa con un solo clic

Descargar JSON Ver en n8n.io

Nodos12

Complejidadmedium

Disparadorwebhook

CategoríaProject Management

Creado por

ConceptRecall

@conceptrecallcom

Etiquetas

codegithubgooglesheetshttprequestwebhook

⚡

¿Nuevo en n8n?

n8n es una herramienta de automatización de flujos de trabajo gratuita y de código abierto. Alójala tú mismo o usa la versión en la nube.

Obtener n8n gratis →