Triage tender bid decisions with GPT-6 Luna and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Gmail, OpenAI Chat Model and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Normalize Tender (Edit Fields (Set)): sets 9 fields: tender_id, received_at, tender_title…
- Read Tracked Tenders (Google Sheets): uses Google Sheets
- Email Error Alert (Gmail): uses Gmail
- Validate Tender Input (If): checks a condition and branches into true / false
- Keep Tracked Tenders (If): checks a condition and branches into true / false
- AI Assess Tender (AI Agent): runs an AI agent, with model: Tender Model
- Email Invalid Tender Notice (Gmail): uses Gmail
- Build Digest Text (Code): runs custom JavaScript code
- Parse Tender Assessment (Code): runs custom JavaScript code
- Email Weekly Digest (Gmail): uses Gmail
…plus 5 more steps. See the full node list below.
Services it uses
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 (10)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Tenders arrive and somebody has to decide whether they are worth the paperwork. This workflow takes each incoming tender, has gpt-6-luna score the fit out of 100 and flag the risks, logs the decision to Google Sheets, and emails the bid manager the verdict…