{"product_id":"n8n-workflow-track-insider-congressional-trades-w-edgar-house","title":"n8n Workflow: Track Insider \u0026 Congressional Trades w\/ EDGAR \u0026 House","description":"\u003ch3\u003eAutomatically track insider + Congressional trades with EDGAR \u0026amp; House filings\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every 45 minutes to monitor U.S. House periodic transaction reports from \u003cstrong\u003eHouse.gov\u003c\/strong\u003e and insider \u003cstrong\u003eForm 4\u003c\/strong\u003e filings from the \u003cstrong\u003eSEC EDGAR Atom feed\u003c\/strong\u003e, enriches each record by extracting trade details from linked documents, deduplicates against your Google Sheets log, and sends email alerts via \u003cstrong\u003eGmail\u003c\/strong\u003e—so you never miss new trades.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled monitoring:\u003c\/strong\u003e Triggers on a 45-minute interval.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch House periodic reports:\u003c\/strong\u003e Downloads the latest House annual disclosure ZIP link (via \u003cstrong\u003eScrapeUnblocker\u003c\/strong\u003e), decompresses it, and parses the XML\/TSV contents to build a list of PTR filing records with \u003cstrong\u003ePDF URLs\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch SEC Form 4 filings:\u003c\/strong\u003e Pulls the latest entries from the \u003cstrong\u003eEDGAR Atom feed\u003c\/strong\u003e using direct HTTP with a compliant User-Agent, then retrieves each filing’s SEC index and ownership XML to extract tickers, transaction codes, and estimated trade values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnrich + extract from PDFs:\u003c\/strong\u003e For new House PTR filings, downloads each PTR PDF, extracts text, and parses transaction rows to recover filing ID, member info, ticker, transaction type, amount range, and dates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicate + recency control:\u003c\/strong\u003e Removes items already logged in a Google Sheets “Trade Log,” deduplicates within the run, and drops filings older than the configured recency window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLog + alert:\u003c\/strong\u003e Appends newly detected filings to Google Sheets and emails a formatted alert for each new record using Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eInvestor\/analyst tooling for monitoring insider and Congressional trading activity.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators building timely “new filings” notifications for users.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers maintaining an audit-friendly trade log with deduping and recency limits.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e ScrapeUnblocker, \u003cstrong\u003eSEC EDGAR (sec.gov) via Atom feed + HTTP\u003c\/strong\u003e, Google Sheets, Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes\/logic:\u003c\/strong\u003e if, code, no op, merge, switch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Add credentials for ScrapeUnblocker, Google Sheets, and Gmail; configure the destination email in the Gmail node.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738529489075,"sku":"N8N-17541","price":24.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QNmdd-MvuOXlJ08tCxXoD_Ms9oARod.png?v=1785229834","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-insider-congressional-trades-w-edgar-house","provider":"N8N Commerce","version":"1.0","type":"link"}