Templates / Employee time tracking system with GPT-4o reports & Gmail notifications

Employee time tracking system with GPT-4o reports & Gmail notifications

Ready for 3.0

by Jose Castillo ✓ · 378 views · created 2025-10-26 · HR, AI Summarization

Ready 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 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).

  1. Switch: routes items into 3 branches
  2. ANALYZE ENTIRE MONTH (Data table): get
  3. ANALYZE TIME ENTRIES (Data table): get
  4. Insert row (Data table): uses Data table
  5. Get row(s) (Data table): get
  6. Get row(s) (Data table): get
  7. Message a model (OpenAI): uses OpenAI
  8. Message a model (OpenAI): uses OpenAI
  9. MESSAGE (Edit Fields (Set)): sets 1 field: message
  10. If: checks a condition and branches into true / false

…plus 12 more steps. See the full node list below.

Services it uses

OpenAIGmail

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)

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…

Excerpt from Jose Castillo's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.