The Scenario
The procurement manager got a request from accounts-payable this afternoon: they need the full vendor list from Loyverse — all 55 suppliers, with name, contact person, email, and phone — to set up payment terms in the AP system before month-end.
The deadline is tomorrow morning. The supplier data is in Loyverse. Accounts-payable works in spreadsheets.
The bad version:
- Open Loyverse's supplier list. There's no bulk export option in the supplier section.
- Copy supplier names and contact details one at a time into a spreadsheet — or screenshot the list and type them in.
- 55 suppliers, four fields each: 220 data points to transcribe manually.
- Email accounts-payable the spreadsheet. Get a reply asking for the address field too. Go back and do it again.
This is the kind of task that exists to prove that manual data extraction is the wrong tool for every job that comes after the first one.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It fetches all supplier records from Loyverse and writes them to the sheet with whatever fields you need — one call, done.
Open the SheetXAI sidebar and paste this prompt:
List all suppliers in Loyverse and write to sheet 'Supplier Directory' with columns: supplier_id, name, contact_person, email, phone, address, created_date
What You Get
- All 55 supplier records written to 'Supplier Directory' with the seven columns specified.
- created_date included for sorting by when each vendor was added.
- Data is ready to share with accounts-payable, filter by country, or import into another system immediately.
What If the Data Is Not Quite Ready
Accounts-payable needs the data sorted by supplier name
List all suppliers in Loyverse, sort by name ascending, write to 'Supplier Directory' with supplier_id, name, contact_person, email, phone, address — skip the created_date column
You need to add a currency or country column that isn't in Loyverse's data
List all Loyverse suppliers and write to 'Supplier Directory' with name, contact_person, email, phone, address — leave a blank column D labeled 'Currency' for manual entry after export
You want to compare against a separate master vendor list for gaps
List all Loyverse suppliers and write to 'Loyverse Vendors' sheet with name and email — then check against 'AP Master' sheet column A (vendor names): flag any Loyverse suppliers whose name doesn't appear in the AP master list in column C
Full accounts-payable handoff in one shot
List all Loyverse suppliers — sort by name ascending — write to 'Vendor Master' with supplier_name, contact, email, phone, and country — where country is blank, write 'Unknown' — add a header row and a count row at the bottom
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet the morning the AP request lands, then ask SheetXAI to pull all Loyverse supplier records in whatever format accounts-payable needs. See also bulk import suppliers and the Loyverse integration overview.