Telegram Attendance Tracker with n8n and Google Sheets
What A fully automated attendance tracking system where team members simply send “IN” or “OUT” messages to a Telegram group. An n8n workflow processes these messages, validates states, logs data to Google Sheets, and replies with confirmations—all without any manual intervention. Components: Telegram bot for message interface n8n workflow for automation logic Google Sheets for data storage and calculations OpenAI GPT-4o-mini (optional) for intelligent message filtering Real scenario: Your team works remotely or in office. Each person sends “IN” when they start work, “OUT” when they finish. The system automatically tracks hours, prevents errors (like double check-ins), and maintains a permanent record in Google Sheets. ...