Automated AI-Powered News Search and Reporting with Google Sheets & Telegram

Overview

This workflow automates the process of searching for the latest AI news, logging results, and notifying users. It leverages Perplexity AI for news discovery, Google Sheets for data storage, and Telegram for instant notifications.

Key Features

• Scheduled Automation: Initiates daily searches using a schedule trigger.
• AI News Search: Utilizes Perplexity AI to find relevant news from the past 24 hours.
• Data Logging: Records search results in Google Sheets for tracking and analysis.
• Notification Delivery: Sends curated news summaries directly to Telegram channels or users.
• Data Formatting: Employs OpenAI-powered formatting for clear, concise summaries.

Benefits

• Time Savings: Eliminates manual news searching and reporting tasks.
• Consistency: Ensures timely, daily updates without human intervention.
• Centralized Records: Maintains a searchable log of news items for future reference.
• Enhanced Communication: Delivers actionable insights directly to stakeholders via Telegram.

Use Cases

• Market Intelligence: Stay updated on AI industry trends for competitive advantage.
• Team Updates: Keep teams informed with daily news digests.
• Content Curation: Source timely content for newsletters or social media.

Integrations & Processes

Key integrations include Perplexity AI, Google Sheets, OpenAI (LangChain), and Telegram, orchestrated via n8n for seamless automation.