Google-Sheets

What An attendance tracking system where team members send “IN” or “OUT” to a Telegram group. An n8n workflow processes each message, validates the state, logs it to Google Sheets, and replies with a confirmation. No manual work involved. Components: Telegram bot for message interface n8n workflow for automation logic Google Sheets for data storage and calculations OpenAI GPT-4o-mini (optional) for intelligent message filtering Real scenario: Your team works remotely or in office. Each person sends “IN” when they start work, “OUT” when they finish. The system automatically tracks hours, prevents errors (like double check-ins), and maintains a permanent record in Google Sheets. ...