Project Description:
Designed and engineered an advanced, end-to-end automation pipeline utilizing n8n to build a smart Telegram assistant capable of processing user interactions dynamically.
Key Workflow Features:
Trigger & Input Handling: Listens to incoming user messages in real-time via a Telegram Trigger.
Data Retrieval & Logging: Interacts with Google Sheets (Get row(s)) to fetch historical context or verify user data.
Custom JavaScript Processing: Implements custom JS code nodes to format payloads, manipulate JSON data, and prepare contextual inputs.
AI Integration: Connects via HTTP Request to the Google Gemini Generative AI API to generate intelligent, context-aware responses.
Automated Multi-Channel Actions: Simultaneously dispatches the AI-generated reply back to the user via Telegram (Send a text message) while appending chat session details and activity logs into Google Sheets (Append row).
Tech Stack:
n 8 n Cloud | Telegram Bot API | Google Gemini API | Google Sheets API | JavaScript