Employee time tracking system with GPT-4o reports & Gmail notifications
Ready for 3.0What this workflow does
This AI workflow has 25 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects OpenAI and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Switch: routes items into 3 branches
- ANALYZE ENTIRE MONTH (Data table): get
- ANALYZE TIME ENTRIES (Data table): get
- Insert row (Data table): uses Data table
- Get row(s) (Data table): get
- Get row(s) (Data table): get
- Message a model (OpenAI): uses OpenAI
- Message a model (OpenAI): uses OpenAI
- MESSAGE (Edit Fields (Set)): sets 1 field: message
- If: checks a condition and branches into true / false
…plus 12 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 (9)
- Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Respond to Webhook
n8n-nodes-base.respondToWebhook - Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - Data table
n8n-nodes-base.dataTable - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail
From the author
Overview This workflow acts as an AI-powered smart time tracker for employees or personal use. It records work sessions via a webhook, logs start/end/break times into n8n Data Tables, and uses OpenAI to automatically summarize working patterns and send…