Summarize RSS, email, and YouTube content with OpenAI and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 43 nodes and runs on a schedule (every day at 08:00) (plus 4 other triggers). Along the way it connects Slack, Telegram, Gmail and Google Sheets and 1 more.
How it runs
Trigger: On a schedule (every day at 08:00) (plus 4 other triggers).
- Set RSS Feed URLs (Code): runs custom JavaScript code
- Get Existing Links (Google Sheets): uses Google Sheets
- Normalize Email Item (Code): runs custom JavaScript code
- Is YouTube URL? (If): checks a condition and branches into true / false
- Read Master Log (All Entries) (Google Sheets): uses Google Sheets
- Slack: uses Slack
- Telegram: uses Telegram
- RSS Feed Read (RSS Read): reads an RSS feed
- Filter Empty Content (If): checks a condition and branches into true / false
- Extract YouTube Video ID (Code): runs custom JavaScript code
…plus 23 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Newsletter Email Trigger).
Nodes used (13)
- Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack - Telegram
n8n-nodes-base.telegram - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - RSS Read
n8n-nodes-base.rssFeedRead - Gmail Trigger
n8n-nodes-base.gmailTrigger - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - Telegram Trigger
n8n-nodes-base.telegramTrigger - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview This workflow captures articles from RSS feeds and Gmail newsletters, filters duplicates with Google Sheets, checks relevance and generates summaries with OpenAI, then logs the results to a “Second Brain” Google Sheet and sends a Telegram…