Automate Telegram Bot Responses with Google Sheets Schedule
detail.loadingPreview
This workflow fetches your Google Sheets schedule, converts it to Markdown, and feeds it into a Telegram bot powered by an AI language model. It enables dynamic responses to user queries about the schedule.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow is designed to create an intelligent Telegram bot that can answer questions about a schedule stored in Google Sheets. It pulls data from a specified Google Sheet, formats it into a Markdown table, and then uses this structured data as context for a Langchain agent. This agent, powered by an AI model (likely from OpenRouter), can then interpret user queries and provide relevant information based on the schedule. The workflow handles both Telegram and a simulated n8n input, allowing for flexible integration and testing.
Key Features
- Fetches schedule data from a Google Sheet using the Google Sheets node.
- Converts tabular data into a Markdown format for AI consumption.
- Integrates with a Langchain agent to provide AI-powered responses.
- Supports dynamic context based on the latest Google Sheets data.
- Handles input from both Telegram and a mock n8n trigger for testing.
- Formats and sends responses back to the user via Telegram.
How To Use
- Configure Google Sheets: Ensure your schedule is in a Google Sheet and obtain its URL. Update the
Schedule URLin theSettingsnode. - Set up Telegram Bot: Create a Telegram bot and obtain its API token. Configure the
Telegram accountcredential in n8n. - Set up AI Model: Configure your AI model credential (e.g., OpenRouter). Update the
LLMnode with your desired model. - Connect Triggers: Set up the
telegramInputnode to listen for messages on your Telegram bot and then8nInputnode for testing. - Adjust AI System Message: Modify the
systemMessagein theScheduleBotnode to fine-tune the AI's persona and instructions. - Test and Deploy: Run the workflow and send messages to your Telegram bot to test its responses. Deploy the workflow to your n8n instance.
Apps Used
Workflow JSON
{
"id": "9cb9f2e9-c771-45fc-87a5-e0be1e8d5d93",
"name": "Automate Telegram Bot Responses with Google Sheets Schedule",
"nodes": 0,
"category": "AI & Language Models, Google Workspace",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 9cb9f2e9-c771...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Automate Local Business Outreach with AI-Powered Yelp Scraper
This workflow automates the process of scraping local business details from Yelp using AI, then leverages that data to send personalized partnership proposals via Gmail. It's perfect for sales and marketing teams looking to streamline lead generation and outreach campaigns.
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.