{"product_id":"n8n-rss-opportunity-scoring-to-google-sheets-gmail-digest","title":"n8n RSS Opportunity Scoring to Google Sheets + Gmail Digest","description":"\u003ch3\u003eTurn RSS leads into a scored review queue—and email only the best\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on demand or every 30 minutes\u003c\/b\u003e to keep your opportunity pipeline fresh.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBuilds RSS search logic\u003c\/b\u003e from your configured feed URLs plus include\/high-value\/exclude keyword lists and a \u003cb\u003epriority threshold\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eProcesses feeds sequentially\u003c\/b\u003e: normalizes entries, skips URLs detected in the \u003cb\u003elast 90 days\u003c\/b\u003e, and calculates a \u003cb\u003e0–100 score\u003c\/b\u003e using keyword-based “score reasons.”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends new opportunities to Google Sheets\u003c\/b\u003e in your chosen tab (example fields: \u003ci\u003edetected_at\u003c\/i\u003e, \u003ci\u003esource_search\u003c\/i\u003e, \u003ci\u003etitle\u003c\/i\u003e, \u003ci\u003eurl\u003c\/i\u003e, \u003ci\u003epublished_at\u003c\/i\u003e, \u003ci\u003escore\u003c\/i\u003e, \u003ci\u003escore_reasons\u003c\/i\u003e, \u003ci\u003ecategories\u003c\/i\u003e, \u003ci\u003ebudget_label\u003c\/i\u003e, \u003ci\u003estatus\u003c\/i\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a Gmail digest only when it matters\u003c\/b\u003e: compiles a digest of opportunities that \u003cb\u003emeet or exceed\u003c\/b\u003e your threshold, sends via \u003cb\u003eGmail\u003c\/b\u003e, then continues with the next feed after a brief wait.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators tracking market announcements, partnerships, or funding-related RSS topics and routing only high-priority items to a team queue.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an n8n RSS opportunity scoring system that writes to Google Sheets for review and uses Gmail for targeted notifications.\u003c\/li\u003e\n  \u003cli\u003eLean lead-generation workflows that reduce noise by deduplicating and threshold-filtering before anyone sees the results.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n workflow scheduling:\u003c\/b\u003e manual run or every 30 minutes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCore nodes:\u003c\/b\u003e \u003ci\u003eif\u003c\/i\u003e, \u003ci\u003eset\u003c\/i\u003e, \u003ci\u003ecode\u003c\/i\u003e, \u003ci\u003eno op\u003c\/i\u003e, \u003ci\u003ewait\u003c\/i\u003e, \u003ci\u003egmail\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e \u003cb\u003eGoogle Sheets\u003c\/b\u003e (OAuth + append to a specified spreadsheet\/tab) and \u003cb\u003eGmail\u003c\/b\u003e (OAuth + notification recipient).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eSet it up\u003c\/b\u003e 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45755361886387,"sku":"N8N-17715","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/yrRgyXamahWtRlw3Ndi3B_qCmx3jRd.png?v=1785661769","url":"https:\/\/buyflowscripts.com\/products\/n8n-rss-opportunity-scoring-to-google-sheets-gmail-digest","provider":"N8N Commerce","version":"1.0","type":"link"}