Monitor Twitter Accounts & Generate Intelligence Summaries with Gemini AI & Telegram

This workflow automates the process of monitoring Twitter accounts for intelligence gathering. It fetches new tweets from specified accounts via RSS, uses a powerful AI model (Google Gemini) to analyze the content based on your custom prompts, and sends formatted alerts to a Telegram chat for high-priority findings.

Key Features:

Scheduled Execution: Runs automatically at your desired interval.

Dynamic Configuration: Manage which Twitter accounts to follow and what AI prompts to use directly from a Postgres database.

AI-Powered Analysis: Leverages Google Gemini to extract summaries, keywords, and assign an importance level to each tweet.

Duplicate Prevention: Keeps track of the last processed tweet to ensure you only get new updates.

Customizable Alerts: Sends well-structured and easy-to-read notifications to Telegram.

Setup Required:

Postgres Database: Set up a table to store your configuration (see the Sticky Note in the workflow for the required schema).

RSSHub: You need access to an RSSHub instance to convert Twitter user timelines into RSS feeds.

Credentials: Add your credentials for Postgres, Google AI (Gemini), and your Telegram Bot in n8n.

Configuration: Update the placeholder values in the RSS and Telegram nodes (e.g., your RSSHub URL, your Telegram Chat ID).