RSS to Sheets & Telegram
Apps
Creator
Ying Cai
Overview
💡 What It Does
Automatically fetches RSS feed articles, saves them to a Google Sheet for tracking, and sends a formatted summary to your Telegram chat.
📥 What You Provide
| Input | What to enter |
|---|---|
| RSS URL | The RSS feed you want to monitor (e.g., https://news.google.com/rss/topics/CAAqJggKIiBDQkFTRWdvSUwyMHZNRFZxYUdjU0FtVnVHZ0pWVXlnQVAB) |
| Google Sheets URL | Link to your Google Sheet where articles will be saved |
| Telegram Chat ID | Your Telegram chat or channel ID (e.g., @yourchannel or -1001234567890) |
⚡ What Happens
Actions:
- Writes new articles to Google Sheets, sends message via Telegram
Returns:
- Success confirmation with count of articles processed and delivery status
How:
- Fetch RSS articles → Save to Google Sheets → Send Telegram summary → Return results
📤 What You Get Back
| Output | Description |
|---|---|
| items_fetched | Number of new articles found in the RSS feed |
| sheet_updated | Confirmation that Google Sheets was updated successfully |
| telegram_sent | Confirmation that Telegram message was delivered |
| spreadsheet_id | Your Google Sheets ID for reference |
🔌 Connections Required
| App | Why |
|---|---|
| FIRECRAWL | To fetch and parse RSS feed content |
| GOOGLESHEETS | To save article data for tracking and analysis |
| TELEGRAM | To send formatted news summaries to your chat |
📋 Good to Know
Best for:
- Content creators and researchers who need automated news tracking
Tip:
- Set up a dedicated Telegram channel to keep news updates organized
Limit:
- Requires valid RSS feed URL and proper Telegram chat permissions
Built with ❤️ by Rube • All recipes can be scheduled to run automatically