Automated Issue Tracking from Notion to GitHub and Notifications

This n8n workflow streamlines the process of managing project tasks by connecting Notion, GitHub, and email notifications. It automatically fetches task data from a Notion database at scheduled intervals, sorts and evaluates each task’s status, and then creates GitHub issues for tasks marked ‘To develop’. For tasks already in progress or completed, it notifies the team via email, excluding bots or automated accounts. The workflow ensures efficient task tracking, better team communication, and seamless integration between project planning and development platforms.

The process begins with a schedule trigger that initiates the workflow every 12 hours. It retrieves all pages from a specified Notion database, then sorts data fields such as title, description, status, labels, and repository. Based on the status, it employs a switch node to branch the workflow:

– If a task is labeled ‘To develop’, it creates a new GitHub issue with relevant details and updates the Notion page with the issue URL and status.

– For tasks with other statuses, it fetches team members, filters out bots, groups their email addresses, and sends a notification email about the issue’s status.

This automation is highly useful for project managers and development teams seeking to automate issue tracking, reduce manual updates, and improve team communication, all within a streamlined, integrated workflow.