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
