n8n RSS Email Newsletter: Track Sent Posts in Google Sheets

Automate your RSS-to-Email newsletter—without duplicates

This n8n workflow checks your website’s RSS feed every day, emails only brand-new posts to subscribers stored in Google Sheets, and logs each sent article back to a “Sent” tab to prevent duplicate outreach.

What this workflow does

• Runs on a schedule: executes daily at 9:00 AM via an n8n schedule trigger.
• Reads your RSS feed: pulls the latest items from your website’s RSS/Atom feed.
• Filters previously sent posts: loads article URLs already recorded in the Google Sheets Sent tab and keeps only RSS items not yet logged.
• Sends to your subscriber list: when new articles exist, reads emails from the Google Sheets Contacts tab.
• Email for each new post: sends an email for each new RSS item to each subscriber using the configured SMTP/email setup in the Email node.
• Prevents duplicates: appends the article title, URL, and send timestamp to the Sent tab after emailing.

Use cases

• Send a daily “new posts” newsletter for a WordPress, Ghost, or Substack blog using RSS.
• Maintain a simple subscriber list in Google Sheets and keep delivery deduplicated automatically.
• For SaaS teams and automation engineers: build a lightweight, reliable RSS email pipeline in n8n without external newsletter tools.

Technical details

• n8n schedule trigger (daily at 9:00 AM)
• RSS Feed Read to fetch feed items
• Google Sheets integration:
  • Tab Sent (article_url, title, sent_date)
  • Tab Contacts (email)
• Email Send using SMTP/email credentials (fromEmail, subject, and message content options)
• Workflow logic using nodes including if, merge, and item lists
• Includes a sticky note for clarity

Setup in minutes

Update the RSS Feed Read node with your feed URL, create the Google Sheet with tabs named Sent and Contacts, add Google Sheets credentials, replace the spreadsheet ID in Google Sheets nodes, and configure SMTP credentials for the Email node (sender address and subject).