Premarket ETF Proxy Summaries Bot (Twelve Data + GPT-4o) via Gmail

Send Ready-to-Post Premarket ETF Proxy Summaries to Your Inbox—Automatically

The Premarket ETF Proxy Summaries Bot (Twelve Data + GPT-4o) via Gmail is an n8n workflow that runs every weekday to pull premarket quote data for major U.S. ETF proxies, generates a FinTwit-style X post from that data, validates the final text, and emails it to you using Gmail.

What this workflow does

• Runs on a weekday schedule via an n8n cron trigger (15:00, Monday–Friday).
• Pulls premarket quotes for SPY, QQQ, DIA, and IWM using the Twelve Data /quote API.
• Normalizes the response into a structured marketSummary including full proxy names, prices, and percent/point changes.
• Generates a plain-text X update with OpenAI (configured for gpt-4o-mini), using only the provided marketSummary and a strict formatting/length prompt.
• Cleans and validates output by removing markdown/bullets and enforcing a non-empty 600-character maximum (no placeholders).
• Sends the final post via Gmail to a specified recipient using Gmail OAuth2.

Use cases

• Automate your daily FinTwit-style X premarket updates without manually compiling SPY/QQQ/DIA/IWM movers.
• Help SaaS operators or automation engineers demo “data-to-social” workflows with Twelve Data and OpenAI.
• Use the emailed output as a draft you can quickly review and post—on a consistent weekday cadence.

Technical details

• Nodes/tech stack: code, sticky note, http request, n8nn8n-nodes-langchainagent, schedule trigger, and gmail.
• Integrations: Twelve Data (HTTP request to /quote), OpenAI (GPT-4o-mini), Gmail (OAuth2 send).
• Setup steps: add your Twelve Data API key, configure OpenAI credentials/model, connect Gmail OAuth2, and set the recipient email; adjust the cron expression if needed.