{"product_id":"n8n-tender-triage-automation-gpt-scoring-risks-sheets","title":"n8n Tender Triage Automation: GPT Scoring, Risks \u0026 Sheets","description":"\u003ch3\u003eAutomatically triage new tenders—score fit, flag risks, log to Sheets, and email the bid verdict\u003c\/h3\u003e\n\u003cp\u003eStop wasting hours manually reviewing tender paperwork. This n8n workflow ingests every incoming tender via a webhook, uses \u003cstrong\u003eGPT-6-luna\u003c\/strong\u003e to score fit out of \u003cstrong\u003e100\u003c\/strong\u003e and flag risks, records the outcome in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails the bid manager the verdict plus the exact requirements to check—then sends a \u003cstrong\u003eMonday digest\u003c\/strong\u003e for due soon tracking.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives tenders via Webhook\u003c\/strong\u003e: A POST webhook (“When Tender Received”) on path \u003cstrong\u003etender-intake-0925\u003c\/strong\u003e accepts tender payloads from a form, CRM, or script.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates inputs\u003c\/strong\u003e: The workflow trims key fields (tender title, client name, due date, estimated value, summary, source URL, bid manager email), builds a \u003cstrong\u003etender_id\u003c\/strong\u003e (TD- + timestamp + 4-digit suffix), and adds \u003cstrong\u003ereceived_at\u003c\/strong\u003e. It checks required fields are present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGPT scoring and decisioning\u003c\/strong\u003e: For validated tenders, \u003cstrong\u003egpt-6-luna\u003c\/strong\u003e generates a fit score (0–100) and recommends \u003cstrong\u003ebid\u003c\/strong\u003e, \u003cstrong\u003eno_bid\u003c\/strong\u003e, or \u003cstrong\u003eneeds_review\u003c\/strong\u003e, including strengths, risks, key requirements, and a \u003cstrong\u003edeadline risk\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs decisions to Google Sheets\u003c\/strong\u003e: Every assessment is written to the \u003cstrong\u003e“Tenders”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail the bid manager\u003c\/strong\u003e: The bid manager receives the verdict and the requirements to check. \u003cstrong\u003eNo-bid\u003c\/strong\u003e tenders include a short explanation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonday digest for active tracking\u003c\/strong\u003e: A weekly digest highlights tenders due within \u003cstrong\u003e14 days\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBid teams receiving frequent tenders and needing consistent, fast triage.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying an n8n tender pipeline with GPT-based scoring.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking submissions and due dates with audit-friendly Google Sheets logging.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e (path: \u003cem\u003etender-intake-0925\u003c\/em\u003e) → \u003cstrong\u003eNormalize Tender\u003c\/strong\u003e (if\/set\/code) → GPT scoring (\u003cstrong\u003egpt-6-luna\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e logging to the \u003cstrong\u003e“Tenders”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e email notifications to the bid manager.\u003c\/li\u003e\n  \u003cli\u003eUses nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eLast updated:\u003c\/strong\u003e October 2026.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192877437107,"sku":"N8N-20447","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/yP81ADgI6d-jiD03M6lbw_migmghKZ.png?v=1791538116","url":"https:\/\/buyflowscripts.com\/products\/n8n-tender-triage-automation-gpt-scoring-risks-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}