n8n Workflow: Track Insider & Congressional Trades w/ EDGAR & House

Automatically track insider + Congressional trades with EDGAR & House filings

This n8n workflow runs every 45 minutes to monitor U.S. House periodic transaction reports from House.gov and insider Form 4 filings from the SEC EDGAR Atom feed, enriches each record by extracting trade details from linked documents, deduplicates against your Google Sheets log, and sends email alerts via Gmail—so you never miss new trades.

What this workflow does

• Scheduled monitoring: Triggers on a 45-minute interval.
• Fetch House periodic reports: Downloads the latest House annual disclosure ZIP link (via ScrapeUnblocker), decompresses it, and parses the XML/TSV contents to build a list of PTR filing records with PDF URLs.
• Fetch SEC Form 4 filings: Pulls the latest entries from the EDGAR Atom feed 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.
• Enrich + extract from PDFs: 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.
• Deduplicate + recency control: Removes items already logged in a Google Sheets “Trade Log,” deduplicates within the run, and drops filings older than the configured recency window.
• Log + alert: Appends newly detected filings to Google Sheets and emails a formatted alert for each new record using Gmail.

Use cases

• Investor/analyst tooling for monitoring insider and Congressional trading activity.
• SaaS operators building timely “new filings” notifications for users.
• Automation engineers maintaining an audit-friendly trade log with deduping and recency limits.

Technical details

• Integrations: ScrapeUnblocker, SEC EDGAR (sec.gov) via Atom feed + HTTP, Google Sheets, Gmail.
• Workflow nodes/logic: if, code, no op, merge, switch.
• Setup: Add credentials for ScrapeUnblocker, Google Sheets, and Gmail; configure the destination email in the Gmail node.