Employee attendance tracker with Telegram Bot and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function Item (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Function Item (legacy) Format Attendance Status | Code node, mode 'Run Once for Each Item' |
Nodes used (6)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - Aggregate
n8n-nodes-base.aggregate - Google Sheets
n8n-nodes-base.googleSheets - Function Item
n8n-nodes-base.functionItem
What it does
Attendance Telegram App with Google Sheets Manage employee attendance directly through Telegram with seamless Google Sheets integration. Employees can check in, check out, and view their daily attendance status from a Telegram bot. All records are stored in Google Sheets for easy tracking and reporting. 👉 Includes a Google Sheets template to get started quickly. --- ✨ Features - 🕘 Check-in & Check-out via Telegram bot - 📊 View daily attendance status (Check-in/Check-out done or not) - 🔒 Employee validation – only registered employees can log attendance - ⚠️ Duplicate prevention – prevents multiple check-ins/outs on the same day - 📂 Google Sheets integration – easy to manage, export, and share data --- 🛠 Requirements - n8n (Cloud or Self-hosted) - A Telegram Bot (create via BotFather) - Google Sheets account --- 🚀 Setup Instructions 1. Import Workflow 1. Download and import Attendance Telegram App.json into n8n. 2. Configure your Telegram API credentials. 3. Configure your Google Sheets credentials. 2. Use Provided Google Sheets Template We provide a template with two sheets: - Employee → List of registered employees (idemployee, fullname, usernametelegram) - Attendance → Attendance logs (date, time, attendancetype, etc.) 👉 Copy the Google Sheets Template Update the Employee sheet with your employee data before running the workflow. 3. Configure Telegram Bot 1. Create a bot with BotFather on Telegram. 2. Copy the API token. 3. Add it into n8n’s Telegram credentials. 4. Run the Workflow - Start the workflow. - Open your Telegram bot and type /start or /menu. - Available options: - ✅ Check-in (⏰) - 🚪 Check-out (🏁) - 📊 View Today’s Attendance Status --- 📋 Example Flow 1. User types /menu in Telegram. 2. Bot displays menu with Check-in/Check-out and Today’s Attendance Status. 3. If user taps Check-in: - Workflow validates if they are a registered employee. - Checks if attendance already exists for today. - If valid → record in Google Sheets. - Bot replies: “Check-in recorded. ⏰” ---