A step-by-step tutorial to digitize your inventory management in 10 minutes using Google Sheets.
1
1. Create Your Asset Database
Open a new Google Sheet. Create columns for the essential data you need to track, such as 'Asset Name', 'Serial Number', 'Category', and 'Current Location'. List all your items in rows. This spreadsheet will act as your central database.
2
2. Generate and Attach Labels
Open the QR Code Ticket add-on. Map your spreadsheet columns to the ticket fields (e.g., set 'Asset Name' as the title). Generate the QR codes. The add-on will create a PDF containing individual QR labels for each row. Print these labels and stick them physically onto your equipment or storage bins.
3
3. Scan to Track Status
Download the tracking app. Create 'Sessions' in the add-on for different statuses like 'In Stock', 'Checked Out', or 'Maintenance'. When a staff member takes an item, scan the label using the 'Checked Out' session. The app records who scanned it and when, updating your Google Sheet in real-time.
Ready to start?
It takes less than 5 minutes to set up your first event.