The Scenario
Payroll runs Friday. It's Wednesday afternoon, and the retail store manager needs shift records for the past 30 days for every employee across two locations. Loyverse has all of it — clock-in, clock-out, store, employee name.
HR needs a spreadsheet, not a Loyverse report. The accountant processes payroll from a spreadsheet. Always has.
The bad version:
- Open Loyverse's shift report. Filter to the date range. Export.
- The CSV opens in Google Sheets with more columns than needed and not quite the right column names.
- The duration column is in seconds. HR needs hours worked, formatted as a decimal. Convert manually or write a formula and pray it handles overnight shifts correctly.
- Do this separately for both locations and then combine the sheets.
This is Wednesday afternoon. Payroll doesn't move until the spreadsheet is right.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It fetches shift records directly from Loyverse for any date range and writes them to your sheet in the format payroll actually needs.
Open the SheetXAI sidebar and paste this prompt:
List all Loyverse shifts from the past 30 days and write to sheet 'Shifts' with columns: employee_name, store, shift_start, shift_end, duration_hours, closing_notes
What You Get
- Every shift record from the past 30 days written to the 'Shifts' sheet, one row per shift.
- Duration already calculated as decimal hours — no seconds-to-hours conversion needed.
- Shift start and end times formatted as readable timestamps, not Unix epochs.
- Closing notes included where they exist.
What If the Data Is Not Quite Ready
You need the data summarized by employee before sending to payroll
Fetch all Loyverse shifts from the past 30 days and write to 'Payroll Summary' with one row per employee: employee_name, store, total_shifts, total_hours_worked — sorted by total_hours_worked descending
You need to split the output by store
Fetch all Loyverse shifts from the past 30 days — write to two separate sheets: 'Store A Shifts' for location 'Main Street' and 'Store B Shifts' for location 'Westside' — each with employee_name, shift_start, shift_end, and hours_worked
You want to flag any shifts that look anomalous
Fetch all Loyverse shifts from the past 30 days, write to 'Shifts' sheet, and flag any rows where duration_hours is greater than 12 or less than 0.25 in a column F 'Review Flag' with the note 'Unusual duration'
Full payroll-ready export in one shot
Fetch all Loyverse shifts for March 2024 — write to 'Payroll' sheet with employee_id, employee_name, clock_in, clock_out, hours_worked, store, and closing_notes — calculate hours_worked as a decimal, sort by employee_name then clock_in, add a totals row at the bottom with total hours across all employees
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet on Wednesday afternoon, then ask SheetXAI to pull all shift records from Loyverse into the format your payroll process needs. See also export customer data and the Loyverse integration overview.