Real Life Login System with Caching

How it works

• Telegram Authentication: Listens for incoming messages via a Telegram bot and uses each user’s chat ID as a unique identifier.
• User Lookup & Registration: Checks Google Sheets for the user. If not found, generates a new user ID and registers them.
• Session Management: Caches active sessions in Redis for fast lookup and login-state handling.
• User Data Management: Stores/retrieves user details (e.g., UserID, Name, Telegram Chat ID) in Google Sheets.
• Workflow Integration: Can be triggered by other n8n workflows to fetch or update user/session data as needed.

Set up steps

• Setup required:
  • Telegram Bot token (configured in n8n)
  • Google Sheets with a “Users” sheet & corresponding API credentials
  • Redis instance (local or cloud) for session caching
• Approximate setup time: 30–45 minutes for importing the workflow, standing up/configuring Redis, and wiring up all API credentials.
• Details: Exact credential setups, Google Sheet field mappings, and node configurations are documented in sticky notes inside the workflow.