Track central bank sentiment shifts with OpenAI, Google Sheets, and Slack
Ready for 3.0What this workflow does
This AI workflow has 13 nodes and runs on a schedule (every 3 hours). Along the way it connects Google Sheets, Slack and OpenAI. It also calls 192.168.101.63:5678 over HTTP.
How it runs
Trigger: On a schedule (every 3 hours).
- Fetch Central Bank Feed (HTTP Request): calls 192.168.101.63:5678
- Normalize and Validate Statements (Code): runs custom JavaScript code
- Load Processed Statement History (Google Sheets): uses Google Sheets
- Remove Duplicate Statements (Code): runs custom JavaScript code
- Prepare Sentiment Analysis Input (Code): runs custom JavaScript code
- Analyze Hawkish Dovish Sentiment (OpenAI): uses OpenAI
- Parse Sentiment Analysis Result (Code): runs custom JavaScript code
- Log Sentiment Analysis (Google Sheets): append
- Calculate Sentiment Trend Shift (Code): runs custom JavaScript code
- Check for Meaningful Sentiment Shift (If): checks a condition and branches into true / false
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: 192.168.101.63:5678
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 (7)
- Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - If
n8n-nodes-base.if
From the author
Quick overview This workflow runs every three hours to fetch new FED, ECB, and RBI statements from an HTTP feed, analyzes hawkish/dovish sentiment with OpenAI, logs results to Google Sheets, and posts a Slack alert when the latest score shifts by 20+ points…