n8n SEC 10-K/10-Q Sentiment Bot: OpenAI + Google Sheets + Slack

Get Daily SEC 10-K/10-Q Sentiment Alerts—Automatically

This n8n SEC 10-K/10-Q Sentiment Bot checks the SEC EDGAR database every day for the newest 10-K or 10-Q, extracts Risk Factors and MD&A, runs an OpenAI sentiment/risk analysis, then logs everything to Google Sheets and posts an alert to Slack.

What this workflow does

• Runs once per day on a schedule.
• Uses the SEC EDGAR submissions API to fetch the latest filing for a target CIK and selects the newest 10-K or 10-Q, including its document URL.
• Checks Google Sheets for the filing’s accessionNumber to avoid duplicate processing.
• If it’s a new filing, downloads the primary document from SEC EDGAR and extracts the Risk Factors and Management’s Discussion and Analysis (MD&A) sections from the filing HTML.
• Filters the extracted text to a keyword-focused subset and sends it to OpenAI to return structured JSON output (sentiment, risk level, key risks, outlook, and financial highlights).
• Appends filing metadata plus the OpenAI analysis to Google Sheets and sends a formatted summary message to Slack.

Use cases

• SaaS operators and analysts who want early visibility into changes in risk and outlook from SEC filings.
• Teams monitoring specific public companies using a repeatable n8n automation workflow.
• Automated reporting pipelines that combine SEC content with AI-generated insights in Google Sheets.

Technical details

• SEC EDGAR: submissions endpoint call via HTTP Request.
• n8n nodes: if, code, merge, slack, plus supporting nodes (including a Sticky Note for guidance).
• OpenAI: generates structured JSON sentiment and risk output from extracted Risk Factors and MD&A text.
• Google Sheets: OAuth-based lookup by accessionNumber and row append for analysis results.

Setup note: configure the OpenAI credential/model, map your Google Sheets columns (accessionNumber lookup + append fields), set your Slack channel, and update the SEC EDGAR CIK/headers as needed.