Send daily Reddit digest email with Google Sheets scoring and SMTP
Ready for 3.0What this workflow does
This workflow has 16 nodes and runs on a schedule (every day at 07:00). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (every day at 07:00).
- Read Sources (Google Sheets): uses Google Sheets
- Build Feed URL (Edit Fields (Set)): sets 1 field: rss_url
- Fetch Feed XML (HTTP Request): calls an HTTP API
- Parse XML (XML): converts between XML and JSON
- Split Atom Entries (Code): runs custom JavaScript code
- Normalize Post Fields (Edit Fields (Set)): sets 7 fields: date_found, subreddit, title…
- Read Keywords (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Scoring (Code): runs custom JavaScript code
- Collect Candidates (Code): runs custom JavaScript code
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - XML
n8n-nodes-base.xml - Send Email
n8n-nodes-base.emailSend - Merge
n8n-nodes-base.merge
From the author
This N8N Template shows you how to create a basic Reddit scraper and email yourself the highest scoring threads This is for founders, service providers and anyone who wants to do more social listening but doesn't want to pay for an expensive tool. It uses a…