Back to Templates

Telegram AI assistant with rate limiting and auto-reset using Google Sheets

Created by

Created by: Oussama || oussama
Oussama

Last update

Last update 4 months ago

Categories

Share


Production-ready solution for controlling AI agent usage and preventing abuse while managing costs.

๐ŸŽฏ Problem Solved

Unlimited AI interactions โ†’ Excessive API costs
Service abuse โ†’ Uncontrolled resource consumption
No built-in limits โ†’ Need for usage quotas

โœ… Solution Overview

Two-Part System:

Main Flow: User interaction tracking + AI responses
Reset Flow: Automated counter resets

๐Ÿ”„ How It Works

User Message โ†’ Track Counter โ†’ Check Limit โ†’ Allow/Block โ†’ AI Response

๐Ÿ› ๏ธ Core Components

Main Workflow

๐Ÿ“ฑ Telegram Trigger - Receives user messages
๐Ÿ“Š Google Sheets Counter - Tracks messages per user
๐Ÿ”€ Switch Logic - Checks limits (default: 3 messages)
๐Ÿค– AI Agent - Processes allowed interactions
๐Ÿ’ฌ Smart Responses - Delivers AI answers or limit warnings

Auto-Reset System

โฐ Schedule Trigger - Runs every configurable interval
๐Ÿ”„ Bulk Counter Reset - Resets all users to 0

โš™๏ธ Configuration

Message Limits
Modify Switch Node conditions:

3 messages โ†’ Block silently
= 3 messages โ†’ Send limit warning
< 3 messages โ†’ Allow AI response

Reset Schedules

Testing: Every 1 minute
Hourly: 0 * * * *
Daily: 0 0 * * *
Weekly: 0 0 * * 0

๐Ÿ“‹ Setup Requirements

Credentials Needed:

๐Ÿค– Telegram Bot Token
๐Ÿ“Š Google Sheets API
๐Ÿง  AI Model

*Google Sheets Structure:
*Column A: User ID (Telegram chat.id)
Column B: Message Counter

๐ŸŽฏ Perfect For

๐Ÿ’ฐ Cost Control - Prevent runaway API costs
๐Ÿ›ก๏ธ Demo/Trial Bots - Limited interactions
๐Ÿข Customer Service - Usage quotas
๐ŸŽ“ Educational Bots - Daily limits
๐Ÿšซ Anti-Abuse - Fair usage policies

๐Ÿš€ Key Benefits
โœ… Cost Management - Control AI API expenses
โœ… Fair Access - Equal usage for all users
โœ… Production Ready - Robust error handling
โœ… Flexible Limits - Easy adjustment
โœ… Auto-Reset - No manual intervention
โœ… User-Friendly - Clear limit messages

๐Ÿ“ Quick Customization

Adjust Limits: Change Switch node values
Reset Timing: Modify Schedule Trigger
Custom Messages: Edit Telegram response nodes
User Tiers: Add columns to Google Sheets