👥 Employee attendance tracker with Telegram Bot and Google Sheets

⚡ 1,769 views · 👥 HR & Recruitment

Description

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 (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

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. ⏰”

🔗 Nodes Used

Function Item, Google Sheets, Telegram, Telegram Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup