AI-Powered Information Monitoring with OpenAI, Google Sheets, Jina AI and Slack

AI-Powered Information Monitoring with OpenAI automates the process of tracking and summarizing articles from RSS feeds, delivering concise summaries directly to a designated Slack channel every hour. This workflow enhances productivity by ensuring users stay informed on relevant topics without manual checking, while efficiently managing article data in Google Sheets for easy reference.

7/8/2025
31 nodes
Complex
schedulecomplexlangchainschedule triggerrssfeedreadsticky notegooglesheetsslacknoopautomationadvancedcronlogicconditionalcommunicationnotificationapiintegration
Categories:
Communication & MessagingSchedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
LangChainSchedule TriggerRssFeedReadSticky NoteGoogleSheetsSlackNoOp

Target Audience

Industry Professionals: Those who need to stay updated on specific developments in their field, such as AI or data science.
Research Teams: Groups requiring timely insights on particular topics to enhance their research capabilities.
Companies: Organizations looking to keep their teams informed with relevant content without manual effort, ensuring a streamlined communication process.

Problem Solved

This workflow addresses the challenge of information overload by automating the monitoring of specific topics through RSS feeds. It delivers concise summaries of relevant articles directly to a Slack channel, allowing users to stay informed without the need to manually check multiple sources. This leads to a time-efficient and focused approach to information gathering.

Workflow Steps

  • Trigger: The workflow is initiated by a Scheduler that runs every 15 minutes to check for new articles in the monitored RSS feeds.
    2. Data Retrieval:
    - The workflow retrieves the list of RSS feed URLs from Google Sheets.
    - It checks the article database in Google Sheets to avoid processing duplicate articles.
    3. Content Processing:
    - The articles are read from the RSS feeds.
    - Each article's relevance is assessed using OpenAI's GPT-4o-mini model.
    - Relevant articles are scraped for content using Jina AI.
    - Summaries are generated and formatted for Slack.
    4. Output:
    - The summaries are posted to a designated Slack channel for easy access.
    - Metadata about the articles is stored in Google Sheets for tracking and reference.

    • Customization Guide

    Users can adapt this workflow by:
    - Modifying the RSS Feed URLs: Add or remove URLs in the Google Sheets template to change the sources of articles being monitored.
    - Adjusting the Scheduler: Change the frequency of the workflow execution by modifying the Schedule Trigger settings.
    - Customizing the Summarization Process: Edit the System Prompt in the OpenAI Chat Model node to alter the summary structure or language, making it more suited to specific needs.
    - Changing the Slack Channel: Update the Slack node parameters to post summaries to a different channel if desired.