{"product_id":"n8n-rss-email-newsletter-track-sent-posts-in-google-sheets","title":"n8n RSS Email Newsletter: Track Sent Posts in Google Sheets","description":"\u003ch3\u003eAutomate your RSS-to-Email newsletter—without duplicates\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes daily at \u003cstrong\u003e9:00 AM\u003c\/strong\u003e via an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your RSS feed:\u003c\/strong\u003e pulls the latest items from your website’s RSS\/Atom feed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters previously sent posts:\u003c\/strong\u003e loads article URLs already recorded in the Google Sheets \u003cstrong\u003eSent\u003c\/strong\u003e tab and keeps only RSS items not yet logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends to your subscriber list:\u003c\/strong\u003e when new articles exist, reads emails from the Google Sheets \u003cstrong\u003eContacts\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail for each new post:\u003c\/strong\u003e sends an email for each new RSS item to each subscriber using the configured \u003cstrong\u003eSMTP\/email\u003c\/strong\u003e setup in the Email node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates:\u003c\/strong\u003e appends the article \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003eURL\u003c\/strong\u003e, and \u003cstrong\u003esend timestamp\u003c\/strong\u003e to the \u003cstrong\u003eSent\u003c\/strong\u003e tab after emailing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend a daily “new posts” newsletter for a \u003cstrong\u003eWordPress\u003c\/strong\u003e, \u003cstrong\u003eGhost\u003c\/strong\u003e, or \u003cstrong\u003eSubstack\u003c\/strong\u003e blog using RSS.\u003c\/li\u003e\n  \u003cli\u003eMaintain a simple subscriber list in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and keep delivery deduplicated automatically.\u003c\/li\u003e\n  \u003cli\u003eFor SaaS teams and automation engineers: build a lightweight, reliable RSS email pipeline in n8n without external newsletter tools.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n schedule trigger\u003c\/strong\u003e (daily at 9:00 AM)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRSS Feed Read\u003c\/strong\u003e to fetch feed items\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration:\n    \u003cul\u003e\n      \u003cli\u003eTab \u003cstrong\u003eSent\u003c\/strong\u003e (article_url, title, sent_date)\u003c\/li\u003e\n      \u003cli\u003eTab \u003cstrong\u003eContacts\u003c\/strong\u003e (email)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail Send\u003c\/strong\u003e using SMTP\/email credentials (fromEmail, subject, and message content options)\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic using nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, and \u003cstrong\u003eitem lists\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIncludes a \u003cstrong\u003esticky note\u003c\/strong\u003e for clarity\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup in minutes\u003c\/h3\u003e\n\u003cp\u003eUpdate the RSS Feed Read node with your feed URL, create the Google Sheet with tabs named \u003cstrong\u003eSent\u003c\/strong\u003e and \u003cstrong\u003eContacts\u003c\/strong\u003e, add Google Sheets credentials, replace the spreadsheet ID in Google Sheets nodes, and configure SMTP credentials for the Email node (sender address and subject).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45756675653811,"sku":"N8N-17747","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YD5GXXwhVdRexsBLke1io_MLYpjCdr.png?v=1785747932","url":"https:\/\/buyflowscripts.com\/products\/n8n-rss-email-newsletter-track-sent-posts-in-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}