{"product_id":"n8n-equipment-checkouts-returns-workflow-data-tables-gmail-slack","title":"n8n Equipment Checkouts \u0026 Returns Workflow: Data Tables, Gmail, Slack","description":"\u003ch3\u003eAutomate equipment checkouts \u0026amp; returns with an n8n Form + Data Tables + Gmail + Slack\u003c\/h3\u003e\n\u003cp\u003eStreamline your equipment lending process with this \u003cstrong\u003en8n Equipment Checkouts \u0026amp; Returns Workflow\u003c\/strong\u003e, which records every request in an audit trail, updates your asset registry, sends Gmail receipts (including overdue reminders), and alerts Slack when a return attempt doesn’t match the recorded holder.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures submissions\u003c\/strong\u003e from an \u003cstrong\u003en8n Form\u003c\/strong\u003e where users choose \u003cem\u003eCheckout\u003c\/em\u003e or \u003cem\u003eReturn\u003c\/em\u003e, enter an \u003cstrong\u003easset tag\u003c\/strong\u003e and \u003cstrong\u003eemail\u003c\/strong\u003e, and optionally provide an \u003cstrong\u003eexpected return date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates an audit log first\u003c\/strong\u003e: every submission is written to the \u003cstrong\u003eLending History\u003c\/strong\u003e \u003cstrong\u003en8n Data Table\u003c\/strong\u003e before any validation occurs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks the Asset Registry\u003c\/strong\u003e by looking up the submitted asset tag in the \u003cstrong\u003eAsset Registry\u003c\/strong\u003e \u003cstrong\u003eData Table\u003c\/strong\u003e to determine the current holder and due date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents invalid checkouts\u003c\/strong\u003e: if the asset is already checked out, the workflow rejects the checkout and displays the current holder and due date on the form completion page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecords valid checkouts\u003c\/strong\u003e by upserting the registry row with the submitter as holder, setting status to \u003cem\u003eout\u003c\/em\u003e, and defaulting the due date to \u003cstrong\u003e7 days from today\u003c\/strong\u003e when none is provided.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles returns with holder verification\u003c\/strong\u003e: when the submitter matches the recorded holder, the workflow clears the holder and sets status to \u003cem\u003eavailable\u003c\/em\u003e. If not, it posts a mismatch alert to \u003cstrong\u003eSlack\u003c\/strong\u003e and shows a warning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends receipts and overdue lists\u003c\/strong\u003e: for successful checkouts and matched returns, it queries the Asset Registry for the submitter’s overdue items and emails a \u003cstrong\u003eGmail receipt\u003c\/strong\u003e including the overdue list, then shows a confirmation page.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eManaging device lending (laptops, tools, peripherals) with automatic due dates and overdue reminders.\u003c\/li\u003e\n  \u003cli\u003eOperational audit trails for every checkout\/return attempt via the Lending History Data Table.\u003c\/li\u003e\n  \u003cli\u003eImmediate Slack alerts when someone attempts to return equipment they don’t currently hold.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/stack:\u003c\/strong\u003e set, form, gmail, slack, switch, data table\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e n8n Data Tables for \u003cem\u003eAsset Registry\u003c\/em\u003e and \u003cem\u003eLending History\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCommunication:\u003c\/strong\u003e Gmail for receipts + overdue lists; Slack for holder mismatch alerts\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837457162419,"sku":"N8N-18261","price":18.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZZWy0ESGxYGNWYkLWuBla_sYcpbmh0.png?v=1786794545","url":"https:\/\/buyflowscripts.com\/products\/n8n-equipment-checkouts-returns-workflow-data-tables-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}