n8n RSS Opportunity Scoring to Google Sheets + Gmail Digest

Turn RSS leads into a scored review queue—and email only the best

This n8n workflow reads one or more RSS feeds, scores each new opportunity, deduplicates items seen in the last 90 days, appends qualifying records to Google Sheets, and sends a Gmail digest only when results meet your priority threshold.

What this workflow does

• Runs on demand or every 30 minutes to keep your opportunity pipeline fresh.
• Builds RSS search logic from your configured feed URLs plus include/high-value/exclude keyword lists and a priority threshold.
• Processes feeds sequentially: normalizes entries, skips URLs detected in the last 90 days, and calculates a 0–100 score using keyword-based “score reasons.”
• Appends new opportunities to Google Sheets in your chosen tab (example fields: detected_at, source_search, title, url, published_at, score, score_reasons, categories, budget_label, status).
• Sends a Gmail digest only when it matters: compiles a digest of opportunities that meet or exceed your threshold, sends via Gmail, then continues with the next feed after a brief wait.

Use cases

• SaaS operators tracking market announcements, partnerships, or funding-related RSS topics and routing only high-priority items to a team queue.
• Automation engineers building an n8n RSS opportunity scoring system that writes to Google Sheets for review and uses Gmail for targeted notifications.
• Lean lead-generation workflows that reduce noise by deduplicating and threshold-filtering before anyone sees the results.

Technical details

• n8n workflow scheduling: manual run or every 30 minutes.
• Core nodes: if, set, code, no op, wait, gmail.
• Integrations: Google Sheets (OAuth + append to a specified spreadsheet/tab) and Gmail (OAuth + notification recipient).

Set it up by adding your RSS feed URLs, keyword lists, priority threshold, Google Sheets tab name, and notification email—then connect Google Sheets and Gmail OAuth credentials to start receiving scored opportunity digests.