Get Started
Back to Templates

Employee Attendance Tracker with Telegram Bot and Google Sheets

Created by

Created by: Singgi Aditya || singgiaditya

Singgi Aditya

Last update

Last update 2 months ago

Categories

Share

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