Génération et livraison automatiques de fiches de paie

Avancé

Ceci est unHRworkflow d'automatisation du domainecontenant 18 nœuds.Utilise principalement des nœuds comme Set, Code, Html, Gmail, Filter. Générer et envoyer par e-mail des fiches de paie PDF à partir de Google Sheets via Gmail

Prérequis
  • Compte Google et informations d'identification Gmail API
  • 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": "a6j2K4btAzegz8SD",
  "meta": {
    "instanceId": "c2650793f644091dc80fb900fe63448ad1f4b774008de9608064d67294f8307c",
    "templateCredsSetupCompleted": true
  },
  "name": "Automate Generate and Deliver Payslip",
  "tags": [],
  "nodes": [
    {
      "id": "c4cfd869-eec5-49c9-b866-48fa3bd39119",
      "name": "Déclencheur manuel",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -2560,
        368
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e326b4a7-be63-4ad9-ac69-96068c8db253",
      "name": "Configuration de l'entreprise",
      "type": "n8n-nodes-base.set",
      "position": [
        -2352,
        368
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "a8a21d06-1edc-400f-9c26-7373fb8da0c1",
      "name": "Récupérer les données de paie",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2128,
        368
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "da81de85-ad5b-499b-9334-c4368dcd8c28",
      "name": "Itérer sur les lignes de bulletins",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -1680,
        304
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "750961aa-cf88-4c19-b510-cfac9769be1f",
      "name": "Préparer les données du bulletin",
      "type": "n8n-nodes-base.code",
      "position": [
        -1456,
        288
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "2e0c5829-2360-43d4-a527-a2518d75ff22",
      "name": "Vérifier e-mail non envoyé",
      "type": "n8n-nodes-base.filter",
      "position": [
        -1904,
        368
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "4482e304-38a7-40e1-a826-9af818a95f67",
      "name": "Générer HTML du bulletin",
      "type": "n8n-nodes-base.html",
      "position": [
        -1232,
        288
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "53df5b3b-2bb1-4db0-a051-fd4325ded35b",
      "name": "Générer PDF du bulletin",
      "type": "n8n-nodes-puppeteer.puppeteer",
      "position": [
        -1008,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2df79e27-95c0-457e-bc29-e3e97ce20aca",
      "name": "Créer fichier PDF",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        -784,
        288
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "5f081a5d-2db0-4336-a936-9982bd41f0e0",
      "name": "Envoyer l'e-mail du bulletin",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -560,
        288
      ],
      "webhookId": "e77852a1-96a4-4a96-848d-3cd545ab8583",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "42f8dc37-3f3f-4cf9-8adc-944164ed425d",
      "name": "Marquer e-mail envoyé dans la feuille",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -352,
        288
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "28642d8e-dcff-4bac-be8d-79f61e49310c",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1936,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cb040c93-1945-4be2-a9c3-13f38ae5d5dd",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2560,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "db9843d7-7562-4554-a05c-595a4c8aeea7",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1408,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "052fe0ea-ab42-4326-8f6a-c5ada8c5d292",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fdab71ad-e026-43e6-ade7-0ea39e2dffdd",
      "name": "Note adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "79284cac-77fd-4bbc-9db8-390b26d9584f",
      "name": "Note adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2560,
        896
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "175f2dfd-c839-48b9-8ce3-d4e705eade39",
      "name": "Note adhésive6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3424,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "42dff9cd-0477-4e64-9a15-5ecbb257c8a1",
  "connections": {
    "c4cfd869-eec5-49c9-b866-48fa3bd39119": {
      "main": [
        [
          {
            "node": "e326b4a7-be63-4ad9-ac69-96068c8db253",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2df79e27-95c0-457e-bc29-e3e97ce20aca": {
      "main": [
        [
          {
            "node": "5f081a5d-2db0-4336-a936-9982bd41f0e0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a8a21d06-1edc-400f-9c26-7373fb8da0c1": {
      "main": [
        [
          {
            "node": "2e0c5829-2360-43d4-a527-a2518d75ff22",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5f081a5d-2db0-4336-a936-9982bd41f0e0": {
      "main": [
        [
          {
            "node": "42f8dc37-3f3f-4cf9-8adc-944164ed425d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2e0c5829-2360-43d4-a527-a2518d75ff22": {
      "main": [
        [
          {
            "node": "da81de85-ad5b-499b-9334-c4368dcd8c28",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "53df5b3b-2bb1-4db0-a051-fd4325ded35b": {
      "main": [
        [
          {
            "node": "2df79e27-95c0-457e-bc29-e3e97ce20aca",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "da81de85-ad5b-499b-9334-c4368dcd8c28": {
      "main": [
        [],
        [
          {
            "node": "750961aa-cf88-4c19-b510-cfac9769be1f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "750961aa-cf88-4c19-b510-cfac9769be1f": {
      "main": [
        [
          {
            "node": "4482e304-38a7-40e1-a826-9af818a95f67",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e326b4a7-be63-4ad9-ac69-96068c8db253": {
      "main": [
        [
          {
            "node": "a8a21d06-1edc-400f-9c26-7373fb8da0c1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4482e304-38a7-40e1-a826-9af818a95f67": {
      "main": [
        [
          {
            "node": "53df5b3b-2bb1-4db0-a051-fd4325ded35b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "42f8dc37-3f3f-4cf9-8adc-944164ed425d": {
      "main": [
        [
          {
            "node": "da81de85-ad5b-499b-9334-c4368dcd8c28",
            "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é ?

Avancé - Ressources Humaines

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.

Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds18
Catégorie1
Types de nœuds11
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34