Extract consultant hours from PDF timesheets with Azure OpenAI and Excel
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 AI workflow has 9 nodes and runs when a chat message arrives. Along the way it connects Microsoft Outlook, Microsoft Excel 365 and Azure OpenAI Chat Model.
How it runs
Trigger: When a chat message arrives.
- Get binaries out of chat (Code): runs custom JavaScript code
- Extract data from pdfs (Extract from File): extracts data from a file (pdf)
- Timesheet Analyzer Agent (AI Agent): runs an AI agent, with model: Companion Model
- JSON Parser (Code): runs custom JavaScript code
- Append timesheet data to sheet (Microsoft Excel 365): append (worksheet)
- Insert time recordings (Data table): uses Data table
- Send a message with excel time sheet (Microsoft Outlook): uses Microsoft Outlook
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)
- Code
n8n-nodes-base.code - Extract from File
n8n-nodes-base.extractFromFile - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Data table
n8n-nodes-base.dataTable - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi
From the author
Quick overview This workflow lets you upload one or more PDF timesheets in n8n chat, extracts the text, uses an Azure OpenAI model to total onsite/remote/unknown hours per consultant, appends the results to a Microsoft Excel workbook and an n8n Data Table,…