n8n Workflow: Track US Congress Stock Trades to Google Sheets

Track US Congress stock trades in Google Sheets—automatically

This n8n workflow runs every Monday to fetch recent US Congress stock trade disclosures for your watchlist from Apify, then appends clean, spreadsheet-ready transaction rows into Google Sheets for ongoing tracking.

What this workflow does

Designed for reliable, scheduled monitoring, it works like this:

• Runs on a schedule: executes every Monday at 08:00.
• Loads your tracking settings: uses your ticker watchlist, a lookback window, and maximum results per ticker.
• Queries Apify per ticker: calls the Apify actor “us-congress-financial-disclosures-and-stock-trading-data” for the selected date range.
• Filters incomplete entries: removes results that don’t include both a ticker symbol and a transaction date.
• Formats for spreadsheets: converts each disclosure into fields including member, chamber, transaction type, amount range, and a filing link when available.
• Appends rows to Google Sheets: writes one row per transaction into your chosen Google Sheets tab.

Use cases

• Stay current on US Congress stock trades relevant to specific tickers.
• Maintain an auditable Google Sheets log for compliance research and periodic reviews.
• Use n8n automation to regularly refresh a dashboard-ready dataset without manual data collection.

Technical details

• Scheduling: n8n schedule set to Monday 08:00.
• Apify integration: uses Apify via the apifyn8n-nodes-apify node to run us-congress-financial-disclosures-and-stock-trading-data.
• Data handling nodes: Set, Filter, Split Out, plus a Sticky Note for workflow documentation.
• Google Sheets: OAuth-authenticated append step to a selected spreadsheet and sheet tab.
• Setup requirements: add your Apify API token as an Apify credential, configure Google Sheets OAuth, and update watchlist tickers, lookbackDays, and maxResultsPerTicker.