The Scenario
You are a franchise operator with 15 Square locations across the country. You are setting up a new multi-location sales reporting template in Google Sheets. The template has a tab per location. The template formulas reference location IDs.
You do not have a clean list of your Square location IDs, names, and addresses. You have been managing locations through the Square dashboard for years, and every time a new one opened, someone added it and moved on. Right now, you are not sure of the exact IDs for three of the locations, and you think one of the addresses in your internal docs might be out of date.
The slow version:
- Log into the Square dashboard, navigate to Account, then Locations
- Read the location ID, name, and address for location 1
- Switch to your sheet, type it in
- Go back, read location 2
- Fifteen locations. Fifteen back-and-forth trips.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that queries the Square locations endpoint and writes every location's details directly to the sheet, so you never have to read them off a screen.
Open the SheetXAI sidebar and type:
List all Square locations in my account and write each location's ID, name, address, city, and status into this sheet, starting at row 2. Sort alphabetically by location name.
SheetXAI calls Square's locations endpoint and writes every location — active, inactive, or otherwise — into the sheet sorted by name. You get the full picture of what is in your account.
What You Get
A complete location directory with every Square location in your account:
- Location ID — the Square-assigned ID used in API calls, formulas, and downstream reports
- Location name — as configured in Square
- Address — the street address on file in Square
- City — for geographic grouping and filtering
- Status — ACTIVE or INACTIVE so you can filter out closed locations
You have a source-of-truth directory that you can paste location IDs from directly into your reporting template, without guessing or searching.
If an address looks wrong compared to your internal records, you now have the discrepancy identified and can update it in Square through the dashboard.
What If the Data Is Not Quite Ready
Location data has common complications when you are building a reporting template. SheetXAI handles them in the same prompt.
When you only want active locations
Your account has a few permanently closed locations that are still in Square as INACTIVE. You do not want them in your reporting template.
List all Square locations where status is ACTIVE. Write location ID, name, address, city, and timezone into this sheet. Sort alphabetically by name.
When you also need the timezone per location for scheduling
Your reporting template calculates daily revenue by closing time, which varies by timezone.
List all active Square locations and write location ID, name, city, state, timezone, and phone number into this sheet. Sort by state and then by city.
When you need to build a tab-per-location template structure
You want the location directory plus a note about which tab in your workbook corresponds to each location.
List all active Square locations and write location ID, name, and address into columns A, B, and C. Then in column D, generate a suggested tab name for each location using the format "Sales - [City]." I will use this to create the tabs manually.
When you need the full setup: pull locations, seed the directory, and generate the header row for each location tab in one shot
You are building the multi-location reporting template from scratch and want SheetXAI to do the setup work.
List all active Square locations and write location ID, name, city, state, and timezone into the Location Directory tab. Then, for each location, add a new row in the Tab Setup tab with: suggested tab name (format: "Sales - [City]"), location ID, and the standard column headers I should use (Date, Order ID, Total Amount, Fulfillment Type). I will use this as the setup guide to build out each tab.
The pattern: the location directory is the seed for every multi-location report you will ever build. Pull it once and update it whenever a location opens or closes.
Try It
Get the 7-day free trial of SheetXAI and pull your Square location directory into a sheet before building your next multi-location report. The Square integration is included in every SheetXAI plan. For related workflows, see how to export Square orders across locations or the Square in Google Sheets overview.