Skip to main content

Employee attendance tracker with Telegram Bot and Google Sheets

Workflow preview

Employee attendance tracker with Telegram Bot and Google Sheets preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

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