{"product_id":"n8n-sec-10-k-10-q-sentiment-bot-openai-google-sheets-slack","title":"n8n SEC 10-K\/10-Q Sentiment Bot: OpenAI + Google Sheets + Slack","description":"\u003ch3\u003eGet Daily SEC 10-K\/10-Q Sentiment Alerts—Automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n SEC 10-K\/10-Q Sentiment Bot\u003c\/strong\u003e checks the SEC EDGAR database every day for the newest 10-K or 10-Q, extracts \u003cstrong\u003eRisk Factors\u003c\/strong\u003e and \u003cstrong\u003eMD\u0026amp;A\u003c\/strong\u003e, runs an \u003cstrong\u003eOpenAI\u003c\/strong\u003e sentiment\/risk analysis, then logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and posts an alert to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns once per day\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003eUses the \u003cstrong\u003eSEC EDGAR submissions API\u003c\/strong\u003e to fetch the latest filing for a target \u003cstrong\u003eCIK\u003c\/strong\u003e and selects the newest \u003cstrong\u003e10-K\u003c\/strong\u003e or \u003cstrong\u003e10-Q\u003c\/strong\u003e, including its document URL.\u003c\/li\u003e\n  \u003cli\u003eChecks \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for the filing’s \u003cstrong\u003eaccessionNumber\u003c\/strong\u003e to avoid duplicate processing.\u003c\/li\u003e\n  \u003cli\u003eIf it’s a new filing, downloads the primary document from SEC EDGAR and extracts the \u003cstrong\u003eRisk Factors\u003c\/strong\u003e and \u003cstrong\u003eManagement’s Discussion and Analysis (MD\u0026amp;A)\u003c\/strong\u003e sections from the filing HTML.\u003c\/li\u003e\n  \u003cli\u003eFilters the extracted text to a keyword-focused subset and sends it to \u003cstrong\u003eOpenAI\u003c\/strong\u003e to return structured \u003cstrong\u003eJSON\u003c\/strong\u003e output (sentiment, risk level, key risks, outlook, and financial highlights).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends\u003c\/strong\u003e filing metadata plus the OpenAI analysis to Google Sheets and sends a formatted \u003cstrong\u003esummary message to Slack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators and analysts who want \u003cstrong\u003eearly visibility\u003c\/strong\u003e into changes in risk and outlook from SEC filings.\u003c\/li\u003e\n  \u003cli\u003eTeams monitoring specific public companies using a \u003cstrong\u003erepeatable n8n automation workflow\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomated reporting pipelines that combine SEC content with AI-generated insights in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSEC EDGAR\u003c\/strong\u003e: submissions endpoint call via HTTP Request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e, plus supporting nodes (including a Sticky Note for guidance).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: generates structured JSON sentiment and risk output from extracted Risk Factors and MD\u0026amp;A text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth-based lookup by accessionNumber and row append for analysis results.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172937846963,"sku":"N8N-20594","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bF8nzCp_Rh99rQERhGqpE_ltVcgl7e.png?v=1791364151","url":"https:\/\/buyflowscripts.com\/products\/n8n-sec-10-k-10-q-sentiment-bot-openai-google-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}