Summarize 10-K risk factor changes with SEC EDGAR MCP, OpenAI, and Google Docs
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Data table
n8n-nodes-base.dataTable - If
n8n-nodes-base.if - Filter
n8n-nodes-base.filter - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Docs
n8n-nodes-base.googleDocs - No Operation, do nothing
n8n-nodes-base.noOp
What it does
Quick overview Compares Item 1A (Risk Factors) between the two most recent 10-K filings for each ticker using a SEC EDGAR MCP server, summarizes the material changes with OpenAI, records what was already reported in a Data Table, and writes a weekly report to Google Docs. How it works 1. Runs every Monday morning (or manually) and loads the MCP server URL, ticker list, SEC User-Agent string, and reporting limits from workflow settings. 2. Calls the SEC EDGAR MCP server to verify it exposes the required tools, then reads the existing riskfactorwatch Data Table to avoid re-reporting the same accession number per ticker. 3. For each ticker, requests the three most recent 10-K filings from the MCP server and selects the newest and prior filing, skipping companies with no new filing since the last run. 4. Fetches both filings’ HTML from SEC EDGAR using the configured User-Agent and extracts Item 1A Risk Factors into cleaned, comparable paragraph lists. 5. Compares this year vs last year paragraphs using token-overlap matching to classify additions, removals, and material rewrites, then keeps only the changed excerpts up to the configured cap. 6. Saves the counts for tickers with changes back to the riskfactorwatch Data Table and sends the changed paragraphs to OpenAI to produce a short, themed explanation. 7. Creates a new Google Doc and appends a single combined report covering all tickers with meaningful risk-factor changes, including links to the filings. Setup 1. Start the SEC EDGAR MCP server (for example: npx -y [email protected] --http --host 0.0.0.0 --port 8932) and set mcpurl in Settings to the reachable /mcp endpoint. 2. Update secuseragent in Settings to include your own contact email to avoid SEC 403 responses when fetching filing HTML. 3. Create an n8n Data Table named riskfactorwatch with columns ticker, accession, filedon, added, removed, and rewritten. 4. Add an OpenAI API credential (Chat model) and a Google Docs credential, then set your target docsfolder and the comma-separated tickers list in Settings.