AutomationMart
Home/Browse/🏛️ Daily US Congress members stock trades report via Firecrawl + OpenAI + Gmail
n8n

🏛️ Daily US Congress members stock trades report via Firecrawl + OpenAI + Gmail

n8nn8n10 modulesv1.0
GmailOpenAI

What This Workflow Does This workflow automatically scrapes recent high-value congressional stock trades from Quiver Quantitative, summarizes the key transactions, and delivers a neatly formatted report to your inbox — every single day. It combines Firecrawl's powerful content extraction, OpenAI's GPT formatting, and n8n's automation engine to turn raw HTML data into a digestible, human-readable email. Watch Full Tutorial on how to build this workflow here: 🔧 How It Works 🕒 Schedule Trigger Fire

At a glance

🏛️ Daily US Congress members stock trades report via Firecrawl + OpenAI + Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, OpenAI
Modules
10
Price
Free
Version
v1.0
🏛️ Daily US Congress members stock trades report via Firecrawl + OpenAI + Gmail workflow diagram

About this workflow

What This Workflow Does This workflow automatically scrapes recent high-value congressional stock trades from Quiver Quantitative, summarizes the key transactions, and delivers a neatly formatted report to your inbox — every single day. It combines Firecrawl's powerful content extraction, OpenAI's GPT formatting, and n8n's automation engine to turn raw HTML data into a digestible, human-readable email. Watch Full Tutorial on how to build this workflow here: 🔧 How It Works 🕒 Schedule Trigger Fires daily at a set hour (e.g., 6 PM) to begin the data pipeline. 🔥 Firecrawl Extract API (POST) Targets the Quiver Quantitative “Congress Trading” page and sends a structured prompt asking for all trades over $50K in the past month. ⏳ Wait Node Allows time for Firecrawl to finish processing before retrieving results. 📥 Firecrawl Get Result API (GET) Retrieves the extracted and structured data. 🧠 OpenAI Chat Model (GPT-4o) Formats the raw trading data into a readable summary that includes: Date of Transaction Stock/Asset traded Amount Congress member’s name and political party 📧 Gmail Node Sends the summary to your inbox with the subject “Congress Trade Updates - QQ”. 🧠 Why This is Useful Congressional trading activity often reveals valuable signals — especially when high-value trades are made. This workflow: Saves time manually tracking Quiver Quant updates Converts complex tables into a daily, readable email Keeps investors, researchers, and newsrooms in the loop — hands-free 🛠 Requirements Firecrawl API Key (with extract access) OpenAI API Key Gmail OAuth2 credentials n8n (self-hosted or cloud) 💬 Sample Output: Congress Trade Summary – May 21 Nancy Pelosi (D) sold TSLA for $85,000 on April 28 John Raynor (R) purchased AAPL worth $120,000 on May 2 ... and more 🪜 Setup Steps Add your Firecrawl, OpenAI, and Gmail credentials in n8n. Adjust the schedule node to your desired time. Customize the OpenAI system prompt if you want a different summary style. Deploy the workflow — and enjoy your daily edge.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Auto-create podcast from YouTube transcript using Dumpling AI and GPT-4o

Who is this for? This workflow is designed for podcast creators, content marketers, and video producers who want to convert YouTube videos into podcast-ready scripts. It's perfect for anyone repurposing long-form content to reach audio-first audiences without manual effort. --- 🧠 What problem is this workflow solving? Creating podcast scripts from YouTube videos manually is time-consuming. This workflow automates the process by pulling transcripts, cleaning the text, organizing the d

Free

AI-powered accounting reports from Sabre EDI with GPT-4 and Pinecone RAG

This workflow automates the process of reading EDI files generated by Sabre, parsing them using an AI Agent, and producing structured accounting reports like: 📌 Accounts Receivable (AR) Summary 📌 Tax and Surcharges Report It also uses Retrieval-Augmented Generation (RAG) to vectorize the Sabre Interface User Record (IUR)—a 154-page technical document—so that the AI agent can reference it when clarification is required while generating reports. ⚙️ Tools & Integrations Used Component:Tool/S

Free

Send an email notification for every new email received in Gmail

Automatically send an email notification for every new email received in Gmail using Make's Google Email modules. Stay updated instantly.

Free

Create personalized responses using ChatGPT and send data via a custom webhook

Automatically generate personalized responses using ChatGPT and send data via a custom webhook. Parse JSON and send data with HTTP action.

Free

Create new companies in EngageBay from email domains retrieved from Clearbit

When a new email is received in Gmail, the email address is sent to Clearbit to be reviewed. If it is has a company domain, and it doesn't exist in EngageBay yet, it is created as a new company in EngageBay.

Free

Move an email to a specific Gmail folder if the sender's email address is found in a Microsoft 365 Excel worksheet

In this template, Make will be looking for senders' email addresses in a Microsoft 365 Excel worksheet and if it finds a match, it will move the email to a specific Gmail folder. Your Microsoft 365 Excel worksheet has to contain headers. The template uses [this worksheet](https://1drv.ms/x/s!AjJKBs6vWrtygQ3YJnn626GROruV?e=B3LnqG).

Free

Advanced Medium API MCP server

ADVANCED USE ONLY - Medium MCP Server (32 operations) 🚨 This workflow is for advanced users only! Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community This MCP server contains 32 operations which is significantly more than the recommended maximum of tools for most AI clients. 🔍 Recommended Alternative for basic use cases Seek a simplified MCP server that utilizes the official n8n tool implementation for Medium

Free

Extract & process specific links from sitemap.xml

Description This workflow reads a sitemap.xml file, extracts all URLs, and allows you to filter out specific types of links—such as PDF files, images, or any other content—based on your needs. Who Is This For? - SEO Specialists looking to analyze specific URLs in their sitemap. - Developers who need to extract links for automated processing. - Content Managers filtering out downloadable assets like PDFs or images. How It Works 1. Fetch sitemap.xml – The workflow reads the sitemap file from a giv

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free