Sarfaraz Muhammad Sajib

Sarfaraz Muhammad Sajib

Send Scheduled RSS News Digest Emails with Formatted HTML in Gmail

πŸ“¬ Scheduled RSS News Digest Emails with Gmail

Automatically send beautifully formatted news digests from any RSS feed (eg, Prothom Alo) directly to your Gmail inbox on a schedule using this n8n workflow. Ideal for news curators, bloggers, media professionals, or anyone who wants a daily/weekly news summary in their email.


βœ… Prerequisites

Before using this workflow, ensure you have the following:

  • An active Gmail account with OAuth2 credentials set up in n8n.
  • A public RSS feed URL (eg, https://prothomalo.com/feed ).
  • An instance of n8n running (self-hosted or via n8n cloud).
  • Basic familiarity with how n8n workflows function.

βš™οΈ Setup Instructions

1. Schedule Trigger

  • Triggers the workflow at your chosen interval (eg, daily at 8 AM).
  • You can configure this under the interval section of the Schedule Trigger node.

2. HTTP Request – Get RSS from Prothom Alo

  • Fetches the latest RSS feed from your preferred news source.
  • Set the URL field to your desired RSS feed, such as https://prothomalo.com/feed .

3. Convert XML to JSON

  • Uses the XML node to parse the fetched XML into JSON format for further processing.

4. Code Node – Generate HTML News Preview

  • Transforms the parsed JSON into a styled HTML template.
  • Includes dynamic data like the article title, summary, author, category, and a β€œRead More” button.
  • The date is formatted to bn-BD locale for regional display.

5. Gmail Node – Send a message

  • Sends the generated HTML as an email.

  • Requires Gmail OAuth2 credentials to be configured.

    • Set the recipient address.
    • Use the generated HTML inside the message field.
    • Make sure to use Gmail OAuth2 credentials (you can set this under "Credentials").

πŸ›  Customization Options

  • RSS Feed Source : Replace https://prothomalo.com/feed with any RSS/Atom feed of your choice.
  • Email Design : Modify the embedded HTML/CSS in the Gmail node and code block to reflect your brand/theme.
  • Language & Locale : Adjust the date and formatting based on your preferred locale (eg, en-US , bn-BD , etc.).
  • Email Frequency : Set your schedule to send digests hourly, daily, or weekly.

🧹 Flow Overview

 Schedule Trigger β†’ HTTP Request β†’ XML β†’ Code (HTML Builder) β†’ Gmail Send

πŸ’‘ Use Cases

  • Daily Newsletters
  • Team Updates from Blogs
  • Industry Trends Monitoring
  • Client Briefings with Custom Feeds

This automated workflow ensures timely delivery of curated news in a mobile-responsive, branded HTML format. No manual copy-pasting β€” just scheduled insights, beautifully delivered.

Do you want to automate your business?

Let's talk about your project