If a crew member has ever driven back to the shop because nobody knew who had the good drill, or a rental extension has quietly cost you another week's fee because the tool sat forgotten in a truck bed, this build is for you. This weekend, using nothing but a free Google account, you can put a scannable tag on every tool and piece of equipment you own and know exactly who has what, where it went, and when it's due back.
What you're building
The system has three parts, all free: a Google Sheet that acts as your equipment log, a Google Form that anyone on your team fills out with their phone in about ten seconds, and a printed QR code sticker on each tool that opens a pre-filled version of that form. Scan the tag on the compactor, tap "checked out," pick your name from a dropdown, and the sheet updates itself. No app to install, no login for your crew to remember.
Step 1: Build the log sheet
Open a new Google Sheet and create columns for the things you actually need to know: Tool ID, Tool Name, Status (Checked Out / Returned), Checked Out By, Date/Time, Job Site or Notes. Give every tool a short ID — T-001, T-002 — and list them down the left column. This sheet is your single source of truth; the form just writes into it.
Step 2: Build the check-out form
Create a Google Form linked to that sheet (Google Forms writes responses straight into a new tab of the same spreadsheet). Keep it to four fields: Tool ID (short answer, or a dropdown if your fleet is small enough to list), Your Name (dropdown of crew members), Status (Checked Out / Returned), and Notes (optional, for damage or low fuel). Four fields means it takes longer to find the sticker than to fill out the form.
Step 3: Make one QR code per tool
This is the part that makes it a scan-and-go system instead of "go find the spreadsheet and type in the tool number yourself." Google Forms has a built-in way to pre-fill an answer into the URL: open the form, click the three-dot menu, choose Get pre-filled link, and fill in just the Tool ID field with that tool's ID (leave the rest blank for the crew member to fill in when they scan it). Copy the resulting link — it now has that tool's ID baked in.
Paste that link into any free QR code generator and download the image. Print it, laminate it or cover it in clear packing tape, and stick it directly on the tool. Repeat for each item. It's tedious the first time and takes about ninety seconds per tool after that — a fair trade for never playing twenty-questions about who has the pressure washer again.
Step 4: Make the overdue tools flag themselves
A log nobody looks at is just a longer way to lose a tool. Two low-effort additions fix that. First, in the sheet, add a conditional formatting rule that highlights any row where Status is "Checked Out" and the Date/Time is more than, say, three days old — instant visual flag when you open the sheet.
Second, if you want it to reach someone instead of waiting to be looked at, Apps Script (Extensions → Apps Script, right inside the Sheet) can run on a schedule and email you when an item has been out too long. A short script checks each "Checked Out" row's date, and if it's past your threshold, sends an email — you set this up once with a time-driven trigger (Apps Script's own term for "run this function every morning at 8am") and never touch it again. You don't need to know how to code to adapt a short script like this — describing what you want to an AI assistant and pasting the result into the Apps Script editor gets you most of the way there.
Who this is worth it for
- Trades and field service crews sharing a limited pool of power tools, ladders, or specialty equipment across multiple trucks or job sites.
- Equipment rental or loan operations that need a paper trail of who has what, even informally.
- Any shop where "who had this last" has ever turned into a group text at 7am.
It won't replace dedicated asset-tracking software if you're running hundreds of items across a large fleet — at that scale, a purpose-built tool with barcode scanning hardware earns its keep. But for the ten, thirty, or eighty tools a typical small crew shares, this costs nothing but an afternoon and gives you a real-time answer to "where's the tool" instead of a guess.
Take it further next weekend
Once the log is running, the same pattern — a QR code linking to a pre-filled form — works for vehicle inspection checklists, jobsite safety walkthroughs, or a simple "returned in working condition, yes/no" step that protects you when a tool comes back broken and nobody remembers who had it. Build the habit with tools first; the rest of your operation has plenty of other places a sticker and a form can save you a phone call.