The Scenario
You're a quality engineer at a medical device manufacturer and the ISO 13485 audit is next week.
You've got 150 calipers, micrometers, and torque wrenches listed in a Google Sheet — serial numbers, descriptions, calibration intervals, assigned techs, locations — compiled over months from three different labs. Not a single one of them is in GageList yet because the last person responsible for that system left in January and the migration never finished.
The bad version:
- Open GageList's gage creation form. Copy the serial number from row 2 of the sheet. Paste it into the Control Number field. Copy the description. Paste it. Set the calibration interval manually from the Cal Due Days column. Assign the technician. Save. Move to row 3.
- Repeat 149 more times. Somewhere around row 60, realize you've been pasting the wrong value into the Location field for the last dozen rows. Go back and fix them.
- Finish at 7 PM the day before the audit, realize you haven't double-checked whether GageList's required fields include Manufacturer — which you don't have for 30 of the instruments — and now you have a gap in your traceability record that an auditor will notice immediately.
Your job this week is audit prep, not data entry. Nobody's paying you to move rows between applications — they're paying you to make sure the documentation holds up under scrutiny. Two days of form-filling is not where your energy should go.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data, understands the structure, and through its built-in GageList integration it can create gage records for you in bulk. No import templates, no one-by-one form entry, no CSV gymnastics.
Read every row in the 'Gauge Inventory' sheet and create a GageList gage record for each one using the serial number, description, calibration interval, and location columns
What You Get
- 150 gage records created in GageList, one per sheet row, in a single run
- Control numbers set from column A (Serial Number), calibration intervals from the Cal Due Days column, locations and technician assignments populated from their respective columns
- Any rows that fail validation — missing required fields, duplicate serial numbers — are flagged with an error note written back into column G of the sheet so you know exactly which records need attention
- The GageList gage IDs returned for each successful record are written into column F for traceability
What If the Data Is Not Quite Ready
The calibration interval is in days but GageList expects a different format
Read the 'Gauge Inventory' sheet and before creating each GageList gage record, convert the Cal Due Days value to months by dividing by 30 and rounding to the nearest whole number — use that converted value as the calibration interval
Some rows are missing a technician assignment
Create GageList gage records for every row in the 'Gauge Inventory' sheet where the Owner column is not blank — for rows where Owner is empty, write "UNASSIGNED" into column H so I can follow up separately
The instrument list is split across two tabs by lab location
Combine all rows from the 'Lab A Inventory' and 'Lab B Inventory' sheets, then create a GageList gage record for each instrument — use the Serial Number, Description, Cal Due Days, and Owner columns from both tabs, and tag each record's location based on which sheet it came from
The data is messy and needs cleanup before it goes in
Look at the 'Gauge Inventory' sheet — strip any leading/trailing spaces from the Serial Number and Description columns, standardize the calibration interval to whole numbers, remove any duplicate rows by serial number keeping the most recently added one, then create a GageList gage record for every remaining row and write the returned gage ID back into column F
One prompt that handles the cleanup and the registration is faster than running them as separate steps.
Try It
Get the 7-day free trial of SheetXAI and open your instrument inventory sheet — whatever state it's in — then ask it to register your equipment in GageList before the audit window closes. For the certificate generation workflow, see the bulk certificate spoke. For the full method comparison, see the GageList + Google Sheets hub.