The Scenario
The food truck wrapped March with 430 transactions. The operator wants to know which items sold most, what peak hours looked like, and whether the new fish tacos pulled their weight in week 3. All of that is sitting in Loyverse's receipt log.
The answer to every question is in the data. The data is not in a spreadsheet yet.
The bad version:
- Open Loyverse's sales report, filter to March, export a CSV.
- Open the CSV in Google Sheets. The column headers are Loyverse's internal labels, not what was expected. Spend 20 minutes reformatting.
- The export gives one row per receipt, not one row per line item. The item-level breakdown you need requires splitting the "items" column, which is a JSON blob in the CSV export.
The analysis you sat down to do is now a data engineering problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It calls the Loyverse API directly, pulls the receipts for the date range you specify, and writes them to your sheet in whatever structure you ask for — one row per line item, labeled columns, no JSON blobs.
Open the SheetXAI sidebar and paste this prompt:
Fetch all Loyverse receipts from 2024-03-01 to 2024-03-31 and write them to the 'March Sales' sheet with columns: receipt_number, date, employee, store, items_sold, payment_method, discount, total
What You Get
- 430 receipt rows written to the 'March Sales' sheet with the column structure you specified.
- Each row represents one receipt with a summary of items sold in the items_sold column.
- Payment method and discount amount included for each transaction.
- Data is ready to pivot or filter immediately — no cleanup required.
What If the Data Is Not Quite Ready
You need one row per line item, not one row per receipt
Fetch all Loyverse receipts from 2024-03-01 to 2024-03-31 and write to 'March Sales' sheet with one row per line item: receipt_number, date, item_name, variant, quantity, unit_price, line_total, payment_type
You only want receipts from a specific store
Fetch all Loyverse receipts for store 'Food Truck Downtown' from March 2024 and write to 'March Sales' with columns: receipt_number, date, time, items_sold, total, payment_method
You want the data filtered to receipts above a certain value
Fetch all Loyverse receipts from March 2024 where the total is greater than 50, write to 'High-Value Receipts' sheet with receipt_number, date, store, employee, items_sold, and total
Full receipt analysis pull in one shot
Fetch all Loyverse receipts from March 2024 — write to 'March Sales' with one row per line item: receipt_number, date, hour_of_day, day_of_week, store, employee, item_name, category, variant, quantity, unit_price, line_total, discount_applied, payment_type — include a summary row at the bottom with total revenue, transaction count, and average ticket
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask SheetXAI to pull last month's Loyverse receipts into it — you'll have the data for your analysis in under a minute. See also cross-store sales summary and the Loyverse integration overview.