{"product_id":"n8n-warranty-claims-triage-openai-sheets-gmail-telegram","title":"n8n Warranty Claims Triage: OpenAI + Sheets + Gmail + Telegram","description":"\u003ch3\u003eAutomate n8n warranty claim triage—OpenAI evaluation, Google Sheets logging, and instant Telegram + email notifications\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives warranty claim submissions via webhook, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to assess eligibility and recommend an outcome, logs every claim to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and coordinates responses through \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e. When needed, it emails customers with the current decision—and delivers a monthly Telegram summary of claims.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives claim data\u003c\/strong\u003e via a POST request to an n8n \u003cstrong\u003ewebhook\u003c\/strong\u003e (customer, product, purchase date, warranty months, and issue).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates inputs\u003c\/strong\u003e, generating a claim ID and timestamp; if required fields are missing, it sends an \u003cem\u003einvalid-claim alert\u003c\/em\u003e to your team in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvaluates warranty eligibility with OpenAI\u003c\/strong\u003e to decide \u003cstrong\u003eapproved\u003c\/strong\u003e, \u003cstrong\u003erejected\u003c\/strong\u003e, or \u003cstrong\u003eneeds review\u003c\/strong\u003e, and to suggest an action (repair\/replace\/refund).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results to Google Sheets\u003c\/strong\u003e: appends the claim and the AI decision details into the \u003cstrong\u003eClaims\u003c\/strong\u003e sheet (in your selected spreadsheet).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies via Telegram and email using Gmail\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf rejected or needs manual review: alerts your team in Telegram and emails the customer the current outcome.\u003c\/li\u003e\n      \u003cli\u003eIf approved: posts an approval confirmation to Telegram.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a monthly summary\u003c\/strong\u003e (on the first day of each month) by reading all claims from Google Sheets, summarizing them with OpenAI, and sending the report to Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHandle warranty submissions from a website or support form without manual triage.\u003c\/li\u003e\n  \u003cli\u003eGive your team a single Telegram feed of rejected\/invalid\/needs-review cases.\u003c\/li\u003e\n  \u003cli\u003eProvide customers timely decision emails while keeping auditable records in 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\u003eNodes \/ tools:\u003c\/strong\u003e webhook, if, set, OpenAI (AI steps), Google Sheets (Claims logging + monthly read), Gmail (customer emails), Telegram (team alerts + confirmations + monthly report), sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfig:\u003c\/strong\u003e connect an OpenAI credential and select a model (default: \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e), then set the Google Sheets spreadsheet ID and “Claims” sheet name with matching columns.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824201425075,"sku":"N8N-18176","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/87ORYlX7QG1KcgBJuNan-_GbcjwPN7.png?v=1786612058","url":"https:\/\/buyflowscripts.com\/products\/n8n-warranty-claims-triage-openai-sheets-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}