{"product_id":"gmail-wholesale-order-validator-w-gpt-4o-google-sheets-n8n","title":"Gmail Wholesale Order Validator w\/ GPT-4o \u0026 Google Sheets (n8n)","description":"\u003ch3\u003eAutomatically validate wholesale orders from Gmail using GPT-4o and your Google Sheets price list\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your inbox for new \u003cstrong\u003ewholesale order\u003c\/strong\u003e emails, uses \u003cstrong\u003eOpenAI (gpt-4o-mini \/ GPT-4o)\u003c\/strong\u003e to extract the order details, validates every line against a \u003cstrong\u003eGoogle Sheets PriceList\u003c\/strong\u003e, and then sends either an \u003cstrong\u003eorder confirmation\u003c\/strong\u003e or a \u003cstrong\u003erevision request\u003c\/strong\u003e—while logging everything and alerting your order desk via \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail every minute\u003c\/strong\u003e for unread messages matching the filter: \u003cem\u003eis:unread subject:(wholesale order)\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes key email fields\u003c\/strong\u003e (sender, subject, received time, and body text). Very short emails are routed to an \u003cstrong\u003eerror log\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured order data with OpenAI\u003c\/strong\u003e (customer details, PO number, delivery date, notes, and line items) from the email body.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates lines against Google Sheets\u003c\/strong\u003e by loading the \u003cstrong\u003ePriceList\u003c\/strong\u003e tab and checking: valid SKUs, active status, case-pack multiples, and any quoted price mismatches.\u003c\/li\u003e\n  \u003cli\u003eIf problems are found, it \u003cstrong\u003eemails a revision request\u003c\/strong\u003e to the customer listing the issues, \u003cstrong\u003elogs the order\u003c\/strong\u003e to the \u003cstrong\u003eOrders\u003c\/strong\u003e tab, and \u003cstrong\u003ealerts the order desk\u003c\/strong\u003e via Telegram.\u003c\/li\u003e\n  \u003cli\u003eIf no issues are found, it \u003cstrong\u003eemails an order confirmation\u003c\/strong\u003e (with priced lines), \u003cstrong\u003elogs the order\u003c\/strong\u003e, and \u003cstrong\u003ealerts via Telegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarks the original Gmail message as read\u003c\/strong\u003e after the order is logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly digest:\u003c\/strong\u003e Every Monday at \u003cstrong\u003e08:00\u003c\/strong\u003e, it reads the past week’s \u003cstrong\u003eOrders\u003c\/strong\u003e, uses OpenAI to generate a short digest email, sends it via Gmail, and posts a Telegram summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate wholesale order intake and reduce manual SKU\/price checking.\u003c\/li\u003e\n  \u003cli\u003eCatch quoting and packaging issues early by validating case-pack multiples and price mismatches.\u003c\/li\u003e\n  \u003cli\u003eKeep operations informed with Telegram alerts plus a Monday digest.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow\u003c\/strong\u003e with nodes including: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e for order extraction and digest generation.\u003c\/li\u003e\n  \u003cli\u003eReads and writes \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tabs: \u003cstrong\u003ePriceList\u003c\/strong\u003e and \u003cstrong\u003eOrders\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029348372659,"sku":"N8N-19606","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1fBk-P7QjRoppeUDvvutI_zONHlaoC.png?v=1789463269","url":"https:\/\/buyflowscripts.com\/products\/gmail-wholesale-order-validator-w-gpt-4o-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}