What This Workflow Does
This automated workflow solves the challenge of manually tracking stock trades by US Congress members, which is crucial for identifying potential conflicts of interest but traditionally requires tedious daily monitoring of multiple government websites.
The system scrapes recent high-value congressional stock trades from Quiver Quantitative using Firecrawl, analyzes the transactions with OpenAI to identify noteworthy patterns and potential conflicts, then delivers concise email reports summarizing the most significant trades through Gmail.
How It Works
1. Data Collection
Firecrawl scrapes the latest congressional trading data from Quiver Quantitative's API, capturing details like transaction dates, stock symbols, trade values, and the lawmakers involved.
2. AI Analysis
OpenAI processes the raw trading data to identify noteworthy transactions, flag potential conflicts based on committee assignments, and generate human-readable summaries highlighting key insights.
3. Report Generation
The workflow organizes the analyzed data into a structured report format, prioritizing high-value trades and potential conflicts for immediate attention.
4. Email Delivery
Gmail sends the finalized report to designated recipients on a daily schedule, ensuring stakeholders receive timely updates without manual effort.
Pro tip: Configure the workflow to run before market hours to give recipients time to research flagged trades before trading begins.
Who This Is For
This automation is ideal for financial journalists tracking potential market-moving congressional trades, watchdog organizations monitoring government ethics compliance, investment firms analyzing political insights, and political researchers studying patterns in congressional trading behavior.
What You'll Need
- n8n instance (self-hosted or cloud)
- Firecrawl API access
- OpenAI API key
- Gmail account with API access
- Quiver Quantitative API credentials
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Configure API credentials for all services
- Set recipient email addresses
- Adjust analysis parameters as needed
- Test with sample data
- Schedule daily execution
Key Benefits
Saves 5-10 hours weekly by automating what would otherwise require daily manual research across multiple government websites.
Identifies conflicts faster with AI-powered analysis that flags potential issues human reviewers might miss.
Provides consistent reporting with standardized formats that make trends easier to spot over time.
Delivers timely alerts about potentially market-moving trades before they become widely known.
Creates audit trails by maintaining organized records of congressional trading activity.