{"product_id":"n8n-workflow-outlook-timesheet-csv-project-control-excel","title":"n8n Workflow: Outlook Timesheet CSV → Project Control Excel","description":"\u003ch3\u003eTurns Outlook timesheet emails into an updated Project Control Excel workbook—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors Microsoft Outlook for unread emails with an Excel template and a timesheet CSV, then uses Microsoft OneDrive and Microsoft Graph Excel APIs to calculate person-days, deviations, and traffic-light status—finally replying to the email with the updated workbook.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every 5 minutes\u003c\/strong\u003e to fetch the latest unread Microsoft Outlook email that contains attachments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads and validates attachments\u003c\/strong\u003e: it identifies the Excel template and the timesheet CSV by filename keywords and \u003cstrong\u003efails\u003c\/strong\u003e if either file is missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads the Excel template to Microsoft OneDrive\u003c\/strong\u003e, then uses the \u003cstrong\u003eMicrosoft Graph Excel API\u003c\/strong\u003e to detect the used range and dynamically generate the required month\/name\/plan\/actual ranges.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses plan vs. actual\u003c\/strong\u003e data: it reads PLAN and existing IST values from the template, parses the CSV to aggregate hours per person per month, and converts hours to person-days (\u003cstrong\u003ehours ÷ 8\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes deviations and status\u003c\/strong\u003e for the reported month, including a monthly traffic-light indicator, and prepares cell updates (including a monthly IST sum formula).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites updates back cell-by-cell\u003c\/strong\u003e via Microsoft Graph Excel APIs, including fixing missing\/incorrect formulas.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates “Kumulgrundlage”\u003c\/strong\u003e by adding or correcting the current month’s cumulative values in an Excel workbook session.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a reply in Outlook\u003c\/strong\u003e with a text summary and the re-downloaded updated workbook from OneDrive.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProject controlling teams who receive monthly timesheets via email and need IST and cumulative (“Kumulgrundlage”) updates fast.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers streamlining month-end reporting using n8n + Microsoft 365.\u003c\/li\u003e\n  \u003cli\u003eOrganizations standardizing plan-vs-actual tracking with consistent person-day calculations and automated deviation status.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n workflow nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, and \u003cstrong\u003esplit in batches\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrates with \u003cstrong\u003eMicrosoft Outlook\u003c\/strong\u003e (unread emails with attachments), \u003cstrong\u003eMicrosoft OneDrive\u003c\/strong\u003e (template upload\/download), and \u003cstrong\u003eMicrosoft Graph Excel APIs\u003c\/strong\u003e (range detection and Excel cell updates).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172971958451,"sku":"N8N-20553","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dyZpcymg7DAA0IyEEsJ09_4tIOYXz9.png?v=1791365193","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-outlook-timesheet-csv-project-control-excel","provider":"N8N Commerce","version":"1.0","type":"link"}