Microsoft OneDrive and Microsoft Outlook integration

Outlook to OneDrive This workflow automates the process of saving binary attachments from Outlook emails into newly created folders in OneDrive. It's ideal for users who regularly receive files and need them organized into separate folders without manual intervention. Each folder is automatically named based on the email subject and the current timestamp, allowing all attachments from that email to be stored inside the corresponding folder. This is particularly useful for streamlining document workflows, improving file traceability, and reducing the time spent on repetitive tasks like organizing client submissions, invoices, or internal reports. The configuration and setup of the workflow can be customized to meet the business or personal needs of the user. Its purpose is to automatically process binary attachments from Outlook emails and upload them to dynamically created folders in OneDrive. Overview Microsoft Outlook Trigger – Monitors your inbox for new emails. Filter – Ensures only emails with binary attachments proceed. Get Outlook Message – Retrieves the full email and downloads attachments. Create Folder – Makes a new folder in OneDrive based on the email subject and time. Split Out – Extracts each binary attachment. Merge– Combines folder and file data before upload. Upload File OneDrive – Uploads each binary file into the new folder. Need Help? Have Questions? For consulting and support, or if you have questions, please feel free to connect with me on LinkedIn or via email.

Conference Feedback Collection and OneDrive Logging Workflow This n8n workflow is designed to collect feedback through a web form, log the responses into an Excel file stored in Microsoft OneDrive, and notify the support team via email. 🧭 Overall Goal To collect user feedback from a web form, structure the data, log it into a OneDrive Excel file, and notify support via Outlook email. 🔄 Workflow Breakdown Form Submission (On form submission) Node Type**: formTrigger Purpose**: Captures user feedback via a web form. Form Fields**: Full Name (Required) Email (Required) Company Name Job Title How did you hear about the conference? (Required) Overall experience rating (Required) Favorite sessions/speakers Relevance to interests/work (Required) Networking opportunities (Required) Suggestions for improvement Future topics/speakers Willingness to attend again (Required) Additional comments Contact permission (Required) Access URL**: /webhook/feedback (or /webhook-test/feedback during testing) Parse Data (Set) Purpose**: Renames form fields to snake_case. Output**: Structured JSON with renamed fields. Sample File (Convert to File) Purpose**: Generates a file name reference for search. Filename**: test-n8n-feedback-form-data.xlsx Search Document (Microsoft OneDrive) Purpose**: Searches OneDrive for the specified Excel file. Query**: test-n8n-feedback-form-data.xlsx Extract File ID (Code) Purpose**: Extracts the ID of the file from the search result. Output**: { "id": "someFileId" } or { "id": null } Check File Existence (If) Purpose**: Branch logic based on file existence. Condition**: If id exists. Build Sheet Data (Set) Purpose**: Prepares the data to match the Excel column headers. Only Runs If**: File was found. Append Data to Excel (Microsoft Excel) Purpose**: Appends the new feedback as a row. Workbook ID**: {{ $('Code').item.json.id }} Worksheet Name**: Sheet1 Mode**: Auto-map from input fields Notify Support (Microsoft Outlook) Purpose**: Sends a notification email with key feedback details. To**: [email protected] Subject**: "New Feedback Submission Received" Body**: Includes key details from submission End Workflow (NoOp) Purpose**: Marks logical end of the workflow. 📝 Sticky Notes ✅ Upload Target Excel File First: Ensure the Excel file exists in OneDrive. 📝 Filename Consistency: Filename should match in "Sample File" and "Search Document" nodes. 📧 Customize Email Content: Update "Notify Support" node with your desired message and recipient. 🔧 Customization Guide 🧾 Form Customization Change form title, description, fields, or path. 🧪 Parsing Logic Update field mappings if form labels change. 📁 Excel File Settings Filename must match your actual OneDrive file. Worksheet name and column headers must match in "Build Sheet Data". 📬 Email Settings Update subject and body using variables like {{ $('Parse Data').item.json.full_name }}. ❗ Error Handling Tips Adjust email content based on file presence. Add an "Error Trigger" for advanced error management. 🔁 Alternatives and Extensions Use Google Sheets, Airtable, or databases instead of OneDrive/Excel. Add Slack or SMS notifications. 📌 Use Cases Post-event Feedback CSAT Surveys Employee Feedback Bug Reporting Lead Capture Contact Forms Webinar Registration 🔐 Required Credentials Microsoft OneDrive (OAuth2) Used by**: "Search Document" Credential Name**: Microsoft Drive account Microsoft Excel (OAuth2) Used by**: "Append Data" Credential Name**: Microsoft Excel account Microsoft Outlook (OAuth2) Used by**: "Notify Support" Credential Name**: Outlook 0Auth2 ❤️ Made with n8n by Akhil

Automatically BackUp Your n8n Workflows to OneDrive This workflow automates the backup of your self-hosted n8n instance by exporting all workflows and saving them as individual .json files to a designated OneDrive folder. Each file is timestamped for easy versioning and audit tracking. After a successful backup, the workflow optionally cleans up old backup files and sends a confirmation email to notify you that the process completed. How it works Uses the HTTP Request node to fetch all workflows via the /rest/workflows API. Iterates through each workflow using SplitInBatches. Converts each workflow to a .json file using Set and Function nodes. Uploads each file to a target Microsoft OneDrive folder using OAuth2. Deletes old backup files from OneDrive after upload, with the option to keep backups for a configurable number of time. Sends an email notification once all backups have completed successfully. Setup instructions Enter your n8n Base URL and authentication details in the HTTP Request node. Set up Microsoft OneDrive OAuth2 credentials for cloud upload. Configure the Email node with SMTP credentials to receive backup confirmation. (Optional) Adjust the file retention logic to keep backups for a set duration. A Cron trigger to schedule the workflow automatically (e.g., daily or weekly). 👉 Sticky notes inside the workflow explain each step for easy setup. Need Help Need Help 🔗 LinkedIn – Wessel Bulte

📥 Save Email Attachments to OneDrive & Log Them in Excel This workflow watches your Outlook inbox, automatically downloads file attachments (for example invoices), saves them into a specific OneDrive folder, and logs each file name into an Excel table. Optionally, it also posts a Microsoft Teams message to let you know that a new attachment has been processed. ✨ What this workflow does Monitors a Microsoft Outlook mailbox for new emails. Fetches all attachments from each incoming message. Processes attachments one by one so every file is handled cleanly. Downloads each attachment as binary data. Uploads the file into a OneDrive folder (looked up by name). Appends a new row with the filename to an Excel table for tracking. Sends a Teams chat notification once an attachment has been uploaded (optional). 🧑‍💼 Who this is for This workflow is ideal for: Finance / accounting teams who receive invoices by email and want them stored centrally. Anyone who wants an “email → OneDrive → Excel log” pipeline without manual downloading and renaming. n8n users who work in a Microsoft 365 environment (Outlook, OneDrive, Excel, Teams). ✅ Requirements Before you run the workflow, you’ll need: A Microsoft Outlook account with permissions to read emails and attachments. A OneDrive / SharePoint drive with a target folder (the example uses a folder whose name matches the search in the Get Folder ID node, e.g. Testn8n). An Excel workbook stored in OneDrive with: A worksheet and table already created. A column named Filename (or adjust the Set Filename + Excel node to match your column name). n8n credentials set up for: Microsoft Outlook Microsoft OneDrive Microsoft Excel Microsoft Teams (optional but used in this template) 🛠️ Setup steps Import the workflow JSON into your n8n instance. Configure credentials: Set your Outlook, OneDrive, Excel, and Teams credentials on the respective nodes. Adjust the mail trigger (On Mail Received): Optionally add filters (subject, sender, folder) if you only want to process invoices or a specific mailbox/folder. Set the OneDrive folder search (Get Folder ID): Update the query parameter to the exact name of the folder where attachments should be stored. Point the Excel node to your workbook (Append to Excel Log): Use the dropdowns to select your workbook, worksheet and table. Ensure there’s a Filename column (or rename the field in Set Filename to match your actual column). Activate the workflow: Once active, every new email that hits the trigger will have its attachments stored in OneDrive and logged in Excel. 🔗 Integrations used Microsoft Outlook** – trigger on incoming emails and download attachments. Microsoft OneDrive** – search for folders and upload files. Microsoft Excel** – append rows to a table in a workbook. Microsoft Teams** – send notifications when attachments are processed.