Notify Redmine project members in Slack about teammates’ approved Odoo leave — n8n Workflow

High complexity⏰ Scheduled45 nodes🏷️ Project Managementby BHSoft

Overview

📌Who is this for? This workflow is designed for engineering teams, project managers, and IT operations who need consistent visibility into team availability across multiple projects. It’s perfect for organizations that use Odoo for leave management and Redmine for project collaboration, and want to ensure that everyone involved gets timely, automated Slack notifications whenever a team member will be absent the next day.

📌The problem When team members go dark, everything grinds to a halt. You'r

Nodes used

HTTP RequestSlackCode

Workflow Preview

Subflow: Get membership list of user in Redmi
- It starts when the subflow is called from the main fl
- Loop over projects to extract project members and rem
Note: Subfl
Subflow: Push message to member
- There are 3 different notifications: Time Off, Remote
Note: Need to add trigger node "When Executed by Anothe
Querying data in Odoo
- Check if there are any records of the member's leave
- If there are no records, end the flow.
- If so, proceed to the next step for filtering.
Schedule daily runs at 5:15 PM.
- Get some information about datetime, the list of user
- Add necessary variables.
Loop over item
- Read the detailed information of the records and extr
- Then get the information for that employee and their
Get user info in Redmine
- Get the information for that member on Redmine
- If there's any information, then find out which proje
- If not, return isAccountRedmi
Loop over members to check if a member has a
- If there's any information, call 'Subflow Get members
Loop over members to check if a member has a
- If you have an account, send a notification about the
Notify project members when a teammate has an
📌Who is this for?
This workflow is designed for engineering teams, projec
S
Step2: Set Variables
⚡
S
Step 1: Schedule the tri…
Step3: Get datetime
Step4: Get all user in R…
Step5: Get a list of clo…
Step7: Get the list of m…
E
End
E
End1
⚡
S
Step1: When Executed by …
S
Step3: Loop Over Items
Step4: Get membership li…
Step2: Return redmine li…
Step5: Get redmine proje…
Step6: Remove duplicate id
N
No Operation, do nothing
S
Step2: Loop Over Items
S
Step3: Wait 1s
Step6: Get many users
S
Step8: Check if there is…
Step9: Handling and get …
S
Step10: Loop Over Items
Step11: Get leave record…
Step12: Get name record
Step13: Get employee inf…
Step14: Get work_email
Step15: Get information …
Step16: Get work_email o…
Step17: Get user info in…
S
Step18: Check if there …
Step19.1: Get membership…
Step19.2: Return isAccou…
Step20: Get project IDs …
S
Step21: Merge data
S
Step22: Loop Over Items
S
Step 23: If redmine_list…
S
Step 24: Call subflow: "…
Step25: Get email Redmin…
S
Step26: Loop Over Items
S
Step 27: If redmine_list…
Step28.1: Prepare inform…
Step28.2: Prepare inform…
S
Step29: Call subflow: 'P…
S
Step4: Switch
Step5.1: Send a message …
Step5.2: Send a message …
45 nodes55 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a scheduled trigger, running on a defined schedule.

  2. 2

    Process

    Data flows through 45 nodes, connecting code, executeworkflow, executeworkflowtrigger.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (45)

HT

HTTP Request

httpRequest

#1
SL

Slack

slack

#2
CO

Code

code

#3

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded notify-redmine-project-members-in-slack-about-teammates-approved-odoo-leave file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Notify Redmine project members in Slack about teammates’ approved Odoo leave", "nodes": [...], ...}

Integrations

codeexecuteworkflowexecuteworkflowtriggerhttprequestifmergescheduletriggersetslacksplitinbatchesswitchwait

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes45
Complexityhigh
Triggerscheduled
CategoryProject Management

Created by

BHSoft

BHSoft

@bhsoft

Tags

codeexecuteworkflowexecuteworkflowtriggerhttprequestifmergescheduletriggersetslacksplitinbatches
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →