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
- Download and import
Attendance Telegram App.json
into n8n.
- Configure your Telegram API credentials.
- Configure your Google Sheets credentials.
2. Use Provided Google Sheets Template
We provide a template with two sheets:
- Employee → List of registered employees (
id_employee
, full_name
, username_telegram
)
- Attendance → Attendance logs (
date
, time
, attendance_type
, etc.)
👉 Copy the Google Sheets Template
Update the Employee sheet with your employee data before running the workflow.
3. Configure Telegram Bot
- Create a bot with BotFather on Telegram.
- Copy the API token.
- 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
- User types
/menu
in Telegram.
- Bot displays menu with Check-in/Check-out and Today’s Attendance Status.
- 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. ⏰”