{"product_id":"n8n-workflow-track-us-congress-stock-trades-to-google-sheets","title":"n8n Workflow: Track US Congress Stock Trades to Google Sheets","description":"\u003ch3\u003eTrack US Congress stock trades in Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eDesigned for reliable, scheduled monitoring, it works like this:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes every Monday at \u003cstrong\u003e08:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your tracking settings:\u003c\/strong\u003e uses your \u003cem\u003eticker watchlist\u003c\/em\u003e, a \u003cem\u003elookback window\u003c\/em\u003e, and \u003cem\u003emaximum results per ticker\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries Apify per ticker:\u003c\/strong\u003e calls the Apify actor \u003cstrong\u003e“us-congress-financial-disclosures-and-stock-trading-data”\u003c\/strong\u003e for the selected date range.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters incomplete entries:\u003c\/strong\u003e removes results that don’t include both a \u003cstrong\u003eticker symbol\u003c\/strong\u003e and a \u003cstrong\u003etransaction date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats for spreadsheets:\u003c\/strong\u003e converts each disclosure into fields including \u003cstrong\u003emember\u003c\/strong\u003e, \u003cstrong\u003echamber\u003c\/strong\u003e, \u003cstrong\u003etransaction type\u003c\/strong\u003e, \u003cstrong\u003eamount range\u003c\/strong\u003e, and a \u003cstrong\u003efiling link\u003c\/strong\u003e when available.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows to Google Sheets:\u003c\/strong\u003e writes \u003cstrong\u003eone row per transaction\u003c\/strong\u003e into your chosen Google Sheets tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStay current on \u003cstrong\u003eUS Congress stock trades\u003c\/strong\u003e relevant to specific tickers.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e log for compliance research and periodic reviews.\u003c\/li\u003e\n  \u003cli\u003eUse n8n automation to regularly refresh a dashboard-ready dataset without manual data collection.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e n8n schedule set to Monday \u003cstrong\u003e08:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e uses \u003cstrong\u003eApify\u003c\/strong\u003e via the \u003cstrong\u003eapifyn8n-nodes-apify\u003c\/strong\u003e node to run \u003cstrong\u003eus-congress-financial-disclosures-and-stock-trading-data\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData handling nodes:\u003c\/strong\u003e \u003cstrong\u003eSet\u003c\/strong\u003e, \u003cstrong\u003eFilter\u003c\/strong\u003e, \u003cstrong\u003eSplit Out\u003c\/strong\u003e, plus a \u003cstrong\u003eSticky Note\u003c\/strong\u003e for workflow documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e OAuth-authenticated append step to a selected spreadsheet and sheet tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e add your \u003cstrong\u003eApify API token\u003c\/strong\u003e as an Apify credential, configure \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e, and update \u003cstrong\u003ewatchlist tickers\u003c\/strong\u003e, \u003cstrong\u003elookbackDays\u003c\/strong\u003e, and \u003cstrong\u003emaxResultsPerTicker\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741422870707,"sku":"N8N-17594","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/8fZYOLt4QgQrDJ4ontAAq_8hYSAF0M.png?v=1785316333","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-us-congress-stock-trades-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}