Turn Telegram into a stock research assistant. Team members send a ticker or a quick voice note and get a clean chart plus AI commentary back in seconds. A scheduler can also run analyses for a list of tickers stored in Airtable.

Incoming messages from Telegram trigger a flow that handles text and voice. Voice notes are downloaded and transcribed with OpenAI, then passed to an AI agent with short term memory for context. The agent can call a chart tool that builds a TradingView style image through the Chart IMG API, and then sends both the chart and the written analysis back to Telegram. A schedule trigger reads tickers from Airtable, loops through them, and posts regular updates without manual work. A webhook path lets other apps submit tickers too.

Set up needs a Telegram bot token, an OpenAI API key, an Airtable base for tickers, and a Chart IMG API key. Replace the chat ID and map your Airtable fields. Most teams see research prep time drop from half an hour to a few minutes per symbol. Great for daily market notes, investor updates, and quick checks during trading hours.

• Telegram trigger listens for new messages and routes text or voice notes with a Switch node.
• Voice messages are downloaded and transcribed using OpenAI to turn speech into text.
• AI agent with window memory keeps short conversation context for better answers.
• Tool workflow builds chart requests and sends them to Chart IMG to get a shareable image URL.
• Telegram send actions return the chart image and the written analysis to the same chat.
• Schedule trigger reads tickers from Airtable and loops through them to post regular updates.
• Airtable tool saves tickers mentioned in chat so they can be reused in future runs.
• Webhook endpoint accepts ticker requests from other systems to trigger an analysis.

• Reduce manual charting and commentary from 30 minutes to about 2 minutes per ticker
• Automate up to 90 percent of the steps needed to deliver stock updates
• Keep chart style and formatting consistent across 100 percent of posts
• Handle 50 or more tickers in a scheduled batch without extra effort
• Connect Telegram, Airtable, OpenAI and Chart IMG in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Telegram, OpenAI, Airtable and Chart-IMG. See the Tools Required section above for links to create accounts with these services.
3. In Telegram, create a bot with BotFather and copy the bot token. In n8n, open the Telegram Trigger node, choose Credential to connect with, click Create new credential, and paste the token. Repeat for Telegram send nodes so they use the same credential.
4. In your OpenAI account, create an API key. In n8n, open the OpenAI nodes and create a new OpenAI credential by pasting the API key.
5. In Airtable, create a base and a table for tickers. Create a personal access token with read and write access to that base. In n8n, open the Airtable nodes and create a new Airtable credential using the token.
6. In your Chart IMG account, copy the API key. In n8n, open the HTTP Request node that calls the chart service, create a new HTTP Header Auth credential, and set the header name to x-api-key with your key as the value.
7. Set your Telegram chat ID in the Telegram send nodes. Send a message to your bot and use a chat ID finder or bot API to confirm the correct number if needed.
8. Map Airtable fields in the Airtable nodes so the ticker column matches the node configuration. Save and run a test read to confirm records load.
9. Open the Switch node and confirm it routes Voice messages to Download File and text messages to Set Text.
10. Send a text ticker to the bot to test end to end. You should receive a chart image and an analysis reply. Then send a short voice note and confirm transcription and response.
11. Enable the Schedule Trigger and run a manual execution to test the batch loop. Check Telegram for multiple posts and verify no rate limits are hit.
12. If you see errors, check the HTTP Request node for 401 responses from Chart IMG, confirm the chat ID, and verify Airtable base and table names match your setup.