Predict F1 Race Winners with OpenAI GPT-4o, Historical Data & Slack Alerts — n8n Workflow

High complexity Scheduled27 nodes🏷️ Miscellaneousby Cheng Siong Chin

Overview

How It Works Every day at 8 AM, the workflow automatically retrieves the latest F1 data—including driver standings, qualifying results, race schedules, and circuit information. All sources are merged into a unified dataset, and driver performance metrics are computed using historical trends. An AI agent, enhanced with vectorized race history, evaluates patterns and generates race-winner predictions. When the confidence score exceeds the defined threshold, the system pushes an automated Slack ale

Nodes used

Google SheetsHTTP RequestPostgresSlackCodeAI AgentEmbeddings OpenAIOpenAI Chat ModelRecursive Character Text SplitterCode ToolSimple Vector StoreDefault Data Loader

Workflow Preview

How It Works
Every day at 8 AM, the workflow automatically retrieves
Setup Steps
1. Update the workflow configuration with: `newsApiUrl`
2. Connect PostgreSQL using the schema:
prediction_date, pre
Use Cases
Applicable for sports analytics dashboards, betting pla
Customization
Extend by adding constructor predictions (modify AI pro
Benefits
Saves time by automating data collection, improves accu
Data Collection
Retrieves live F1 standings, historical results, qualif
Why: Fresh, multi-source data is vital. Standings show
Data Processing
Merges data and calculates 8 driver metrics, including
Why: Metrics reveal patterns raw data
AI Prediction
A LangChain agent (GPT-4o) analyzes the dataset with hi
Why: AI synthesizes complex data at s
Confidence Validation
Compares scores against a 0.75 threshold; high-confiden
Why: Reduces alert fatigue and ensures only reliable in
Driver Performance Metrics
Calculates 8 advanced metrics (podium rate, consistency
Historical Data Vectorization Pipeline
Transforms 3 years of F1 historical data into searchabl
docmodelembedtoolembedtooltooltool
S
Schedule Trigger
W
Workflow Configuration
Fetch Current F1 Season …
Fetch Driver Standings
Fetch Constructor Standi…
Merge F1 Data
F1 Prediction Agent
OpenAI Chat Model
R
Real-Time F1 News Tool
W
Weather Data Tool
F
Format Prediction Output
Fetch Historical Race Re…
Fetch Qualifying Results
Fetch Circuit Information
Historical Data Vector S…
OpenAI Embeddings
Document Loader
Recursive Text Splitter
Historical Data Retrieva…
Calculate Driver Perform…
C
Check Prediction Confide…
Store Prediction in Data…
Send High Confidence Alert
Log to Prediction Tracker
A
Aggregate Historical Data
Statistical Analysis Tool
OpenAI Embeddings1
27 nodes30 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a scheduled trigger, running on a defined schedule.

  2. 2

    Process

    Data flows through 27 nodes, connecting agent, aggregate, code.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (27)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
PO

Postgres

postgres

#3
SL

Slack

slack

#4
CO

Code

code

#5
AI

AI Agent

n8n-nodes-langchain.agent

#6
EM

Embeddings OpenAI

n8n-nodes-langchain.embeddingsOpenAi

#7
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#8
RE

Recursive Character Text Splitter

n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter

#9
CO

Code Tool

n8n-nodes-langchain.toolCode

#10
SI

Simple Vector Store

n8n-nodes-langchain.vectorStoreInMemory

#11
DE

Default Data Loader

n8n-nodes-langchain.documentDefaultDataLoader

#12

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded predict-f1-race-winners-with-openai-gpt-4o-historical-data-slack-alerts file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Predict F1 Race Winners with OpenAI GPT-4o, Historical Data & Slack Alerts", "nodes": [...], ...}

Integrations

agentaggregatecodedocumentdefaultdataloaderembeddingsopenaigooglesheetshttprequesthttprequesttooliflmchatopenaipostgresscheduletriggersetslacktextsplitterrecursivecharactertextsplittertoolcodevectorstoreinmemory

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes27
Complexityhigh
Triggerscheduled

Created by

Cheng Siong Chin

Cheng Siong Chin

@cschin

Tags

agentaggregatecodedocumentdefaultdataloaderembeddingsopenaigooglesheetshttprequesthttprequesttooliflmchatopenai

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →

Related Miscellaneous Workflows