Subterra Solutions — Asset Tracker

ID Prefix: SS-0xxxx Vehicle / Trailer SS-1xxxx Heavy Equipment SS-2xxxx Tool / Equipment SS-3xxxx Electronics SS-4xxxx Furniture SS-5xxxx Real Estate SS-6xxxx Supplies SS-7xxxx Safety Gear

Add New Asset

Asset / Item Name *

Category *

Status

Quantity

Low Stock Alert

Serial / VIN / Model #

Location / Truck

Assigned To

Purchase Date

Notes

All Assets & Inventory

Asset / Item	Category	Qty	Status	Location	Actions

Scan QR Code

Point camera at any Subterra QR tag to pull up the asset and update its status.

Or enter Asset ID manually

Asset Detail

Scan or search to see details here.

Scan & Activity Log

Time	Asset	Action	Note	Status

Print QR Tags

Print on label paper or cardstock and laminate for field use. Each QR links back to the asset record.

Google Sheets Connection

Apps Script Web App URL

Paste the URL from your Apps Script deployment here.

Setup Instructions

Go to sheets.google.com → create a new blank spreadsheet
Name it Subterra Asset Tracker
Click Extensions → Apps Script
Delete all default code, paste the SubterraAssetAPI.gs file contents
Click Save, then Deploy → New deployment
Type: Web app · Execute as: Me · Access: Anyone
Click Deploy, authorize when prompted, copy the URL
Paste the URL above and click Save & Test Connection

Asset & Inventory Tracker