{"product_id":"n8n-workflow-pharmacy-expiry-triage-with-google-sheets-slack-gmail","title":"n8n Workflow: Pharmacy Expiry Triage with Google Sheets, Slack \u0026 Gmail","description":"\u003ch3\u003ePrevent pharmacy expiry losses with automated triage—Slack approval first, then Gmail transfer\/return emails.\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every day at \u003cstrong\u003e6AM\u003c\/strong\u003e to analyze pharmacy inventory in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, predict \u003cstrong\u003eexpiry risk\u003c\/strong\u003e using recent sales velocity and FEFO-based logic, and request a pharmacist’s go-ahead in \u003cstrong\u003eSlack\u003c\/strong\u003e before any \u003cstrong\u003eGmail\u003c\/strong\u003e transfer\/return actions are sent.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration\u003c\/strong\u003e (Google Sheets document ID, expiry horizon, and email override) on each daily run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads operational data\u003c\/strong\u003e from Google Sheets, including inventory batches, sales history, branch stock, and supplier return policies.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates expiry risk\u003c\/strong\u003e by combining sales velocity with \u003cstrong\u003eFEFO-based\u003c\/strong\u003e expiry risk, then flags safety\/compliance constraints.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrioritizes at-risk batches\u003c\/strong\u003e and recommends actions such as \u003cem\u003etransfer\u003c\/em\u003e, \u003cem\u003ereturn\u003c\/em\u003e, \u003cem\u003ediscount\u003c\/em\u003e, or \u003cem\u003edispose\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a pharmacist briefing\u003c\/strong\u003e using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (a 3-line summary), posts it to \u003cstrong\u003eSlack\u003c\/strong\u003e, and presents an \u003cstrong\u003eApprove\/Reject\u003c\/strong\u003e prompt with a preview of the top actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs every decision\u003c\/strong\u003e to a Google Sheets \u003cstrong\u003eAction_Queue\u003c\/strong\u003e tab, appending an audit trail row per proposed action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOn approval\u003c\/strong\u003e, routes each action to the correct outcome: sends \u003cstrong\u003estock-transfer emails\u003c\/strong\u003e to the receiving branch via \u003cstrong\u003eGmail\u003c\/strong\u003e, sends \u003cstrong\u003esupplier return requests\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e, or posts a \u003cstrong\u003emanual compliance alert\u003c\/strong\u003e to Slack for controlled drugs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates reorder controls\u003c\/strong\u003e and marks batches as \u003cstrong\u003eACTIONED\u003c\/strong\u003e or \u003cstrong\u003eQUARANTINED\u003c\/strong\u003e in Google Sheets after processing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily expiry triage across multiple pharmacy branches with consistent FEFO prioritization.\u003c\/li\u003e\n  \u003cli\u003eSupplier return coordination that requires pharmacist approval before emails are sent.\u003c\/li\u003e\n  \u003cli\u003eControlled-drug compliance alerts routed to Slack while keeping an auditable action queue in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/tools: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46190243676339,"sku":"N8N-20618","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mL_aBLwzMTrMjUr8WYWgD_a6B0HJ0p.png?v=1791451124","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-pharmacy-expiry-triage-with-google-sheets-slack-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}