The Scenario
Three new technicians are starting next Monday. Before you hand them access to MaintainX, someone from the onboarding team flagged that the location hierarchy might not be set up correctly — buildings are there, but floors and rooms might be mapped to the wrong parents, especially in Building 4 where two teams were merged last year. You need to verify the whole structure across all six buildings before anyone else logs in and starts creating work orders in the wrong place.
The bad version:
- Open MaintainX locations, expand the hierarchy tree one building at a time, and manually compare it to the floor plan you have in a separate document.
- Note discrepancies on a sticky note. Realize by Building 3 that you are not tracking which locations are missing parents versus which have incorrect parents.
- Try to export the location list, find the CSV only gives you a flat list with no parent column, and spend 20 minutes cross-referencing it against the hierarchy view.
The hierarchy audit should take an hour, not a day. And you cannot onboard three technicians into a broken location structure.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the sheet, connects to MaintainX through its built-in integration, and can pull your full location list — with parent location names — in one shot.
List all MaintainX locations and write each location's name, parent location, address, and ID into columns A through D of this sheet
What You Get
- Column A: location name
- Column B: parent location name (so you can see the hierarchy flat)
- Column C: address if one is stored
- Column D: MaintainX location ID
- Every location in your account, one row each — ready to sort, filter, and compare against your floor plan
What If the Data Is Not Quite Ready
You want to flag locations with no parent set
List all MaintainX locations and write name, parent location, address, and ID into columns A through D — then write MISSING PARENT in column E for any location where the parent field is blank
You only want to audit one building's sub-hierarchy
List all MaintainX locations that are children or descendants of 'Building 4' and write each location's name, parent location name, and ID into columns A through C
You want to sort the list to group locations by their top-level parent building
Export all MaintainX locations into columns A through D with name, parent location, address, and ID — then sort the rows alphabetically by parent location so all rooms in the same building appear together
Full onboarding readiness check in one shot: pull, flag gaps, count per building
List all MaintainX locations and write name, parent location name, address, and ID into columns A through D — flag MISSING PARENT in column E where parent is blank, then add a count in column F showing how many locations share the same parent so I can spot buildings that are over- or under-populated
One prompt gives you a reviewable location map sorted for the audit.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet. Ask it to pull your MaintainX location hierarchy and flag any locations with missing parent assignments. Then check the spoke on exporting your asset registry if you need to verify that assets are assigned to the correct locations as well.