Migrating n8n from SQLite to PostgreSQL

What The n8n instance on our production server stopped processing work. One workflow, a telemetry collector that receives a stream of concurrent webhook calls, had overloaded the database and taken the whole instance down with it. The numbers when we looked: 300+ executions stuck in running state 346 executions in new state that never started 161 executions failed with LockAcquireTimeoutError The UI was slow enough to be unusable The error behind all of it: ...

June 8, 2026 · 5 min · 985 words · Sagar Nayak

Telegram Attendance Tracker with n8n and 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. ...

November 23, 2025 · 13 min · 2698 words · Sagar Nayak