The Scenario
The franchise consultant is building a store-locator page for the client's website. They need a data file: all 12 Loyverse store records — name, address, phone, timezone — in a Google Sheet, formatted for import into the website CMS.
The client has Loyverse access. The consultant doesn't. The client was asked to "export the store list." They found the Loyverse UI has no bulk store export. They sent a message asking how to do it.
The bad version:
- The client opens each store record in Loyverse one at a time: Store Settings for each location.
- They copy the name, address, phone, and timezone into a spreadsheet by hand.
- 12 stores, four fields each: 48 manual data entries.
- They forward the spreadsheet. The consultant notices the timezone column is in Loyverse's internal format ("America/New_York"), not the display format the CMS expects ("EST / UTC-5"). Back and forth.
A store locator data file shouldn't take 45 minutes to produce.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It fetches all store records from Loyverse and writes them to the sheet with the fields the website CMS needs — in one call.
Open the SheetXAI sidebar and paste this prompt:
List all stores in Loyverse and write to sheet 'Locations' with columns: store_id, store_name, address, city, country, phone, timezone
What You Get
- All 12 store records written to 'Locations' with the seven columns specified.
- Address, city, and country written as separate columns if available in Loyverse — easier for CMS import than a single concatenated address field.
- timezone in Loyverse's standard format (e.g., America/Chicago) — you can reformat it with a follow-up prompt if needed.
What If the Data Is Not Quite Ready
The CMS needs address as a single field, not split columns
List all Loyverse stores and write to 'Locations' with store_name, phone, timezone, and a single 'full_address' field that concatenates street address, city, and country separated by commas
You need the timezone converted to a UTC offset label
List all Loyverse stores and write to 'Locations' with store_name, address, city, country, phone — convert each timezone value to a UTC offset string (e.g. America/Chicago becomes UTC-6) and write in column G
You want to add a 'region' grouping column based on country
List all Loyverse stores — write to 'Store Directory' with store_name, address, city, country, phone, timezone — add a column 'region' based on country: US stores = 'North America', UK stores = 'Europe', etc.
Full store-locator data file in one shot
List all Loyverse stores — write to 'Locations' with store_id, store_name, street_address, city, country, phone, timezone, and creation_date — sort by country then city — add a header row and a count row at the bottom showing total store count
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask SheetXAI to pull the full Loyverse store directory in the format your CMS import needs — you'll have the data file ready before the consultant follows up. See also export payment type configurations and the Loyverse integration overview.