n8n RSS to Gmail Newsletter: Send WordPress Updates

Turn Your WordPress RSS Feed into a Branded Gmail Newsletter—Automatically in n8n

This n8n workflow automatically pulls your latest WordPress updates from an RSS feed, builds a polished HTML newsletter, and emails it to subscribers stored in Google Sheets using Gmail.

What this workflow does

• Manual start in n8n: Run it on demand (manual execution) whenever you want to send the newsletter.
• Read your WordPress RSS feed: The workflow fetches items from your configured RSS feed URL.
• Select the newest content: It extracts the first three posts and maps each post’s title, snippet, and link into newsletter sections.
• Load subscribers from Google Sheets: Recipients are retrieved from a Google Sheets list where the “Subscribe” column value equals “Subscribes” (including email and a name field used as nama).
• Generate a personalized HTML newsletter: The workflow creates an HTML email that greets each recipient by name and inserts the three latest post sections.
• Send via Gmail: It loops through the subscriber list and sends each newsletter individually using Gmail.

Use cases

• Send a weekly/monthly newsletter of WordPress updates to your community without manual copy-pasting.
• Keep SaaS users informed about new WordPress-hosted documentation or announcements.
• Use Google Sheets as a simple subscription manager (email + name + “Subscribe” status).

Technical details

• Trigger: Manual execution in n8n
• RSS Feed integration: RSS Feed Read node to pull WordPress posts
• Google Sheets: Retrieves recipients and checks the Subscribe column for Subscribes
• Email creation: Uses set, code, and html to assemble personalized newsletter content
• Email sending: gmail node (OAuth2-connected sender account)

Setup summary

• Connect Google Sheets OAuth and set the spreadsheet URL/sheet with subscriber Email, name (as nama), and Subscribe.
• Connect Gmail OAuth2 and confirm the permitted sender account.
• Update the RSS feed URL, plus the email subject/branding/website link in the HTML template.