Stay on top of industry news without reading every site. This automation collects new posts from your chosen RSS feeds, filters for AI and data topics, and sends short summaries to Slack for fast team review. It also logs each link and status in Google Sheets so you avoid repeats.

A schedule runs every 15 minutes. The flow pulls feed URLs from Google Sheets, reads each RSS feed, and checks another sheet to see which links were already handled. A code step keeps only new items, and an IF gate stops the run if nothing new was found. OpenAI scores each title and snippet for relevance. For relevant posts, Jina AI fetches full content, then OpenAI creates a clear Slack message. The Slack node posts to your chosen channel. Both relevant and not relevant links are written back to Google Sheets with URL, site, dates, and summary status.

You need Google Sheets, Slack, and an OpenAI key, with an optional Jina AI key. Set your rss_feed and article_database sheets, add your feeds, and choose a Slack channel. Expect less manual scanning, faster updates, and a clean audit trail across product marketing, analyst work, and sales enablement.

• Scheduled execution every 15 minutes to keep updates fresh
• Google Sheets list of RSS feed URLs drives which sources are read
• Google Sheets article database prevents processing the same URL twice
• Code filter and IF gate stop the run when no new items are found
• OpenAI text classifier decides if each item matches your topics
• Jina AI fetches full article content as clean text for better summaries
• OpenAI LLM chain produces short, clear messages formatted for Slack
• Slack channel posting shares summaries with your team in real time

• Reduce manual news scanning from 2 hours to 10 minutes per day
• Automate over 90 percent of routine feed checks
• Eliminate duplicate reviews with a central Google Sheets log
• Deliver consistent, readable summaries to Slack for fast decisions
• Scale to many feeds with timed runs and automatic filtering
• Cut context switching by connecting discovery, review, and sharing

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, OpenAI, Slack and Jina AI. See the Tools Required section above for links to create accounts with these services.
3. In Google Sheets, copy or create two tabs named rss_feed and article_database. Include a column named rss_feed_url in rss_feed. In article_database include article_url, summarized, website, fetched_at, and publish_date.
4. In the n8n credentials manager, create a Google Sheets Service Account credential. Share your Google Sheet with the service account email. In the Google Sheets nodes, select this credential, set the Document ID, and choose the rss_feed and article_database sheets.
5. Double click the Slack node. In the credential dropdown, click Create new credential and complete Slack OAuth. Select the target channel where summaries will be posted.
6. Create an OpenAI API key in your OpenAI account. In n8n, create an OpenAI credential and select it in both OpenAI nodes used for classification and summarization.
7. Optional for Jina AI: get an API key from your Jina AI account. In the Jina AI request node, add the key as an Authorization header if required, or leave it unauthenticated for lower request limits.
8. Open the Schedule Trigger and set the interval you want. The default is every 15 minutes.
9. Open the Relevance Classification node and edit the category descriptions to match your topics. Keep two outcomes: relevant and not relevant.
10. Run a test execution. Confirm the workflow finds new items, posts a message to Slack, and writes a row to the article_database sheet.
11. If no posts appear, check that your rss_feed_url values are valid RSS feeds and that the service account has access to the sheet.
12. If Slack messages fail, confirm the selected channel exists and your Slack credential has permission. If summaries fail, check OpenAI usage limits and that the Jina AI step returns content.