n8n

How to Automate Slack Industry News Summaries?

Keep your team up to date without sifting through dozens of sites. Every 15 minutes, new articles from your chosen feeds are reviewed, scored for relevance, and posted to Slack with short, clear summaries. It is ideal for marketing teams and analysts who need fast updates on AI and data topics.

The flow loads feed URLs from a Google Sheet, reads each RSS feed, and compares links against a Google Sheet database to avoid repeats. An AI model checks the title and snippet to decide if an article fits your topics. If relevant, Jina AI fetches the full page and turns it into clean text, then another AI creates a Slack friendly summary. Messages go to your channel, and every URL is logged in Google Sheets with status and timestamps. If nothing new is found, the run ends quietly.

Setup is simple. Connect Google Sheets, Slack, OpenAI, and Jina AI. Add your feed URLs to the rss_feed sheet and pick your Slack channel. Expect less manual reading, faster insights, and a steady record of what was shared. Great for content curation, trend tracking, and internal briefings.

What are the key features?

  • Scheduled checks every 15 minutes to keep updates fresh
  • Google Sheets list of RSS feeds that you can edit anytime
  • De duplication that skips links already stored in your article database
  • AI relevance check using the article title and snippet
  • Full content fetch with Jina AI to convert pages into clean text
  • OpenAI summary formatted for easy reading in Slack
  • Direct Slack posting to a channel you choose
  • Google Sheets logging of each URL with status, dates, and site name
  • Graceful no new articles path that ends the run without noise

What are the benefits?

  • Reduce manual reading from 2 hours to 10 minutes per day
  • Automate up to 90 percent of content screening and summarizing
  • Eliminate nearly 100 percent of duplicate shares with link tracking
  • Connect Slack, Google Sheets, OpenAI, and Jina AI in one flow
  • Handle more feeds without extra effort and scale as sources grow
  • Keep a reliable audit trail of all links and summaries

How do you set it up?

  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, Slack, OpenAI and Jina AI. See the Tools Required section above for links to create accounts with these services.
  3. Prepare Google Sheets: create a spreadsheet with two sheets named rss_feed and article_database. In rss_feed, add a header named rss_feed_url and list each feed URL in a new row. In article_database, add headers for article_url, website, publish_date, summarized, fetched_at.
  4. Connect Google Sheets: in n8n, open each Google Sheets node. In the Credential to connect with dropdown, click Create new credential. Choose Service Account or OAuth. If using a service account, upload the JSON key and share your spreadsheet with the service account email. Set your Document ID and select the correct sheet names.
  5. Set the Schedule Trigger: open the Schedule node and confirm the interval is every 15 minutes or adjust to your needs.
  6. Configure OpenAI: open the OpenAI nodes. In Credential to connect with, click Create new credential. Add your OpenAI API key from your OpenAI account API page and save.
  7. Configure Jina AI: open the Jina AI HTTP Request node. If you have a key, add an Authorization header with value Bearer YOUR_JINA_API_KEY. Without a key, expect lower request limits.
  8. Connect Slack: open the Slack node. In credentials, click Create new credential and complete OAuth to your workspace. Choose the target channel or provide the channel ID.
  9. Map Google Sheets fields: confirm the rss_feed node reads the rss_feed_url column and the article_database nodes write to the correct columns. Save changes.
  10. Test the run: click Execute Workflow. Watch the If node path. If new articles exist, you should see a Slack message and new rows added to article_database.
  11. Validate de duplication: run the workflow again. The same links should be skipped and no duplicate Slack posts should appear.
  12. Troubleshoot: if Sheets fails, make sure the service account has access. If Slack fails, check channel permissions. If Jina AI fails, verify the URL is public. If OpenAI errors, check quota and model selection.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Jina AI

Sign up

Free tier: $0, includes 10M tokens per new API key; Reader usable without a key at 20 RPM (500 RPM with key)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Slack

Sign up

Free plan: $0 / mo; limited to 10 apps (third-party or custom) and usable via Slack API

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.