{"product_id":"n8n-rss-to-gmail-newsletter-send-wordpress-updates","title":"n8n RSS to Gmail Newsletter: Send WordPress Updates","description":"\u003ch3\u003eTurn Your WordPress RSS Feed into a Branded Gmail Newsletter—Automatically in n8n\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual start in n8n:\u003c\/strong\u003e Run it on demand (manual execution) whenever you want to send the newsletter.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRead your WordPress RSS feed:\u003c\/strong\u003e The workflow fetches items from your configured RSS feed URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelect the newest content:\u003c\/strong\u003e It extracts the \u003cstrong\u003efirst three posts\u003c\/strong\u003e and maps each post’s \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003esnippet\u003c\/strong\u003e, and \u003cstrong\u003elink\u003c\/strong\u003e into newsletter sections.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoad subscribers from Google Sheets:\u003c\/strong\u003e Recipients are retrieved from a Google Sheets list where the \u003cstrong\u003e“Subscribe”\u003c\/strong\u003e column value equals \u003cstrong\u003e“Subscribes”\u003c\/strong\u003e (including email and a name field used as \u003ccode\u003enama\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate a personalized HTML newsletter:\u003c\/strong\u003e The workflow creates an HTML email that greets each recipient by name and inserts the three latest post sections.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend via Gmail:\u003c\/strong\u003e It loops through the subscriber list and sends each newsletter individually using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend a weekly\/monthly newsletter of WordPress updates to your community without manual copy-pasting.\u003c\/li\u003e\n  \u003cli\u003eKeep SaaS users informed about new WordPress-hosted documentation or announcements.\u003c\/li\u003e\n  \u003cli\u003eUse Google Sheets as a simple subscription manager (email + name + “Subscribe” status).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Manual execution in n8n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRSS Feed integration:\u003c\/strong\u003e RSS Feed Read node to pull WordPress posts\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Retrieves recipients and checks the \u003cem\u003eSubscribe\u003c\/em\u003e column for \u003cem\u003eSubscribes\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail creation:\u003c\/strong\u003e Uses \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, and \u003ccode\u003ehtml\u003c\/code\u003e to assemble personalized newsletter content\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail sending:\u003c\/strong\u003e \u003cstrong\u003egmail\u003c\/strong\u003e node (OAuth2-connected sender account)\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup summary\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e and set the spreadsheet URL\/sheet with subscriber \u003cstrong\u003eEmail\u003c\/strong\u003e, \u003cstrong\u003ename\u003c\/strong\u003e (as \u003ccode\u003enama\u003c\/code\u003e), and \u003cstrong\u003eSubscribe\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e and confirm the permitted sender account.\u003c\/li\u003e\n  \u003cli\u003eUpdate the \u003cstrong\u003eRSS feed URL\u003c\/strong\u003e, plus the email subject\/branding\/website link in the HTML template.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45822094737587,"sku":"N8N-18071","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/LMkzIcJbQ_62n_klIk9hO_aTjUafjN.png?v=1786525959","url":"https:\/\/buyflowscripts.com\/products\/n8n-rss-to-gmail-newsletter-send-wordpress-updates","provider":"N8N Commerce","version":"1.0","type":"link"}