Automate discovering new RSS feed articles, filter duplicates using Google Sheets, post to Slack with formatted titles and links, and log activity to prevent repeats.
The AI agent reads RSS feed URLs from a Google Sheet and fetches the latest articles. It deduplicates by comparing against previously posted links stored in another sheet and filters out duplicates. It posts new articles to Slack with formatted titles and links and logs them back to Google Sheets to prevent repeats.
Automates discovery, deduplication, posting, and logging to Slack.
Reads RSS feed URLs from the Feeds tab in the Google Sheet.
Fetches the latest articles from each feed.
Checks for duplicates against the Posted Articles tab.
Filters out already shared articles.
Posts new articles to a Slack channel with formatted titles and links.
Logs newly shared articles back to the Google Sheet to prevent duplicates.
Before → 5 real pain points.
A simple 3-step flow that non-technical users can follow.
Reads the Feeds tab in Google Sheets to obtain the list of RSS URLs and prepares them for processing.
Fetches new items from each feed and checks against the Posted Articles tab to filter duplicates.
Posts new articles to Slack with formatted titles and links and logs the activity to the Posted Articles tab.
One realistic scenario showing task, time, and outcome.
At 7:00 AM, the AI agent reads feeds from the Feeds tab, identifies 5 new articles, posts them to the designated Slack channel with formatted titles and links, and logs the 5 items back to the Posted Articles tab for future reference.
Roles that rely on timely content sharing.
Need daily digests from multiple feeds posted automatically.
Keep channels updated with fresh articles.
Get sector updates without manual checking.
Automate deduping and posting.
Monitor trends from feeds and share insights.
Distribute news to Slack for awareness.
Tools used to read data, post to Slack, and log activity.
Reads the Feeds and Posted Articles tabs to fetch URLs and record published items.
Posts messages to a designated Slack channel with formatted titles and links
Fetches the latest articles from each feed URL
Orchestrates the AI agent workflow (fetch, dedupe, post, log).
Six practical scenarios across teams.
Practical answers to setup and reliability concerns.
It reads RSS feeds specified in the Feeds tab of the Google Sheet; you can add any feed URL. The agent supports multiple feeds and scales as you add more. If a feed returns errors, it skips that feed for the run and continues with others. The log keeps a record of feeds attempted to help you audit issues. Any feed URL should be accessible publicly or through your credentials.
The AI agent compares fetched articles against the Published Articles log stored in the sheet. Articles not found in the log are treated as new. After posting, those articles are written to the log to prevent duplicates in future runs. If a link is duplicated across feeds, it is ignored. It uses pubDate or equivalent metadata when available to determine recency.
Yes. The AI agent supports a message template that you can adjust to include bold titles, clickable links, and a short summary. Formatting changes apply to all posts in the designated Slack channel. If you need per-feed customization, we can add feed-specific templates. Changes are reflected in the next automation run.
During a run, the agent skips feeds that fail to fetch. It records the failure in the log for visibility and retries on the next schedule. If a feed remains unavailable, you can configure a retry strategy or alert. The rest of the feeds continue processing as normal.
Posting details (title, link, and pubDate if available) are stored in the Posted Articles tab. This provides a single source of truth for what has already been shared. The log helps you audit and prevents duplicates across runs. You can export the log for records or reporting.
Yes. The schedule is defined by a Cron trigger and can be adjusted to run daily, hourly, or at a custom time. Changes are saved in your AI agent workflow configuration. If you need different schedules per feed, we can implement conditional scheduling.
The AI agent includes basic error handling and retry logic for transient failures. If credentials fail, it generates a clear alert and stops the run to prevent partial posts. Retried attempts follow a backoff policy to avoid rate limiting. You can monitor and adjust retry counts as needed.
Automate discovering new RSS feed articles, filter duplicates using Google Sheets, post to Slack with formatted titles and links, and log activity to prevent repeats.