This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

📄 Post New Articles from Feeds to Slack Channel

🧠 What This Workflow Does

This workflow automates the discovery and sharing of fresh articles from a curated list of RSS feeds. It performs the following steps:

1. Reads a list of RSS feed URLs from a Google Sheet ( Feeds tab).
2. Fetches the latest articles from each feed.
3. Checks for duplicates against previously published links stored in another sheet ( Posted Articles tab).
4. Filters out already shared articles .
5. Posts the new articles to a designated Slack channel with formatted titles and links.
6. Logs the newly shared articles back into the Google Sheet to prevent duplicates.

🛠️ Prerequisites

To use this workflow, you must have:

• ✅ Google Sheets OAuth2 credentials set up in n8n
  (Used to access and update the RSS feed and post history sheets)

• ✅ Slack OAuth2 credentials
  (Used to post messages to a specific Slack channel)

• ✅ A Google Spreadsheet with:

  • Feeds tab – Columns: title , link
  • Posted Articles tab – Columns: title , link , pubDate

🔧 Environment Variables or Custom Values

You will need to set the following n8n variable or replace with direct input:

• {{$vars.Daily_Industry_News_Automation_Google_Sheet}} :
  Reference to the Google Sheet Document ID (you can use a static ID if preferred)

Also update:

• Slack channelId : Replace with your actual Slack channel ID if not dynamically referenced

⏰ Triggers & Scheduling

• Trigger type : Cron node
• Default schedule : Every day at 7:00 AM

You can modify this in the “Trigger Workflow” node to suit your own schedule.

🎯 Intended Use Case

This workflow is ideal for:

• Marketing teams curating daily or weekly news digests
• Founders or industry professionals monitoring sector updates
• Automating internal Slack news updates
• Avoiding duplicate content when sourcing from multiple feeds