Automatic Microsoft Outlook Attachment Storage to OneDrive with Excel Logging

This n8n workflow automates the process of saving attachments from new Microsoft Outlook emails to a specified folder in Microsoft OneDrive, and then logs the details of these attachments into a Microsoft Excel spreadsheet. This ensures that important files are automatically archived and their metadata is recorded for easy tracking and auditing.

What it does

1. Monitors for New Emails: Continuously checks your Microsoft Outlook inbox for new emails.
2. Processes Attachments: For each new email, it identifies and extracts any attached files.
3. Uploads to OneDrive: Saves each extracted attachment to a designated folder within your Microsoft OneDrive account.
4. Logs to Excel: Records key information about each saved attachment (e.g., file name, sender, date) into a specified Microsoft Excel spreadsheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Microsoft Account: A Microsoft account with access to:
  • Microsoft Outlook: For triggering on new emails.
  • Microsoft OneDrive: For storing attachments.
  • Microsoft Excel 365: For logging attachment details.
• Microsoft Credentials in n8n: Configured Microsoft credentials within n8n to connect to Outlook, OneDrive, and Excel.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Microsoft Credentials:
   • Ensure you have a Microsoft OAuth2 or API key credential set up in n8n that has permissions for Outlook, OneDrive, and Excel.
   • If not, create new Microsoft credentials and link them to the respective nodes (Microsoft Outlook Trigger, Microsoft OneDrive, Microsoft Excel 365).
3. Configure Microsoft Outlook Trigger:
   • Select the appropriate Microsoft credential.
   • Specify the mailbox or folder you want to monitor for new emails.
4. Configure Microsoft OneDrive Node:
   • Select your Microsoft credential.
   • Specify the "Operation" as "Upload File".
   • Set the "Folder ID" or "Folder Path" where you want the attachments to be saved in OneDrive.
   • Map the "File Name" and "File Content" from the incoming Outlook attachment data.
5. Configure Microsoft Excel 365 Node:
   • Select your Microsoft credential.
   • Choose the "Operation" to "Add Row" (or similar, depending on your exact logging needs).
   • Specify the "Workbook" and "Worksheet" where the data should be logged.
   • Map the relevant data fields from the Outlook attachments (e.g., {{ $json.fileName }}, {{ $json.senderEmail }}, {{ $json.receivedDateTime }}) to the corresponding columns in your Excel sheet.
6. Activate the Workflow: Once configured, activate the workflow to start monitoring for new emails and automating the attachment storage and logging.

This workflow is designed to be highly customizable. You can extend it to include additional filtering logic for specific attachments, send notifications via Microsoft Teams (as indicated by the presence of a Teams node in the JSON, though not directly connected in this basic flow), or integrate with other services as needed.