Score RSS opportunities to Google Sheets and send priority digests with Gmail

by Mandaniaina Randriambinintsoa · 23 views · created 2026-08-01 · Market Research, AI Summarization

What this workflow does

This workflow has 15 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. Configure Template (Edit Fields (Set)): sets 8 fields: rssFeedUrls, searchName, priorityThreshold…
2. Build Search Configuration (Code): runs custom JavaScript code
3. Loop Over Searches (Loop Over Items (Split in Batches)): loops over the items in batches
4. Read RSS Feed (RSS Read): reads an RSS feed
5. Normalize, Deduplicate & Score (Code): runs custom JavaScript code
6. Has New Opportunities? (If): checks a condition and branches into true / false
7. Expand Opportunities (Code): runs custom JavaScript code
8. Wait: waits 2 seconds
9. Save Opportunities (Google Sheets): append
10. Build Priority Digest (Code): runs custom JavaScript code

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (11)

• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• RSS Readn8n-nodes-base.rssFeedRead
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets
• Gmailn8n-nodes-base.gmail
• Waitn8n-nodes-base.wait
• No Operation, do nothingn8n-nodes-base.noOp

From the author

Quick overview This workflow runs manually or every 30 minutes to read one or more RSS feeds, score and deduplicate new opportunities, append them to Google Sheets, and email a Gmail digest only when items meet a priority threshold. How it works 1. Runs…

View the original on n8n.io → Check your own copy