This Sheetgo template helps you track products that are lent out and returned. It centralizes product records in one spreadsheet, automates barcode label generation, and provides dashboards so you can monitor lending activities with ease.

How the Workflow is Structured

The workflow has:

Register product form – Add new products to the inventory, including SKU and name.
Issue product form – Record when a product is lent out. Based on the SKU, product details auto-fill.
Return product form – Record when a product is returned. Only the SKU needs to be submitted; other fields are auto-filled.
Inventory lending spreadsheet – Stores all responses in structured tabs to track registered, issued, and returned products.
Print labels sheet – Generates barcode labels for products to simplify tracking.
Dashboard – Provides visibility into product status, total issued items, and returns.

Steps to use the template

Step 1: Install the Template

Install the template from this link: Inventory lending
Once installed, the workflow will open in your Sheetgo workspace at app.sheetgo.com.
You’ll see helpful notes in the right-side panel of your workflow.

Note: Before starting, delete the sample data in the spreadsheet tabs (but keep the headers and formulas).

Step 2: Share your workflow and forms

Share the Register product form with team members responsible for adding new products.
Share the Issue product form with staff who lend products.
Share the Return product form with staff who record product returns.

New entries will automatically appear in the corresponding tabs of the Inventory lending spreadsheet.

Step 3: Register products

Register product form

SKU – Enter a unique SKU for the product.
Status – If “SKU exists,” the product is already registered. If not, enter a new SKU and add details.
Product name – Enter the product name.

All responses are saved in the Products tab of the spreadsheet.

In short: Use this form to register new products. If the SKU already exists, you don’t need to register it again.

Step 4: Issue products

Issue product form

Product barcode (SKU) – Enter or scan the SKU.
Status – If “Product issued,” the product is already out. If blank, continue to issue.
Product name – Auto-fills based on the SKU.
Borrower name – Enter the name of the borrower.
Address – Enter borrower’s address (optional).
Issue date – Select the date the product is issued.
Due date – Select the expected return date.

All responses are saved in the Issue tab of the spreadsheet.

In short: Use this form to record when products are lent out. Product details auto-fill from the SKU.

Step 5: Return products

Return product form

Product barcode (SKU) – Enter or scan the SKU.
Status – If “Product returned,” the item is marked as returned.
Product name – Auto-fills based on the SKU.
Borrower name – Auto-fills.
Address – Auto-fills.
Due date – Auto-fills.
Return date – Select the date when the product is returned.

All responses are saved in the Return tab of the spreadsheet.

In short: To return a product, just submit the SKU. All details will auto-fill automatically.

Step 6: Update your connections

Open the workflow and click Run all automations.

Step 7: Print labels

Use the Print labels sheet connected to your workflow to generate barcode or QR code labels for your items. This makes tracking and scanning easier.

Open the Print labels spreadsheet from your workflow.
When opening for the first time, you may see a yellow warning asking for permissions.
- Click Allow access to enable the formulas that generate barcodes or QR codes.
Go to the Print option tab:
- In Column H, select the item from the dropdown list.
- In Column I, enter the quantity of labels you want to generate.
- Once selected, the SKU will automatically appear in Columns G.
View print labels (Don't edit):
- Go to the "View print labels" tab.
- Here, all SKUs with their corresponding barcodes will be displayed, based on your selections in the "Print option" tab.
- 👀 Preview your barcode labels
- 📝 To align the labels on your print paper:
- ↕️ Adjust row heights
- ↔️Adjust column widths

Note: Do not edit the formulas in these tabs. Only use the dropdowns and input fields as described above.

Step 8: Inventory lending spreadsheet

All data from the forms is stored in this spreadsheet.

Products
- Stores all responses from the Register product form.
Issues
- Stores all responses from the Issue product form.
Returns
- Stores all responses from the Return product form.
Borrowers
- This tab lists all borrower names and addresses, generated automatically through formulas when the Issue form is used to capture borrower details.