Update project controlling Excel from timesheet CSV emails with Outlook and OneDrive
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 32 nodes and runs on a schedule (every minute). Along the way it connects Microsoft Outlook.
How it runs
Trigger: On a schedule (every minute).
- Get many messages (Microsoft Outlook): get many
- Identify Attachments (Code): runs custom JavaScript code
- Extract Acuaul Values "IST" (Extract from File): extracts data from a file
- Upload the template to OneDrive (HTTP Request): calls an HTTP API (PUT)
- Aggregate IST (hours → PD) (Code): runs custom JavaScript code
- Find the last line (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Generate Ranges Dynamically (Code): runs custom JavaScript code
- Calculate deviations (Code): runs custom JavaScript code
- Retrieve batch ranges (HTTP Request): calls an HTTP API
…plus 21 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Extract from File
n8n-nodes-base.extractFromFile - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Quick overview This workflow checks Microsoft Outlook for unread emails with a project controlling Excel template and a timesheet CSV, uploads the template to OneDrive, fills in actual person-days and deviations via Microsoft Graph Excel APIs, updates a…