IT asset tracking in Google Sheets: A no-code alternative to expensive asset software

If you’re running IT asset tracking for a growing company, you know exactly how the hardware lifecycle breaks down. You buy 20 new laptops, assign them out via Slack, and log them in a static spreadsheet. Six months later, an employee leaves, the laptop is returned to a closet, and the spreadsheet is never updated.

Tracking company laptops, monitors, and mobile devices using manual spreadsheets inevitably leads to lost hardware and broken audit trails — IT asset tracking done well needs structure, mobile access, and automation, and a static sheet provides none of them.

To fix this, most IT teams assume they need to buy expensive, heavy enterprise IT asset management (ITAM) software like Jamf or Snipe-IT. But if your primary goal is simply to know who has what and how many spare MacBooks are left, those platforms are bloated and overpriced.

The solution: Sheetgo as your IT workflow engine

By combining Google Sheets with Sheetgo’s Inventaire avec lecteur de code-barres template, you can track hardware, auto-generate QR codes, and scan laptops in and out using your smartphone camera. Here’s how to set it up.

Instead of forcing your IT team to learn a new, rigid software platform, Sheetgo acts as the middleware that connects the tools you already use.

For IT asset tracking, Sheetgo handles three jobs:

• Data routing: mobile barcode scans from Google Forms get pushed into the correct tabs of your master Google Sheet.
• Logic and processing: live inventory balances are calculated in the cloud, not by fragile spreadsheet formulas that break when a row gets added.
• Automated triggers: stock levels are monitored continuously, and warning emails go out automatically when hardware runs low.

The result is an automated asset tracking system that lives entirely inside Google Workspace. Here’s exactly how to build it.

S'inscrire à Sheetgo

If you don’t have one already, you’ll need a Sheetgo account to run this workflow.

1. Click here to sign up for Sheetgo.
2. Once you’re signed in, install the Inventaire avec lecteur de code-barres template — covered in Step 1 below.

Remarque : if your IT operation has highly specific tracking needs and this template isn’t the perfect fit, the Sheetgo team can help you design a custom workflow. Book a free expert demo session.

Étape 1 : Installer le modèle

Log into your Sheetgo Workflows, head to the Templates gallery, and install the Inventaire avec lecteur de code-barres template — or install it directly here.

Cliquez sur Utiliser le modèle, alors Installer le modèle.

Step 2: Understand the node map

Once the template is installed, the IT asset tracking workflow architecture is ready. Here’s how Sheetgo moves your data:

• Inputs: three Google Forms (Register item, Check-in item, Check-out item) act as data entry points.
• Processor: Sheetgo routes that data into a central Gestion des stocks feuille de calcul.
• Outputs: the central sheet calculates the balance and pushes data out to a Dashboard, a Print labels sheet, and a Low stock alert email node.

Step 3: Customizing the forms for IT hardware

Now to transform this template from a generic inventory template into a professional IT tracker. Open the Google Sheets connected to your workflow and add these specific columns to build your IT database.

1. Update the Register item (master list) sheet. This is where you define your hardware catalog.

• Keep: Asset Tag (SKU), Item Name
• Add custom columns: Category (e.g. Laptop, Mobile, Monitor), Low Stock Threshold, Cost Price

2. Update the Check-out form. When a device leaves the IT closet, you need to track exactly who has it.

• Keep: Asset Tag
• Add custom columns: Assignee (e.g. Alice Johnson), Department (e.g. Engineering)

3. Update the Check-in form. When hardware is returned, you need to log its physical state.

• Keep: Asset Tag
• Add custom columns: Condition (dropdown: Excellent, Good, Damaged, EOL), Notes

One important step: after adding these columns, head back to the Sheetgo interface and click Sync on each form node so the workflow recognizes the new data structure.

Step 4: Configuring dropdowns and alert routing

Before scanning hardware out to employees, dropdowns and email alerts need to be configured. Sheetgo handles both in a dedicated configuration tab rather than buried inside spreadsheet validation rules.

Open your central Gestion des stocks spreadsheet and head to the Customisation tabulation.

1. Update the Unit dropdown values. By default the column contains retail categories. Replace them with IT-specific categories (e.g. Laptop, Mobile, Monitor, Peripheral). The dropdowns in your connected Google Forms update automatically.
2. Configure the Low stock email. Sous Email for sending low stock report, enter the email of your IT purchasing manager. BCC the wider IT operations team if you want them on the alert thread.

Step 5: Registering assets and auto-generating QR codes

With the structure ready, you can build your hardware database. Open the Register item form and submit your devices. Use explicit, serialized Asset Tags rather than generic names.

Two test items to start:

• Asset Tag: 1001 — Item Name: MacBook Pro 14″ M3 — Category: Laptop
• Asset Tag: 1002 — Item Name: Dell UltraSharp 27″ — Category: Monitor

QR code generation and printing

Not all company hardware comes with a scannable manufacturer barcode. Once you’ve registered your devices, you’ll need to generate physical tags. The Sheetgo template handles this in bulk.

1. Run the transfer. In your Sheetgo workflow, click the connection line between your main spreadsheet and the Imprimer les étiquettes file, then hit Exécuter. This pushes your newly registered assets into the 🖨️ Print options tab of the Print Labels sheet.

2. Allow access to the generator. The first time you open the Print Labels sheet, a warning will appear telling you formulas are trying to send and receive data from external parties. Click the three vertical dots (⋮) next to the sheet name, choose Open in new tab, then click Autoriser l'accès in the new tab to enable barcode generation.
3. Select your assets. Open the 🖨️ Print options tab. Under Select your registered items for printing labels, pick the specific hardware you just registered. In the Enter the quantity of labels needed column, type how many labels you want for each item. The SKU column fills in automatically.

4. View the generated labels. Switch over to the View Print Labels tab. The workflow automatically generates a scannable QR code for every selected Asset Tag.

Step 6: The mobile check-in / check-out workflow

With your hardware physically tagged, your IT team can handle onboarding and offboarding entirely from a phone. This eliminates the risk of typing the wrong 12-digit serial number and messing up your database.

Checking out equipment (onboarding)

When a new hire needs a desk setup, the IT manager opens the Check-out item form on their smartphone.

1. Tap the barcode scanner icon inside the form.
2. Use the smartphone camera to scan the printed QR sticker on the device (e.g. the Dell UltraSharp monitor, SKU 1002).
3. The form instantly populates the exact SKU, verifies the Status as Item registered, and pulls the Item name.
4. Type the employee’s name under Assignee, enter the quantity, and submit.

Checking in equipment (offboarding or maintenance)

When an employee leaves or a device breaks, the process runs in reverse.

1. Ouvrir le Check-in item form on your phone.
2. Scan the QR code for the returned device (e.g. the MacBook Pro, SKU 1001).
3. Update the Condition column via the dropdown so the operations team knows if the device needs maintenance before being redeployed.

Step 7: Automating the dashboard and email alerts

For this to be a true perpetual inventory system, the math has to run on its own. You don’t want your IT team manually refreshing anything. Head back to the Sheetgo web app and open the IT asset workflow.

1. Set the trigger. Click the Triggers (clock) icon on the workflow canvas in the Sheetgo Workflows app. Set the automation to run on a schedule — every hour or daily at 8 AM, depending on how often you assign hardware.
2. Monitor the dashboard. Once the IT asset tracking workflow runs, Sheetgo pulls data from the Check-in and Check-out forms, recalculates the exact balance, and updates the central Dashboard. If you registered 10 laptops and assigned 1 to Alice, the dashboard shows exactly 9 available.

Beyond basic hardware tracking

The biggest advantage of running your IT asset management in Google Workspace isn’t the money you save on enterprise software licenses. It’s that the architecture is yours to extend.

Once your core laptops and monitors are tagged and tracked, you can scale this Sheetgo workflow to handle more complex IT operations:

• Warranty tracking. Add a Warranty Expiration column to your master list and configure a Sheetgo email node to alert you 30 days before a device’s AppleCare or Dell warranty expires.
• Software licenses. Duplicate the workflow to track expensive software seats (Adobe Creative Cloud, specialized CAD tools, design tooling) so you can reclaim inactive seats from offboarded employees.
• Depreciation logs. Add a formula column that calculates hardware depreciation over three years for the finance team.

Because the underlying database is yours, you’re never waiting on a vendor’s roadmap to ship the features you actually need.

If you’re also tracking physical stock or kitchen ingredients, the same form-to-spreadsheet pattern applies to other verticals — see our warehouse inventory guide and our restaurant inventory guide. For the broader picture — how a workflow layer like this fits alongside ERPs, multi-SaaS tools, or custom builds — see our comparaison de l'automatisation des flux de travail d'entreprise. Our guide to free Google Sheets inventory templates covers the wider template landscape.

Build your IT asset tracking system today

You don’t need a bloated platform to keep strict control over your hardware. Treat Google Sheets as your database and Sheetgo as your processing engine, and you get a mobile-friendly audit trail that actually scales with your headcount.

Stuck on a specific step or unable to get the workflow to behave the way you need? The Sheetgo team can walk through it with you and help shape a workflow tailored to your IT operation. Book a free expert demo session.

Ready to automate your IT closet? Install the Inventory with barcode scanner template and build your IT asset tracking system today.