Summarize RSS, email, and YouTube content with OpenAI and Google Sheets
Go to Workflow
Rahul Joshi
Description
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 digest, with Slack and Telegram alerts on workflow errors.
How it works
Runs daily on a schedule to pull items from a configured list of RSS feeds, and also triggers whenever a new Gmail message matching the newsletters filter arrives.
Normalizes each RSS item or email newsletter by extracting a title, plain-text content, source, link, and date into a consistent format.
Skips items with too little content and removes items whose links already exist in the “Second Brain” Google Sheets document.
Sends the remaining items to OpenAI (gpt-4o-mini) to decide whether each item is relevant for saving.
Sends only relevant items to OpenAI (gpt-4o-mini) again to generate a structured JSON summary, key points, and topic tags.
Appends the parsed summary data to the “Second Brain” sheet in Google Sheets and sends a formatted Telegram message with the summary and link.
If any workflow execution fails, posts an error alert to a Slack channel and to a Telegram chat.
Setup
Connect Gmail OAuth2 credentials and adjust the Gmail search query/label filter used to detect newsletters.
Add an OpenAI API credential and ensure access to the gpt-4o-mini model for both the relevance check and summarization steps.
Connect Google Sheets OAuth2 credentials, set the Google Sheet ID (replacing REPLACE_WITH_YOUR_GOOGLE_SHEET_ID), and ensure the “Second Brain” sheet contains a Link column for deduplication.
Connect a Telegram Bot API credential and set your target chat ID (replacing REPLACE_WITH_YOUR_TELEGRAM_CHAT_ID) for the digest and error alerts.
Connect Slack OAuth2 credentials and set the target channel for workflow error alerts.
Update the RSS feed list in the RSS configuration step to the sources you want to track.