Notion Task Sync to GitHub Issues with Automated Gmail Notifications - n8n Workflow

• Project Managers & Product Owners: Who manage feature backlogs in Notion but need development tracking in GitHub.


• Development Teams (DevOps): Seeking automatic issue creation based on product planning.


• Automation Specialists: Looking for robust n8n templates integrating multiple cloud services (Notion, GitHub, Gmail).


• n8n Users: Interested in advanced flow control using the n8n node Switch and Aggregate capabilities.

Managing development lifecycle across different tools (like Notion for planning and GitHub for coding) often leads to synchronization gaps and manual data entry. This specialized n8n workflow solves this by providing a unified automation layer.

This n8n template ensures that every new feature request marked 'To develop' in Notion is instantly mirrored as a new issue in the target GitHub repository. Furthermore, when tasks are marked 'Done', the system proactively alerts the relevant team members via Gmail. Leveraging the power of the core n8n node system, this automation guarantees data integrity and timely communication, making this n8n workflow essential for efficient project execution.

This comprehensive n8n workflow operates on a scheduled basis, systematically checking for updates and routing data through two distinct paths:

1. Scheduled Check (n8n Trigger): The n8n trigger, configured as a Schedule Trigger, initiates the flow every 12 hours (configurable) to check for updates in Notion.


2. Notion Data Retrieval: The Notion n8n node fetches all pages from the designated 'Feature Tracker' database.


3. Data Structuring: A Set n8n node, named 'Sort Issues Fields', extracts key properties (Title, Description, Status, Repository) from the often complex Notion structure, preparing them for GitHub.


4. Status Routing (Switch n8n node): The flow then enters a crucial Switch n8n node that inspects the item's Status field:

1. Path A: GitHub Issue Creation: The GitHub n8n node creates a new issue using the structured data. Immediately afterward, a second Notion n8n node updates the original database page, changing the status to 'In progress' and storing the newly created GitHub issue URL.


2. Path B: Team Notification: The n8n workflow first uses a Notion n8n node to fetch all active users. It then maps their details and filters out bot accounts using an Exclude Bot Switch n8n node. An Aggregate n8n node then groups all valid email addresses. Finally, the Gmail n8n node sends a single notification to all recipients, informing them that the specified issue has been closed/completed in the target repository. This advanced use of the n8n node structure ensures accurate and consolidated alerting.

To deploy this powerful n8n workflow template, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Notion Credentials: Set up credentials for the Notion n8n node instances. You will need a Notion API token with access to the target database ('Feature Tracker').


3. GitHub Credentials: Configure OAuth2 credentials for the GitHub n8n node, ensuring the account has write access to the repositories defined in your Notion tracker.


4. Gmail Credentials: Set up OAuth2 credentials for the Gmail n8n node, allowing n8n to send emails on your behalf.


5. Configure Parameters: Double-check the configuration of the 'Get many database pages' n8n node to ensure the correct Notion Database ID is selected.


6. Activate: Once all credentials and parameters are set, toggle the n8n workflow to 'Active' to enable the Schedule n8n trigger. Your automation will now run as scheduled.

Schedule Trigger (n8n trigger): This initial n8n node periodically executes the workflow (every 12 hours) to check for updates.
Get many database pages (Notion n8n node): Fetches all items from the configured Notion database ('Feature Tracker').
Sort Issues Fields (Set n8n node): Transforms and prepares complex Notion properties into simple key-value pairs (Title, Description, Repository) for the subsequent GitHub n8n node.
Switch (n8n node): Core flow control mechanism that routes items based on the 'Status' property (e.g., 'To develop' vs. 'Done').
Create an issue (GitHub n8n node): Creates a new issue on GitHub dynamically using data mapped from the n8n workflow item.
Set Status and Issue URL (Notion n8n node): Updates the Notion database page status to 'In progress' and saves the link (html_url) returned by the GitHub n8n node.
Get many users (Notion n8n node): Retrieves a list of all users available in Notion for notification purposes.
Map Notion Users (Set n8n node): Structures the user data to isolate the Name, Email, and Type fields.
Exclude Bot (Switch n8n node): Filters the user list, ensuring only person type accounts are passed for notification, avoiding sending emails to bot addresses.
Group Recipients (Aggregate n8n node): Consolidates all individual emails into a single array for efficient sending via the Gmail n8n node.

• Send a message (Gmail n8n node): Sends the final notification email to the grouped recipients, confirming that the issue mentioned in the n8n workflow has been marked as closed/done.