Rss Feed Keyword Alerts Email Digest Without Duplicates

    What this workflow does

    The workflow contains these steps: Run Once to Create Tables → Check Feeds Every Hour → RSS Digest Settings → Setup Run? → Create Feeds Table → Create Keywords Table → Create Sent Items Table → Find Data Tables → Tables Found? → Tables Missing → Delete Expired History → Load Active Feeds → Load Keywords → Load Sent History → Prepare Feed List → Any Active Feeds? → No Active Feeds → Fetch Feed XML → Loop Over Feeds → Parse Feed XML → Tag Feed Result → Pick New Items → Any Seen Again? → List Items Seen Again → Refresh Last Seen → Back to Digest → Anything New? → Send Digest Email → One Row per Sent Item → Record Sent Items → Any Feed Failed? → Report Failed Feeds → Nothing New.

    What you need

    • An n8n instance to import and run the workflow.
    • StickyNote access for the StickyNote steps listed in this workflow.
    • ManualTrigger access for the ManualTrigger steps listed in this workflow.
    • Schedule access for the Schedule steps listed in this workflow.
    • Set access for the Set steps listed in this workflow.
    • IF access for the IF steps listed in this workflow.
    • DataTable access for the DataTable steps listed in this workflow.
    • StopAndError access for the StopAndError steps listed in this workflow.
    • Code access for the Code steps listed in this workflow.
    • HTTP Request access for the HTTP Request steps listed in this workflow.
    • Batch access for the Batch steps listed in this workflow.
    • Xml access for the Xml steps listed in this workflow.
    • EmailSend access for the EmailSend steps listed in this workflow.
    • NoOp access for the NoOp steps listed in this workflow.

    Workflow nodes

    1. Run Once to Create Tables (n8n-nodes-base.manualTrigger)
    2. Check Feeds Every Hour (n8n-nodes-base.scheduleTrigger)
    3. RSS Digest Settings (n8n-nodes-base.set)
    4. Setup Run? (n8n-nodes-base.if)
    5. Create Feeds Table (n8n-nodes-base.dataTable)
    6. Create Keywords Table (n8n-nodes-base.dataTable)
    7. Create Sent Items Table (n8n-nodes-base.dataTable)
    8. Find Data Tables (n8n-nodes-base.dataTable)
    9. Tables Found? (n8n-nodes-base.if)
    10. Tables Missing (n8n-nodes-base.stopAndError)
    11. Delete Expired History (n8n-nodes-base.dataTable)
    12. Load Active Feeds (n8n-nodes-base.dataTable)
    13. Load Keywords (n8n-nodes-base.dataTable)
    14. Load Sent History (n8n-nodes-base.dataTable)
    15. Prepare Feed List (n8n-nodes-base.code)
    16. Any Active Feeds? (n8n-nodes-base.if)
    17. No Active Feeds (n8n-nodes-base.stopAndError)
    18. Fetch Feed XML (n8n-nodes-base.httpRequest)
    19. Loop Over Feeds (n8n-nodes-base.splitInBatches)
    20. Parse Feed XML (n8n-nodes-base.xml)
    21. Tag Feed Result (n8n-nodes-base.code)
    22. Pick New Items (n8n-nodes-base.code)
    23. Any Seen Again? (n8n-nodes-base.if)
    24. List Items Seen Again (n8n-nodes-base.code)
    25. Refresh Last Seen (n8n-nodes-base.dataTable)
    26. Back to Digest (n8n-nodes-base.code)
    27. Anything New? (n8n-nodes-base.if)
    28. Send Digest Email (n8n-nodes-base.emailSend)
    29. One Row per Sent Item (n8n-nodes-base.code)
    30. Record Sent Items (n8n-nodes-base.dataTable)
    31. Any Feed Failed? (n8n-nodes-base.if)
    32. Report Failed Feeds (n8n-nodes-base.stopAndError)
    33. Nothing New (n8n-nodes-base.noOp)
    StickyNoteManualTriggerScheduleSetIFDataTableStopAndErrorCodeHTTP RequestBatchXmlEmailSendNoOp
    39 nodesOther
    View on GitHub

    Need this workflow customized or debugged? Book a 30-min scope call →

    Want this set up for you? Book a 30-min scope call

    I build and fix n8n workflows for agencies and SaaS teams. 30-minute scope call — bring the problem, leave with an estimate.

    Related workflows