Analyze SEC 10-K/10-Q sentiment with OpenAI, Google Sheets, and Slack
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, OpenAI and Slack. It also calls data.sec.gov over HTTP.
How it runs
Trigger: On a schedule (every day).
- SEC EDGAR — Check Filings (HTTP Request): calls data.sec.gov
- Filter 10-K / 10-Q Filings (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Sheets - Check Existing Filing (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- SEC - Fetch Filing Document (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: data.sec.gov
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 - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - OpenAI
@n8n/n8n-nodes-langchain.openAi - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow runs daily to check SEC EDGAR for the latest 10-K or 10-Q filing for a target company, extracts Risk Factors and MD&A text, analyzes sentiment and risk with OpenAI, then logs results to Google Sheets and posts an alert to Slack.…