n8n Equipment Checkouts & Returns Workflow: Data Tables, Gmail, Slack

Automate equipment checkouts & returns with an n8n Form + Data Tables + Gmail + Slack

Streamline your equipment lending process with this n8n Equipment Checkouts & Returns Workflow, 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.

What this workflow does

• Captures submissions from an n8n Form where users choose Checkout or Return, enter an asset tag and email, and optionally provide an expected return date.
• Creates an audit log first: every submission is written to the Lending History n8n Data Table before any validation occurs.
• Checks the Asset Registry by looking up the submitted asset tag in the Asset Registry Data Table to determine the current holder and due date.
• Prevents invalid checkouts: 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.
• Records valid checkouts by upserting the registry row with the submitter as holder, setting status to out, and defaulting the due date to 7 days from today when none is provided.
• Handles returns with holder verification: when the submitter matches the recorded holder, the workflow clears the holder and sets status to available. If not, it posts a mismatch alert to Slack and shows a warning.
• Sends receipts and overdue lists: for successful checkouts and matched returns, it queries the Asset Registry for the submitter’s overdue items and emails a Gmail receipt including the overdue list, then shows a confirmation page.

Use cases

• Managing device lending (laptops, tools, peripherals) with automatic due dates and overdue reminders.
• Operational audit trails for every checkout/return attempt via the Lending History Data Table.
• Immediate Slack alerts when someone attempts to return equipment they don’t currently hold.

Technical details

• Nodes/stack: set, form, gmail, slack, switch, data table
• Data storage: n8n Data Tables for Asset Registry and Lending History
• Communication: Gmail for receipts + overdue lists; Slack for holder mismatch alerts