{"product_id":"ai-tender-triage-workflow-openai-scoring-to-google-sheets","title":"AI Tender Triage Workflow: OpenAI Scoring to Google Sheets","description":"\u003ch3\u003eAI Tender Triage in n8n: OpenAI Scoring → Google Sheets + Bid Manager Email\u003c\/h3\u003e\n\u003cp\u003eStop guessing which tenders are worth the paperwork. This \u003cstrong\u003eAI Tender Triage workflow\u003c\/strong\u003e automatically scores every incoming tender using \u003cstrong\u003egpt-6-luna (0–100)\u003c\/strong\u003e, flags risks, logs the decision to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails the \u003cstrong\u003ebid manager\u003c\/strong\u003e the verdict and what to double-check. A \u003cstrong\u003eMonday digest\u003c\/strong\u003e keeps due tenders visible and on track.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives new tenders\u003c\/strong\u003e via an n8n \u003cstrong\u003eWebhook\u003c\/strong\u003e (“When Tender Received”, POST path \u003cem\u003etender-intake-0925\u003c\/em\u003e) from a form, CRM, or script.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates inputs\u003c\/strong\u003e: trims fields like tender title, client, due date, estimated value, tender summary, source URL, and bid manager email; creates a \u003cstrong\u003etender_id\u003c\/strong\u003e (TD- + timestamp + 4-digit random suffix) and a \u003cstrong\u003ereceived_at\u003c\/strong\u003e timestamp; checks required fields are present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores fit and flags risks\u003c\/strong\u003e: for validated tenders, calls \u003cstrong\u003egpt-6-luna\u003c\/strong\u003e to score fit from \u003cstrong\u003e0 to 100\u003c\/strong\u003e and recommend \u003cstrong\u003ebid\u003c\/strong\u003e, \u003cstrong\u003eno_bid\u003c\/strong\u003e, or \u003cstrong\u003eneeds_review\u003c\/strong\u003e. It also outputs strengths, risks, key requirements, and a \u003cstrong\u003edeadline risk\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecords decisions\u003c\/strong\u003e: logs every assessment to the \u003cstrong\u003e“Tenders”\u003c\/strong\u003e tab in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies the right person\u003c\/strong\u003e: emails the bid manager the verdict plus the specific requirements they should check. For \u003cstrong\u003eno-bid\u003c\/strong\u003e outcomes, it sends a short note explaining why the company passed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors pipeline timing\u003c\/strong\u003e: a \u003cstrong\u003eMonday digest\u003c\/strong\u003e lists tenders still being tracked that are 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 automating intake from web forms or CRM exports and reducing manual screening.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking tender pipeline health with scheduled “due soon” summaries.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing an auditable workflow that records AI triage outcomes to Google Sheets.\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 (POST \u003cem\u003etender-intake-0925\u003c\/em\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e (tender_id \/ received_at generation and field handling)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIf\u003c\/strong\u003e (required-field validation and routing)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSet\u003c\/strong\u003e (data normalization)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI (gpt-6-luna)\u003c\/strong\u003e (fit scoring + bid\/no-bid\/needs_review plus risks and requirements)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (emailing bid manager verdicts)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (logging to “Tenders” tab)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky note\u003c\/strong\u003e (workflow guidance\/documentation)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eLast updated: October 2026.\u003c\/em\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192877076659,"sku":"N8N-20448","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RPxkLZgX4BCsPBBnKpuGc_5DPVcWnW.png?v=1791538088","url":"https:\/\/buyflowscripts.com\/products\/ai-tender-triage-workflow-openai-scoring-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}