The Scenario
You are on the accounts team at an online retailer. Month-end. 120 orders from the previous month need invoices. The order IDs are in column A of a Google Sheet. Finance wants the invoice IDs written back into column B so they can be linked to the payment records.
BaseLinker can generate invoices through its API. But doing it manually means logging in, finding each order, clicking "issue invoice," and copying the invoice ID back to the sheet. For 120 orders, that is the better part of a morning.
The bad version:
- Open BaseLinker, search for the first order ID
- Navigate to the invoice section
- Issue the invoice with the correct numbering series
- Copy the invoice ID
- Switch back to the sheet, paste it into column B
- Repeat
- Finish 60 orders before lunch. Lose track of where you were. Issue invoice 61 twice. Finance has a duplicate on the books and asks you to explain yourself.
The fast version is one prompt and the invoices are done before the second cup of coffee.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the order ID column, issues an invoice for each order through BaseLinker, and writes the invoice ID back to the sheet, all in one operation.
Open the SheetXAI sidebar and type:
Issue a BaseLinker invoice for each order ID in column A of this sheet using numbering series ID 3344. Generate all 120 invoices and write the resulting invoice ID into column B for each row. If an invoice already exists for an order, write the existing invoice ID instead of issuing a duplicate.
SheetXAI reads column A, calls BaseLinker's invoice creation API for each order, and writes the returned invoice IDs to column B. Finance has the linked IDs without anyone touching BaseLinker's UI.
What You Get
120 issued invoices, with IDs written back to the sheet:
- Invoice IDs in column B — one per order, ready to link to payment records
- Duplicate protection — existing invoices are flagged rather than reissued
- Error handling — orders that fail (not found, wrong series ID) get an error note in column B
- Zero navigation in BaseLinker — every invoice went through the API
Column B is the audit handoff. Finance takes the sheet, matches invoice IDs to payments, and does not need to ask you for anything else.
What If the Data Is Not Quite Ready
Invoice batches come with edge cases. SheetXAI handles them in the same prompt.
When different orders use different numbering series
Orders from marketplace A use series 3344. Orders from marketplace B use series 5566. Column C indicates the marketplace.
Issue BaseLinker invoices for each order ID in column A. Use numbering series 3344 if column C says "MarketA" and series 5566 if column C says "MarketB." Write the resulting invoice ID into column B for each row.
When some orders are outside the invoice period and should be skipped
You only want to invoice orders placed in the previous calendar month. Column D has the order date.
Filter to rows where the order date in column D is within the previous calendar month. For those rows, issue a BaseLinker invoice using numbering series 3344 and write the invoice ID into column B. For rows outside that date range, write "out of period" into column B and skip.
When you need to verify an order is in the correct status before issuing an invoice
You do not want to issue an invoice for an order that has been cancelled.
For each order ID in column A, check the current BaseLinker order status before issuing an invoice. If the status is "Cancelled" or "Returned," write "skipped — cancelled" in column B and do not issue the invoice. For all other statuses, issue the invoice using series 3344 and write the invoice ID into column B.
When you need to pull the orders, filter them, issue invoices, and create a finance summary in one pass
Finance wants a summary sheet alongside the invoice IDs.
Fetch all BaseLinker orders placed between the 1st and last day of last month. Write order ID, order date, order value, and customer name into this sheet starting at row 2. Then issue an invoice using series 3344 for each order and write the invoice ID into column E. After all invoices are issued, calculate the total invoice value in column D and write it into cell F1 as a summary.
The pattern: the pull, the filter, the invoice creation, and the summary happen in one prompt. No intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open your order ID sheet, then ask it to issue the invoices and write the IDs back. The BaseLinker integration is included in every SheetXAI plan. For related workflows, see how to pull order event logs for compliance reporting or the BaseLinker in Google Sheets overview.