Automatisation de la paie et système de notification des salaires aux employés

Intermédiaire

Ceci est unHR, AI Summarizationworkflow d'automatisation du domainecontenant 14 nœuds.Utilise principalement des nœuds comme Code, Slack, EmailSend, HttpRequest, GoogleSheets. Automatiser le traitement des paies via GPT-4, Google Sheets, fiches de paie PDF et rappels Slack

Prérequis
  • Token Bot Slack ou URL Webhook
  • Peut nécessiter les informations d'identification d'authentification de l'API cible
  • Informations d'identification Google Sheets API
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "id": "DxYWzfjdkoT4gsJP",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "Payroll Automation & Employee Salary Notification System for Finance",
  "tags": [],
  "nodes": [
    {
      "id": "3cb9d411-385c-4aba-889a-dfc0739b4f17",
      "name": "Déclencheur mensuel de paie",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1296,
        96
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "monthDays"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "39234bd7-8085-40fc-859a-6f33b7e04299",
      "name": "Obtenir les données des employés",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1088,
        96
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Employees"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_EMPLOYEE_SPREADSHEET_ID"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "c4944ba0-64d6-45eb-b1bd-8cd715be4906",
      "name": "Calcul du salaire par IA",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -896,
        96
      ],
      "parameters": {
        "url": "https://api.openai.com/v1/chat/completions",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "model",
              "value": "gpt-4"
            },
            {
              "name": "messages",
              "value": "=[{\"role\":\"system\",\"content\":\"Calculate net salary with deductions (tax, insurance, provident fund). Return JSON format.\"},{\"role\":\"user\",\"content\":\"Employee: {{$json.Name}}, Base Salary: {{$json.BaseSalary}}, Allowances: {{$json.Allowances}}, Deductions: {{$json.Deductions}}\"}]"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "b940216a-b05d-4614-baa4-6c066d74ba0d",
      "name": "Formater les données du bulletin",
      "type": "n8n-nodes-base.code",
      "position": [
        -688,
        96
      ],
      "parameters": {
        "jsCode": "const response = JSON.parse($input.item.json.choices[0].message.content);\nconst employee = $input.first().json;\n\nreturn {\n  employeeName: employee.Name,\n  employeeEmail: employee.Email,\n  employeeId: employee.EmployeeId,\n  baseSalary: employee.BaseSalary,\n  allowances: employee.Allowances || 0,\n  deductions: response.totalDeductions || 0,\n  netSalary: response.netSalary,\n  taxDeducted: response.tax || 0,\n  month: $now.format('MMMM YYYY'),\n  paymentDate: $now.format('YYYY-MM-DD')\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "4631a9fd-8c74-4c37-8bd8-41ed04ad4a09",
      "name": "Journaliser dans la feuille de paie",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -496,
        -16
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Payroll"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_PAYROLL_SPREADSHEET_ID"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "3f324479-109f-4ac7-93ae-0280449bfee3",
      "name": "Générer un bulletin de salaire PDF",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -496,
        192
      ],
      "parameters": {
        "url": "https://api.pdfmonkey.io/api/v1/documents",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "document",
              "value": "={\"template_id\":\"YOUR_TEMPLATE_ID\",\"payload\":{\"name\":\"{{$json.employeeName}}\",\"employee_id\":\"{{$json.employeeId}}\",\"month\":\"{{$json.month}}\",\"base_salary\":{{$json.baseSalary}},\"allowances\":{{$json.allowances}},\"deductions\":{{$json.deductions}},\"net_salary\":{{$json.netSalary}}}}"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "9f4d32d1-27f7-46c7-b365-635880f02edb",
      "name": "Envoyer le bulletin par email à l'employé",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -288,
        96
      ],
      "webhookId": "fe11436a-b668-4150-83cb-aa5d8383b7c8",
      "parameters": {
        "options": {
          "attachments": "payslip_{{$json.employeeId}}_{{$json.month}}.pdf"
        },
        "subject": "=💰 Salary Credited - {{$json.month}}",
        "toEmail": "={{$json.employeeEmail}}",
        "fromEmail": "payroll@yourcompany.com"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "e00da244-b83e-4dda-af10-1a3324efd26b",
      "name": "Notifier les RH sur Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        -96,
        96
      ],
      "webhookId": "bb2bbe41-bb2d-44e3-bba1-8f66f1890895",
      "parameters": {
        "text": "=✅ *Payroll Processed*\n\n*Employee:* {{$json.employeeName}} ({{$json.employeeId}})\n*Month:* {{$json.month}}\n*Net Salary:* ₹{{$json.netSalary}}\n*Status:* Payment notification sent",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "select": "user",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "MQ0fgwuS8AzfwFvy",
          "name": "Slack account - test "
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "4d930483-8b0c-4a0c-a2f4-a7b0ff078e42",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1328,
        -112
      ],
      "parameters": {
        "color": 3,
        "width": 164,
        "height": 388,
        "content": "## Runs monthly on 28th\n\nAutomated payroll trigger"
      },
      "typeVersion": 1
    },
    {
      "id": "17061c8c-052e-4ca4-8127-d04b2e58c8bb",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        -112
      ],
      "parameters": {
        "color": 4,
        "width": 164,
        "height": 388,
        "content": "## Fetches employee data\n\nRetrieves salary info from sheet"
      },
      "typeVersion": 1
    },
    {
      "id": "3a70d888-a681-4e60-a3af-c584d14a717c",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -944,
        -112
      ],
      "parameters": {
        "color": 2,
        "width": 180,
        "height": 388,
        "content": "## AI calculates net salary\n\nApplies tax & deductions"
      },
      "typeVersion": 1
    },
    {
      "id": "274935a9-a136-491a-8414-929f4a1a5923",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -736,
        -112
      ],
      "parameters": {
        "color": 6,
        "width": 180,
        "height": 388,
        "content": "## Structures payslip data\n\nPrepares for distribution"
      },
      "typeVersion": 1
    },
    {
      "id": "ac826f4e-5b65-4ec9-a825-11158a001151",
      "name": "Note adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        -208
      ],
      "parameters": {
        "width": 196,
        "height": 580,
        "content": "## Records & generates docs\n\nLogs payroll + creates PDF"
      },
      "typeVersion": 1
    },
    {
      "id": "7671884f-e6bc-4355-96fd-da5c65b17ff6",
      "name": "Note adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        -112
      ],
      "parameters": {
        "color": 5,
        "width": 356,
        "height": 452,
        "content": "## Multi-channel notification\n\nEmployee email + HR Slack alert"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "98d132d3-d691-4de4-a19e-0d1f5b3dfeb0",
  "connections": {
    "39234bd7-8085-40fc-859a-6f33b7e04299": {
      "main": [
        [
          {
            "node": "c4944ba0-64d6-45eb-b1bd-8cd715be4906",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c4944ba0-64d6-45eb-b1bd-8cd715be4906": {
      "main": [
        [
          {
            "node": "b940216a-b05d-4614-baa4-6c066d74ba0d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b940216a-b05d-4614-baa4-6c066d74ba0d": {
      "main": [
        [
          {
            "node": "4631a9fd-8c74-4c37-8bd8-41ed04ad4a09",
            "type": "main",
            "index": 0
          },
          {
            "node": "3f324479-109f-4ac7-93ae-0280449bfee3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3f324479-109f-4ac7-93ae-0280449bfee3": {
      "main": [
        [
          {
            "node": "9f4d32d1-27f7-46c7-b365-635880f02edb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4631a9fd-8c74-4c37-8bd8-41ed04ad4a09": {
      "main": [
        [
          {
            "node": "9f4d32d1-27f7-46c7-b365-635880f02edb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3cb9d411-385c-4aba-889a-dfc0739b4f17": {
      "main": [
        [
          {
            "node": "39234bd7-8085-40fc-859a-6f33b7e04299",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9f4d32d1-27f7-46c7-b365-635880f02edb": {
      "main": [
        [
          {
            "node": "e00da244-b83e-4dda-af10-1a3324efd26b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Ressources Humaines, Résumé IA

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Planification et rappels des évaluations de performance
Utiliser Google Sheets, Agenda, e-mail et Slack pour automatiser le processus d'évaluation des performances
If
Set
Code
+
If
Set
Code
16 NœudsOneclick AI Squad
Ressources Humaines
Système de filtrage et de planification d'entretiens pour les candidats par IA
Sélection des candidats et planification des entretiens basées sur l'IA (OpenAI GPT et Google Workspace)
If
Code
Webhook
+
If
Code
Webhook
18 NœudsOneclick AI Squad
Ressources Humaines
Rapports quotidiens automatisés de flux de trésorerie et de dépenses pour professionnels de la finance
Générer un rapport de flux de trésorerie quotidien pour l'équipe financière avec Google Sheets, Slack et e-mail
Code
Merge
Slack
+
Code
Merge
Slack
25 NœudsOneclick AI Squad
Extraction de documents
Réapprovisionnement intelligent des stocks et commandes d'achat automatiques
Gestion des stocks pilotée par l'IA, basée sur les prévisions d'OpenAI et l'intégration ERP
Code
Filter
Postgres
+
Code
Filter
Postgres
24 NœudsOneclick AI Squad
Extraction de documents
Automatisation de la conformité des livrables et des contrats pour les influenceurs Instagram
Automatiser la conformité des contrats d'influenceurs Instagram avec Claude AI et des rappels Slack
If
Set
Code
+
If
Set
Code
26 NœudsOneclick AI Squad
Réseaux sociaux
Automatisation du tri des CV et de la vérification des candidats avec l'IA et l'analyse d'e-mails
Automatisation du criblage de CVs et de la vérification des candidats avec l'IA et l'analyse d'e-mails
If
Code
Wait
+
If
Code
Wait
14 NœudsOneclick AI Squad
Ressources Humaines
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds14
Catégorie2
Types de nœuds7
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34