{"product_id":"gmail-purchase-order-automation-with-groq-llm-airtable-sheets","title":"Gmail Purchase Order Automation with Groq LLM, Airtable \u0026 Sheets","description":"\u003ch3\u003eTurn “purchase request” emails into structured Purchase Orders—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Gmail for unread \u003cstrong\u003epurchase request\u003c\/strong\u003e emails, uses a \u003cstrong\u003eGroq LLM\u003c\/strong\u003e to extract urgency and itemized line details into strict JSON, matches items to your \u003cstrong\u003eAirtable\u003c\/strong\u003e catalog for pricing and vendors, and then logs approvals to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e while creating or flagging Purchase Orders in Airtable.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls unread Gmail requests\u003c\/strong\u003e (up to five) filtered by the subject “purchase request,” and normalizes each email into request text plus the requester’s address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured PO data with Groq\u003c\/strong\u003e using n8n’s \u003cstrong\u003eLangChain integration\u003c\/strong\u003e, parsing the output into a strict JSON schema that includes \u003cstrong\u003eurgency\u003c\/strong\u003e and \u003cstrong\u003eitem quantities\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches items to your Airtable catalog\u003c\/strong\u003e using fuzzy matching to assign SKUs, preferred vendors, and contract\/standard pricing—then calculates the total PO cost.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes requests intelligently\u003c\/strong\u003e based on match results and urgency:\n    \u003cul\u003e\n      \u003cli\u003eIf items match and are ready: appends\/updates an approval\/audit entry in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and upserts an \u003cstrong\u003e“Approved - Auto”\u003c\/strong\u003e purchase order in \u003cstrong\u003eAirtable\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eIf matches fail or triage is required: creates\/updates Airtable with \u003cstrong\u003e“Pending Triage”\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eIf marked urgent: creates\/updates Airtable with \u003cstrong\u003e“Pending Urgent Review”\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProcurement teams converting frequent “purchase request” inbox emails into trackable PO records.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want faster approvals for urgent purchases while keeping an audit trail.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing PO creation logic using Groq + Airtable pricing catalogs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth) to fetch unread messages and filter by subject.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq LLM\u003c\/strong\u003e via n8n \u003cstrong\u003eLangChain integration\u003c\/strong\u003e to generate strict JSON (urgency + itemized quantities).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAirtable\u003c\/strong\u003e to load the approved item catalog, perform fuzzy SKU\/vendor matching, and upsert PO records with statuses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to append\/update approval\/audit entries.\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes include: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003eairtable\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46159504081075,"sku":"N8N-20378","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OqULyr_9BHgQWZ6xtO6y__sNAIIzUL.png?v=1791105004","url":"https:\/\/buyflowscripts.com\/products\/gmail-purchase-order-automation-with-groq-llm-airtable-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}