Automate NGO aid request management with Telegram, GPT-4, and Google Sheets

NGO TPM Request Management System

Benefits

For Beneficiaries: - 24/7 Accessibility - Submit requests anytime via familiar Telegram interface - Language Flexibility - Communicate in Arabic through text or voice messages - Instant Acknowledgment - Receive immediate confirmation that requests are logged - No Technical Barriers - Works on basic smartphones without special apps

For TPM Teams: - Centralized Tracking - All requests automatically logged with timestamps and user details - Smart Prioritization - AI categorizes issues by urgency and type for efficient response - Action Guidance - Specific recommended actions generated for each request type - Performance Analytics - Track response patterns and common issues over time

For NGO Operations: - Cost Reduction - Automated intake reduces manual processing overhead - Data Quality - Standardized categorization ensures consistent reporting - Audit Trail - Complete record of all beneficiary interactions for compliance - Scalability - Handle high volumes without proportional staff increases

How it Works

1. Multi-Input Reception - Accepts both text messages and voice recordings via Telegram 2. Voice Transcription - Uses OpenAI Whisper to convert Arabic voice messages to text 3. AI Categorization - GPT-4 analyzes requests and categorizes issues (aid distribution, logistics, etc.) 4. Action Planning - AI generates specific recommended actions for TPM team in Arabic 5. Data Logging - Records all requests, categories, and actions in Google Sheets with user details 6. Confirmation Feedback - Sends acknowledgment message back to users via Telegram

Set up Steps