{"product_id":"n8n-workflow-low-stock-purchase-orders-via-google-sheets-slack-openai","title":"n8n Workflow: Low Stock Purchase Orders via Google Sheets, Slack \u0026 OpenAI","description":"\u003ch3\u003eAutomatically detect low stock, generate Slack purchase orders with OpenAI, and update your inventory—right from Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your Google Sheets inventory, identifies products that are at (or below) their reorder threshold, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to draft a concise purchase order message, and posts reorder notifications to \u003cstrong\u003eSlack\u003c\/strong\u003e. It then updates your inventory records and logs reorder activity in a dedicated \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e (or via an optional, disabled \u003cstrong\u003e4-hour schedule\u003c\/strong\u003e) and reads all products from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e \u003cem\u003eInventory\u003c\/em\u003e worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses products row-by-row\u003c\/strong\u003e: calculates stock percentage, determines an urgency level, computes reorder quantity and estimated cost, and updates the product’s \u003cstrong\u003eLast Checked\u003c\/strong\u003e date in the sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReorder decision logic\u003c\/strong\u003e: if a product is at\/below its \u003cstrong\u003eReorder Threshold\u003c\/strong\u003e and it hasn’t already been reordered today, the workflow sends product + supplier details to \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a concise purchase order message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack notifications\u003c\/strong\u003e: posts the generated purchase order message to a designated \u003cstrong\u003eSlack reorder channel\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInventory \u0026amp; audit trail updates\u003c\/strong\u003e: writes the reorder date back to the inventory row, increments \u003cstrong\u003eReorder Count\u003c\/strong\u003e, appends a record to \u003cstrong\u003eGoogle Sheets Reorder_Log\u003c\/strong\u003e, and posts a completion summary to a \u003cstrong\u003eSlack summary channel\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who track stock in Google Sheets and want automated reorder alerts in Slack.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing an n8n workflow for \u003cstrong\u003elow stock purchase order generation\u003c\/strong\u003e with an OpenAI-written message.\u003c\/li\u003e\n  \u003cli\u003eTeams that require a reorder log for visibility and basic inventory auditing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Slack, OpenAI\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e (plus workflow control nodes like an error trigger and sticky notes)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e add Google Sheets credentials, configure the \u003cem\u003eInventory\u003c\/em\u003e and \u003cem\u003eReorder_Log\u003c\/em\u003e sheet tabs, and include expected columns (e.g., Product_ID, Current_Stock, Max_Stock, Reorder_Threshold_Pct, supplier details, Last_Reorder_Date, Reorder_Count). Add an \u003cstrong\u003eOpenAI API key\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45755361394867,"sku":"N8N-17724","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bpWGjKdywQMF1TxWANcbk_jgXNDa99.png?v=1785661562","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-low-stock-purchase-orders-via-google-sheets-slack-openai","provider":"N8N Commerce","version":"1.0","type":"link"}