n8n Webhook Lead Triage to Metrecept + Google Sheets Log

Instant HOT/WARM/COLD Lead Triage—then log the receipt, cache, and costs to Google Sheets

This n8n workflow receives new leads via a Webhook, uses Metrecept to classify them as HOT, WARM, or COLD, and appends a complete decision record—including the Metrecept receipt header string, cache status, and billed USD amount—to Google Sheets.

What this workflow does

• Receives a new lead as a JSON POST request through an n8n Webhook.
• Sends the lead message to Metrecept using /v1/chat/completions to generate a one-line triage result (HOT/WARM/COLD).
• Extracts triage text and reads Metrecept response headers for:
  • cache status
  • billed USD amount
  • signed receipt string
• Fetches live usage totals from /v1/usage (including pipe spend and cache hit/miss counts).
• Appends a new row to Google Sheets with lead details, model used, triage output, cache/cost fields, the receipt string, and the usage snapshot.

Use cases

• Route inbound form submissions or sales leads to faster follow-up based on HOT/WARM/COLD triage.
• Run cost and caching visibility for Metrecept-powered lead scoring with an audit trail in Google Sheets.
• Track decisions alongside receipt header strings for operational verification (note: the workflow logs the receipt string; it does not verify the signature).

Technical details

• n8n nodes: set, webhook, sticky note, http request, google sheets
• Metrecept integration:
  • /v1/chat/completions for HOT/WARM/COLD triage
  • /v1/usage for live usage snapshot
• Auth setup: HTTP Header credential with Authorization: Bearer <key> for both Metrecept requests
• Google Sheets: OAuth to append rows to your chosen spreadsheet/sheet

Input requirement: your webhook POST body should include at least email and message.