Outlook Binary

Name: Outlook Binary
Rating: 4.5 (10 reviews)
Author: Michael Gullo

Fortgeschritten

Dies ist ein File Management-Bereich Automatisierungsworkflow mit 9 Nodes. Hauptsächlich werden Merge, Filter, SplitOut, MicrosoftOutlook, MicrosoftOneDrive und andere Nodes verwendet. Automatisches Speichern und Ordnen von Outlook-E-Mail-Anhängen in einem OneDrive-Ordner

Voraussetzungen

•Keine besonderen Voraussetzungen, sofort nach Import nutzbar

Verwendete Nodes (9)

MicrosoftOutlookTrigger

Kategorie

Dateiverwaltung

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Microsoft Outlook Trigger

Filter

Split Out

Ordner erstellen

Outlook-Ordner zusammenführen

Outlook-Nachricht abrufen

Datei in OneDrive hochladen

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "3YN2Xyb63UfYpJli",
  "meta": {
    "instanceId": "6304e8877aa0fde3913b14034debe07006963fb497d63f280a91bbd75c6c24e1"
  },
  "name": "Outlook Binary",
  "tags": [],
  "nodes": [
    {
      "id": "aeffad3e-df80-4ccb-98ef-2eb981f62746",
      "name": "Microsoft Outlook Trigger",
      "type": "n8n-nodes-base.microsoftOutlookTrigger",
      "position": [
        180,
        620
      ],
      "parameters": {
        "filters": {},
        "options": {
          "downloadAttachments": true
        },
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "a3ba729f-52d8-4a77-b18b-4b86d3afaf6b",
      "name": "Filter",
      "type": "n8n-nodes-base.filter",
      "position": [
        400,
        620
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "ec1e823d-871a-4d1a-a120-b2f5a46523a0",
              "operator": {
                "type": "object",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $('Microsoft Outlook Trigger').item.binary}}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "20007221-e907-4ab0-bcd8-0080cf2775e8",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        840,
        740
      ],
      "parameters": {
        "options": {
          "includeBinary": true
        },
        "fieldToSplitOut": "$binary"
      },
      "typeVersion": 1
    },
    {
      "id": "65205775-2cea-4186-b5b2-030579e6261e",
      "name": "Ordner erstellen",
      "type": "n8n-nodes-base.microsoftOneDrive",
      "position": [
        840,
        480
      ],
      "parameters": {
        "name": "={{ $node[\"Microsoft Outlook Trigger\"].json.subject || \"Untitled\" }} - {{ $now }}",
        "options": {},
        "resource": "folder",
        "operation": "create"
      },
      "typeVersion": 1
    },
    {
      "id": "366d28a1-1761-4e43-a6cf-41de541d7789",
      "name": "Outlook-Ordner zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        1140,
        620
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.1
    },
    {
      "id": "e80a7a0c-72ff-4986-9a56-c4f31873e3ac",
      "name": "Kurznotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        420
      ],
      "parameters": {
        "color": 5,
        "width": 1860,
        "height": 520,
        "content": "Outlook and Onedrive binary movement of data"
      },
      "typeVersion": 1
    },
    {
      "id": "80ef689d-6820-4fa8-8c00-7724665e9b7b",
      "name": "Kurznotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 5,
        "width": 420,
        "height": 420,
        "content": "WORKFLOW SUMMARY\n\nThis workflow is triggered every minute by new emails in Outlook. It first filters for emails that contain binary data (attachments). For such emails, it retrieves the full email content and then proceeds to create a new folder in OneDrive. Concurrently, it splits out the binary data (attachments) from the email. Finally, it merges the information about the newly created OneDrive folder with the attachment data and saves each attachment into the designated OneDrive folder."
      },
      "typeVersion": 1
    },
    {
      "id": "c53388cd-d2fe-4b6d-86b7-5129670496a4",
      "name": "Outlook-Nachricht abrufen",
      "type": "n8n-nodes-base.microsoftOutlook",
      "position": [
        620,
        620
      ],
      "webhookId": "fd255a4d-2b30-4883-af8b-b29ba5dbbe88",
      "parameters": {
        "options": {
          "downloadAttachments": true
        },
        "messageId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $node[\"Microsoft Outlook Trigger\"].json.id }}"
        },
        "operation": "get"
      },
      "typeVersion": 2
    },
    {
      "id": "02a6951c-eea8-4690-8aec-b795052ccceb",
      "name": "Datei in OneDrive hochladen",
      "type": "n8n-nodes-base.microsoftOneDrive",
      "position": [
        1460,
        620
      ],
      "parameters": {
        "fileName": "={{ $binary[$binary.keys()[0]].fileName }}",
        "parentId": "={{ $node[\"Outlook Folder Merge\"].json[\"id\"] || $node[\"Create Folder\"].json[\"id\"] }}",
        "binaryData": true,
        "binaryPropertyName": "={{ $json.binary }}"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "b0c9930e-3ea5-46ef-9b93-fe787448afcc",
  "connections": {
    "a3ba729f-52d8-4a77-b18b-4b86d3afaf6b": {
      "main": [
        [
          {
            "node": "c53388cd-d2fe-4b6d-86b7-5129670496a4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "20007221-e907-4ab0-bcd8-0080cf2775e8": {
      "main": [
        [
          {
            "node": "366d28a1-1761-4e43-a6cf-41de541d7789",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "65205775-2cea-4186-b5b2-030579e6261e": {
      "main": [
        [
          {
            "node": "366d28a1-1761-4e43-a6cf-41de541d7789",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c53388cd-d2fe-4b6d-86b7-5129670496a4": {
      "main": [
        [
          {
            "node": "65205775-2cea-4186-b5b2-030579e6261e",
            "type": "main",
            "index": 0
          },
          {
            "node": "20007221-e907-4ab0-bcd8-0080cf2775e8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "366d28a1-1761-4e43-a6cf-41de541d7789": {
      "main": [
        [
          {
            "node": "02a6951c-eea8-4690-8aec-b795052ccceb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "aeffad3e-df80-4ccb-98ef-2eb981f62746": {
      "main": [
        [
          {
            "node": "a3ba729f-52d8-4a77-b18b-4b86d3afaf6b",
            "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?

Fortgeschritten - Dateiverwaltung

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.