Monitor BOAMP IT tenders and score them with GPT-4o Mini to Supabase
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Supabase. It also calls boamp-datadila.opendatasoft.com and api.openai.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Config (Edit Fields (Set)): sets 1 field: SCORE_THRESHOLD
- Fetch BOAMP IT Tenders (HTTP Request): calls boamp-datadila.opendatasoft.com
- Normalize Tender Data (Code): runs custom JavaScript code
- AI Score Tender (HTTP Request): calls api.openai.com (POST)
- Parse AI Response (Code): runs custom JavaScript code
- Is Hot Opportunity? (If): checks a condition and branches into true / false
- Supabase: uses Supabase
- Supabase: uses Supabase
Services it uses
HTTP calls to: boamp-datadila.opendatasoft.com, api.openai.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Webhook
n8n-nodes-base.webhook - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Supabase
n8n-nodes-base.supabase
From the author
How it works • Fetches IT-related tenders from the French BOAMP API (filter: informatique) • Scores each tender with OpenAI (pertinence, budget, stack, GO/NO-GO) • Routes to Supabase as hot (≥75) or archived • Run the SQL from the "Supabase Schema" sticky…