Automate crypto news posting to X & Telegram with AI summarization
Automate Crypto News Posting to X & Telegram with AI Summarization This n8n template automates the process of curating and sharing the latest cryptocurrency news on X (formerly Twitter) and Telegram. By leveraging AI for content summarization, this workflow allows you to effortlessly maintain an active social media presence, keeping your audience informed about the dynamic crypto market without manual effort. Who is this for? This template is ideal for: Content Creators & Marketers: Aiming to consistently share valuable news and engage their audience without manual content curation. Crypto Influencers & Educators: Looking to provide timely news updates to their followers across multiple platforms. Crypto Communities & DAOs: Seeking to automate news dissemination within their Telegram channels and wider X audience. Anyone interested in automated news monitoring and sharing. What problem is this workflow solving? Manually tracking, summarizing, and posting crypto news across different social media platforms is time-consuming and requires constant effort. This workflow eliminates these manual tasks, allowing users to: Save Time & Effort: Automate the entire news curation and posting process. Maintain Consistent Presence: Ensure a regular flow of valuable crypto news updates on X and Telegram. Increase Audience Engagement: Provide timely and summarized news to keep your audience informed and engaged. Focus on Strategy: Free up time to focus on broader content strategy and audience growth instead of repetitive manual posting. What this workflow does: This workflow automates the following key steps: Scheduled News Retrieval: Uses a Schedule Trigger to run every 90 minutes (configurable), initiating the news gathering process. Real-time Crypto News Aggregation: Fetches the latest cryptocurrency news from the CryptoPanic API. Recent News Filtering: Filters news articles to include only those published within the last 30 minutes, ensuring timely updates. Content Extraction from News URLs: Visits individual news URLs and extracts the full article content. AI-Powered Content Summarization: Leverages GPT or other LLMs to extract the core content from news articles. Content Aggregation: Merges content from multiple news articles into a single input for summarization. AI-Driven Social Media Content Generation: Utilizes GPT or other LLMs to summarize the aggregated news and create two distinct outputs: Concise & Engaging X Post: Optimized for Twitter's character limit, designed to be attention-grabbing. Detailed Telegram Report: A more comprehensive summary suitable for a Telegram channel or group. Automated Posting to X (Twitter): Automatically posts the generated X summary to your connected Twitter account. Automated Delivery to Telegram: Automatically sends the detailed Telegram report to your specified Telegram chat ID. Setup: To get started, you will need to configure the following services and credentials: CryptoPanic API Token: Obtain a free API token from the CryptoPanic website: https://cryptopanic.com/ In n8n, navigate to the "HTTP Request" node (named "HTTP Request"). In the node parameters, locate the "URL" field and replace "YOURTOKEN" in the URL with your obtained CryptoPanic API token. OpenAI API Key: Obtain an API key from OpenAI: https://platform.openai.com/ For Content Extraction: In n8n, connect your OpenAI account to the "ContentExtraction GPT3.5" node (named "ContentExtraction GPT3.5"). Use your OpenAI API key for the credentials. For News Summarization & Social Media Content Generation: In n8n, connect your OpenAI account to the "Summary news GPT" node (named "Summary news GPT"). Use your OpenAI API key for the credentials. X (Twitter) Developer Credentials: Create a developer account and project on the X Developer Portal: https://developer.twitter.com/ Obtain the necessary API keys and tokens for your X app. In n8n, connect your X Developer account credentials to the "X" node (named "X"). Telegram Bot and Chat ID: Create a Telegram bot using BotFather on Telegram. Obtain your bot's API token. Obtain the Chat ID of the Telegram chat where you want to send news reports. In n8n, connect your Telegram Bot API token to the "Telegram" node (named "Telegram"). In the "Telegram" node parameters, replace "YOURTELEGRAMCHAT_ID" with your Telegram Chat ID. How to customize this workflow: Adapt to ANY Topic: Change the "HTTP Request" node to use a news API for your desired topic (AI, Sports, World News, etc.). Critically, adjust the prompts in the "Summary news GPT" node to be relevant to your chosen topic so the AI generates appropriate summaries and social media content. Adjust Scheduling Frequency: Modify the "Schedule Trigger" node to change how often the workflow runs and posts news. Adjust Scheduling Frequency: Modify the "Schedule Trigger" node to change the frequency of news updates (e.g., change the interval from 90 minutes to a different value). Modify News Filtering: Customize the Python code in the "Extract Meta" node to adjust the news filtering criteria. You can change the time window (currently 30 minutes) or filter based on other criteria from the CryptoPanic API response. Experiment with GPT Models: In the "Summary news GPT" node, try different OpenAI models (e.g., gpt-4, gpt-3.5-turbo-16k) to see how they affect the summarization quality and output. Note that more advanced models may incur higher API costs. Customize AI Prompts: Fine-tune the system and user prompts in the "Summary news GPT" node to alter the tone, style, or format of the generated X and Telegram content. You can adjust the persona of the AI blogger, the desired level of detail in summaries, or specific keywords to include. Extend to Other Platforms: Add nodes to post to other social media platforms like LinkedIn, Facebook, or Discord by adapting the "Summary news GPT" prompts and integrating relevant n8n nodes for those platforms. Category: Marketing, Social Media, AI, News Automation, Content Creation Workflow by: Tianyi (muzi) n8n Creators Profile: https://n8n.io/creators/muzi/
By TianyiBeginner data analysis: merge, filter & summarize in Google Sheets with GPT-4o
This beginner-friendly n8n workflow teaches essential data manipulation techniques using Google Sheets and AI. You'll learn how to: β Merge two datasets by a shared column (Channel) π Filter rows based on performance metrics (Clicks, Spend) π Branch logic into "Great" vs. "Poor" outcomes π Summarize results by team leader π€ Use an OpenAI-powered agent to generate a written analysis highlighting the best and worst performers Perfect for marketers, analysts, or anyone learning how to clean, transform, and interpret data inside n8n. Includes: π Sample Google Sheet to copy π Setup instructions for Google Sheets & OpenAI β¨ AI summary powered by GPT-4o-mini π Questions or Feedback? Feel free to reach out β Iβm happy to help! Robert Breen Founder, Ynteractive π ynteractive.com π§ robert@ynteractive.com πΊ YouTube: YnteractiveTraining π LinkedIn: linkedin.com/in/robertbreen
By Robert BreenLocation-based triggered reminder via Telegram Bot (iOS)
This workflow integrates iOS Shortcuts with n8n to create a simple, automatic location-based reminder system. When the user arrives at a specified location, an automation in the Shortcuts app sends a webhook trigger to n8n. If the trigger matches predefined date and time conditions, n8n sends a Telegram message reminder to the user. This is perfect for repetitive weekly tasks like taking out the bins, customized with conditions for day and time. Key Features Location-Based Trigger: Uses iOS Shortcuts automation to start the workflow upon arrival at a specific location. Time and Day Validation: Logic in n8n checks current weekday and time to ensure reminders are sent only when appropriate. Telegram Integration: Sends reminders directly to your Telegram account using your bot. Minimal Setup: Uses native iOS and simple webhook setup in n8n. How It Works iOS Shortcut Trigger: When the user arrives at a designated location, the iOS shortcut sends a GET request to the n8n webhook. n8n Webhook Node: Receives the request and triggers the workflow. Conditional Check: An IF node checks if the current time is after 4:00 PM and it's a Wednesday (or any other configured condition). Telegram Node: If the condition passes, n8n sends a message like "Don't forget to take the bins out." to your Telegram bot. Setup Instructions Create a Telegram Bot: Use @BotFather to create a bot and obtain your bot token. Add Telegram API credentials in n8n with your bot token. Setup iOS Shortcut: Open the Shortcuts app on your iPhone. Go to the Automation tab β Tap + β Create Personal Automation. Choose Arrive β Select a location. Add action: Get Contents of URL. Method: GET, URL: your n8n Webhook URL (e.g. https://n8n.yourdomain.com/webhook/your-path). Save the automation. (You can also test the automation by pressing the Play button) Import Workflow into n8n: Load the provided workflow JSON. Set your webhook path and Telegram credentials. Adjust the logic in the IF node to your usecase. In my case, I check if today is Wednesday and after 4 PM until Midnight. Expose n8n Publicly: Ensure your n8n instance is publicly accessible via HTTPS so the shortcut can reach it. Customization Guidance Change Reminder Message: Modify the text inside the Telegram node to suit different reminders. Add More Conditions: Extend the logic to support more days, hours, or different trigger messages. Add Multi-Channel Output: Send reminders via email, SMS, or Slack in addition to Telegram. Use More Triggers: Expand to other types of shortcut triggers (e.g. NFC tag, leaving location, time of day). Security and Implementation Webhook Protection: Avoid using easily guessable webhook URLs. Secure Telegram Token: Store your bot token securely in n8n credentials, not in plain workflow text. Limit Shortcut Scope: Only trigger the shortcut at trusted locations or with secure iCloud sync. Automation Permissions: Ensure your iPhone allows shortcut automations to run without confirmation. Benefits Automates repetitive location-based reminders without user interaction. Provides a lightweight, native solution using iOS and n8n with no extra apps. Keeps you on track for routine tasks like garbage days, medicine reminders, or arrival-based tasks. Easily extendable for multiple locations or trigger conditions.
By Roninimous