{"product_id":"n8n-webhook-lead-triage-to-metrecept-google-sheets-log","title":"n8n Webhook Lead Triage to Metrecept + Google Sheets Log","description":"\u003ch3\u003eInstant HOT\/WARM\/COLD Lead Triage—then log the receipt, cache, and costs to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives new leads via a Webhook, uses \u003cstrong\u003eMetrecept\u003c\/strong\u003e to classify them as \u003cstrong\u003eHOT\u003c\/strong\u003e, \u003cstrong\u003eWARM\u003c\/strong\u003e, or \u003cstrong\u003eCOLD\u003c\/strong\u003e, and appends a complete decision record—including the \u003cstrong\u003eMetrecept receipt header string\u003c\/strong\u003e, cache status, and billed USD amount—to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a new lead\u003c\/strong\u003e as a JSON POST request through an n8n \u003cstrong\u003eWebhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the lead message to Metrecept\u003c\/strong\u003e using \u003ccode\u003e\/v1\/chat\/completions\u003c\/code\u003e to generate a one-line triage result (HOT\/WARM\/COLD).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts triage text\u003c\/strong\u003e and reads Metrecept response headers for:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003ecache status\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003ebilled USD amount\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003esigned receipt string\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches live usage totals\u003c\/strong\u003e from \u003ccode\u003e\/v1\/usage\u003c\/code\u003e (including pipe spend and cache hit\/miss counts).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a new row\u003c\/strong\u003e to Google Sheets with lead details, model used, triage output, cache\/cost fields, the receipt string, and the usage snapshot.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRoute inbound form submissions or sales leads to faster follow-up based on HOT\/WARM\/COLD triage.\u003c\/li\u003e\n  \u003cli\u003eRun cost and caching visibility for Metrecept-powered lead scoring with an audit trail in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTrack decisions alongside receipt header strings for operational verification (note: the workflow logs the receipt string; it does \u003cem\u003enot\u003c\/em\u003e verify the signature).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: set, webhook, sticky note, http request, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMetrecept integration\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003ccode\u003e\/v1\/chat\/completions\u003c\/code\u003e for HOT\/WARM\/COLD triage\u003c\/li\u003e\n      \u003cli\u003e\n\u003ccode\u003e\/v1\/usage\u003c\/code\u003e for live usage snapshot\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuth setup\u003c\/strong\u003e: HTTP Header credential with \u003ccode\u003eAuthorization: Bearer \u0026lt;key\u0026gt;\u003c\/code\u003e for both Metrecept requests\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth to append rows to your chosen spreadsheet\/sheet\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eInput requirement:\u003c\/strong\u003e your webhook POST body should include at least \u003ccode\u003eemail\u003c\/code\u003e and \u003ccode\u003emessage\u003c\/code\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45985497645235,"sku":"N8N-19411","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rE72yx3CD4h11yn24NpSb_gsIAxu12.png?v=1788944757","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-lead-triage-to-metrecept-google-sheets-log","provider":"N8N Commerce","version":"1.0","type":"link"}