Sync Azure DevOps Work Items to GitHub Issues with Google Sheets Tracking

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

Managing projects across multiple platforms often leads to missed updates and poor traceability.

Stories created in Azure DevOps may not be tracked properly in GitHub.
Tasks under Stories often lose visibility when teams split between platforms.
Manual syncing between tools takes time and causes human errors.

This workflow solves that problem by automating the sync between Azure DevOps Stories and GitHub Issues, while also keeping a Google Sheets record for cross-referencing and reporting.

What this workflow does

Triggers from Azure DevOps Stories -- When a Story is created or updated, the workflow is activated.
Creates a GitHub Issue -- A new issue is generated in the specified GitHub repository.
Assigns a random collaborator -- One repository collaborator is randomly assigned to the issue.
Logs mapping in Google Sheets -- The Azure DevOps Story ID, GitHub Issue number, and URL are stored for tracking.
Triggers from Azure DevOps Tasks -- When a Task linked to a Story is created, the workflow looks up its parent in Google Sheets.
Updates the GitHub Issue -- The parent GitHub Issue is updated with a clickable link to the new Task for better visibility.

Setup

Connect your accounts

GitHub (OAuth2 or personal token)
Google Sheets (OAuth2)
Azure DevOps (Webhook integration)

Configure Webhooks

Add the workflow's webhook URLs to Azure DevOps service hooks for Work Item Created/Updated events.

Update repository details

Set the GitHub repository where issues should be created.

Customize Sheets

Use the provided Google Sheet or link your own for issue mappings.

How to customize this workflow to your needs

Modify assignment logic**: Instead of random collaborator assignment, edit the Code node to assign issues based on workload or labels.
Change Sheet schema**: Add more fields (e.g., State, IterationPath) to your Google Sheet for richer reporting.
Expand task linking**: Customize the way Tasks are appended to GitHub issues (e.g., group by state, show due dates).

Powered By Concept Recall

https://conceptrecall.com