Automatische Erstellung und Lieferung von Gehaltsabrechnungen

Experte

Dies ist ein HR-Bereich Automatisierungsworkflow mit 18 Nodes. Hauptsächlich werden Set, Code, Html, Gmail, Filter und andere Nodes verwendet. Generieren und E-Mail-Versand von Gehaltsabrechnungen im PDF-Format aus Google Sheets über Gmail

Voraussetzungen
  • Google-Konto + Gmail API-Anmeldedaten
  • Google Sheets API-Anmeldedaten

Kategorie

Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "id": "a6j2K4btAzegz8SD",
  "meta": {
    "instanceId": "c2650793f644091dc80fb900fe63448ad1f4b774008de9608064d67294f8307c",
    "templateCredsSetupCompleted": true
  },
  "name": "Automate Generate and Deliver Payslip",
  "tags": [],
  "nodes": [
    {
      "id": "c4cfd869-eec5-49c9-b866-48fa3bd39119",
      "name": "Manueller Auslöser",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -2560,
        368
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e326b4a7-be63-4ad9-ac69-96068c8db253",
      "name": "Unternehmenskonfiguration",
      "type": "n8n-nodes-base.set",
      "position": [
        -2352,
        368
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "a8a21d06-1edc-400f-9c26-7373fb8da0c1",
      "name": "Gehaltsdaten abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2128,
        368
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "da81de85-ad5b-499b-9334-c4368dcd8c28",
      "name": "Gehaltsabrechnungszeilen durchlaufen",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -1680,
        304
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "750961aa-cf88-4c19-b510-cfac9769be1f",
      "name": "Gehaltsabrechnungsdaten vorbereiten",
      "type": "n8n-nodes-base.code",
      "position": [
        -1456,
        288
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "2e0c5829-2360-43d4-a527-a2518d75ff22",
      "name": "E-Mail-Nichtversand prüfen",
      "type": "n8n-nodes-base.filter",
      "position": [
        -1904,
        368
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "4482e304-38a7-40e1-a826-9af818a95f67",
      "name": "Gehaltsabrechnungs-HTML generieren",
      "type": "n8n-nodes-base.html",
      "position": [
        -1232,
        288
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "53df5b3b-2bb1-4db0-a051-fd4325ded35b",
      "name": "Gehaltsabrechnungs-PDF generieren",
      "type": "n8n-nodes-puppeteer.puppeteer",
      "position": [
        -1008,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2df79e27-95c0-457e-bc29-e3e97ce20aca",
      "name": "PDF-Datei erstellen",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        -784,
        288
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "5f081a5d-2db0-4336-a936-9982bd41f0e0",
      "name": "Gehaltsabrechnung per E-Mail senden",
      "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": "E-Mail-Versand in Tabelle markieren",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -352,
        288
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "28642d8e-dcff-4bac-be8d-79f61e49310c",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1936,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cb040c93-1945-4be2-a9c3-13f38ae5d5dd",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2560,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "db9843d7-7562-4554-a05c-595a4c8aeea7",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1408,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "052fe0ea-ab42-4326-8f6a-c5ada8c5d292",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fdab71ad-e026-43e6-ade7-0ea39e2dffdd",
      "name": "Haftnotiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "79284cac-77fd-4bbc-9db8-390b26d9584f",
      "name": "Haftnotiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2560,
        896
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "175f2dfd-c839-48b9-8ce3-d4e705eade39",
      "name": "Haftnotiz6",
      "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
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Experte - Personalwesen

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes18
Kategorie1
Node-Typen11
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34