Monitor crypto news risk with CoinDesk RSS, OpenAI, Gmail, and Google Sheets
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs on RSS Feed events. Along the way it connects Google Sheets and Gmail. It also calls api.openai.com over HTTP.
How it runs
Trigger: On RSS Feed events.
- 2. Code - Extract Fields and Check Keywords (Code): runs custom JavaScript code
- 3. IF - Is Crypto Relevant? (If): checks a condition and branches into true / false
- 4. Sheets - Check If Already Processed (Google Sheets): uses Google Sheets
- 4b. Code - Skip If Already Seen (Code): runs custom JavaScript code
- 5. HTTP - OpenAI Crypto Risk Analysis (HTTP Request): calls api.openai.com (POST)
- 6. Code - Parse AI and Set Priority (Code): runs custom JavaScript code
- 7. Sheets - Save Dedupe Record (Google Sheets): append
- 8. Sheets - Log Full Risk Record (Google Sheets): append
- 9. IF - HIGH or MEDIUM Priority? (If): checks a condition and branches into true / false
- 10. Gmail - Send Risk Alert Email (Gmail): uses Gmail
Services it uses
HTTP calls to: api.openai.com
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 (6)
- RSS Feed Trigger
n8n-nodes-base.rssFeedReadTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow polls the CoinDesk RSS feed every 10 minutes, filters for crypto-related stories, checks Google Sheets to avoid duplicates, uses OpenAI to score and summarize risk, logs results to Google Sheets, and sends Gmail alerts when the…