The Scenario
You run e-commerce operations across three marketplace storefronts. Every morning at 7 AM, before the warehouse opens, your team needs a pick list: every unprocessed order from the overnight shift, with product SKUs, quantities, and shipping addresses, in one place.
BaseLinker has all of it. But getting it into a Google Sheet requires logging in, configuring an order filter, exporting a CSV, opening the file, checking the columns are right, and handing it to the warehouse team. On a slow morning that takes twenty-five minutes. On a morning with 200 overnight orders, it takes longer.
The bad version:
- Log into BaseLinker, navigate to orders, configure the filter for unconfirmed orders
- Export the CSV, wait for it to download
- Open the file in Sheets, fix the column headers to match what the warehouse expects
- Remove columns the warehouse does not need
- Share the link to the warehouse team's pinned sheet
- The warehouse starts fifteen minutes late and the first courier pickup is tight.
The fast version is one prompt while the coffee is still brewing.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads BaseLinker directly, so you do not have to touch the BaseLinker UI to get your morning pick list.
Open the SheetXAI sidebar and type:
Fetch all unconfirmed BaseLinker orders from the last 7 days and write order ID, customer name, email, product SKUs, quantities, and shipping address into this sheet starting at row 2. One row per order, sorted by order date ascending.
SheetXAI calls the BaseLinker orders API, paginates through all results, and fills the sheet. The warehouse team opens the same pinned sheet they always open. The data is already there.
What You Get
A clean pick list with every unconfirmed order, ready for the warehouse:
- Order ID — linked to the BaseLinker order record
- Customer name and email — for any shipping queries
- Product SKUs and quantities — what to pull from the shelves
- Shipping address — where it is going
- Order date — sorted ascending so the oldest orders are fulfilled first
The sheet is your authoritative morning handoff document. The warehouse team does not need BaseLinker access. They work from the sheet, mark orders as picked, and the coordinator updates BaseLinker at the end of the shift.
Want to narrow the scope? Tell SheetXAI to pull only orders for a specific marketplace, or only orders over a certain value, and it applies the filter inline.
What If the Data Is Not Quite Ready
Real order data is rarely as clean as a single-filter export. SheetXAI handles the edge cases in the same prompt.
When orders come from multiple status IDs
Your unconfirmed orders span three different BaseLinker status IDs depending on the marketplace. You want all of them in one list.
Fetch BaseLinker orders with status IDs 1001, 1002, and 1003 from the last 7 days. Combine them into one list and write order ID, marketplace name, customer name, SKUs, quantities, and shipping address into this sheet starting at row 2.
When the warehouse wants products as separate rows, not comma-separated
The warehouse uses a scanner system that needs one SKU per row, not a comma-separated list in one cell.
Fetch all unconfirmed BaseLinker orders from the last 24 hours. For each order, create one row per product line: columns A = order ID, B = customer name, C = SKU, D = quantity, E = shipping address. So a three-product order creates three rows.
When you want to exclude orders already assigned to a courier
You have some orders already in the courier system. You only want the ones that have not been assigned yet.
Fetch all unconfirmed BaseLinker orders from the last 7 days where no package has been created yet. Write order ID, customer name, SKUs, quantities, and shipping address into this sheet starting at row 2.
When you need the full picture: pull orders, flag problems, and create the pick list in one go
Some orders are missing a shipping address. Some have a product quantity of zero. You want to flag those instead of sending the warehouse a broken list.
Fetch all unconfirmed BaseLinker orders from the last 24 hours. Write order ID, customer name, SKUs, quantities, and shipping address into this sheet starting at row 2. In column F, write "OK" if the row is complete and ready to pick, or a short note describing the problem (missing address, zero quantity, etc.) if something is wrong. Sort so the OK rows come first.
The pattern: instead of exporting and then manually reviewing for problems, you ask SheetXAI to pull the data and flag issues in the same prompt. The warehouse gets a clean list with problems already marked.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to fetch your open BaseLinker orders and write them in. The BaseLinker integration is included in every SheetXAI plan. For a related workflow, see how to batch-update order statuses from a sheet or the BaseLinker in Google Sheets overview.