The Scenario
A fulfillment manager has been handed 30 one-off delivery orders that need to go out this week. Some are within the company's owned fleet zone. Others are candidates for third-party on-demand couriers.
Before routing anything, she needs to know which on-demand providers can actually cover each pickup-to-drop pair, what the price looks like, and whether the timing works. That data lives inside Shipday's on-demand API. Her order list lives in an Excel workbook.
The bad version:
- Open Shipday, go to the on-demand quote screen, type in the pickup address from row 1, type in the delivery address, submit, note the cheapest provider and price, go back to Excel, type those into columns D and E.
- Repeat for row 2. And row 3. And all 30.
- Halfway through, a provider that was available for row 8 is now showing a different price for row 17 because a few minutes passed. Your quotes are already slightly inconsistent.
Thirty orders, two fields each, one at a time. That is a Monday morning gone.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your order rows and runs on-demand availability checks against Shipday for each pickup-drop pair, then writes the results back into the workbook in one pass.
Paste this into the sidebar:
Read my Urgent Orders Google Sheet and fetch Shipday on-demand delivery estimates for each row, then write estimated pickup time, delivery time, and cost into columns F through H
What You Get
- One Shipday on-demand availability check per row, processed as a batch.
- Estimated pickup time in column F, estimated delivery time in column G, cost in column H.
- Rows where no provider is available get "no coverage" in column F so you know which orders need alternative routing before you finalize anything.
What If the Data Is Not Quite Ready
Pickup addresses are stored as partial strings
Column B has "123 Main St" but no city or zip. Shipday needs full addresses to return accurate quotes.
For each row in my Urgent Orders workbook, combine column B (street) with column E (city) and column F (zip) into a full pickup address, then check Shipday on-demand availability to the delivery address in column C — write estimated pickup time, delivery time, and cost into columns F through H
You only want quotes for rows above a certain order value
Orders under $50 in column D are handled by the internal fleet. Only rows at $50 or above need on-demand quotes.
For each row in my Urgent Orders workbook where column D is greater than or equal to 50, check Shipday on-demand availability from column B to column C — write estimated pickup time, delivery time, and cost into columns F through H — leave those columns blank for rows below the threshold
You want all available providers listed, not just estimates
The operations lead wants to see the full provider list with prices to make routing decisions herself.
For each row in my Urgent Orders workbook, fetch all Shipday on-demand provider options for the pickup in column B to the delivery in column C — write each provider name and price as comma-separated values into column F so she can compare
Pull quotes, flag no-coverage rows, and write a summary count in one ask
By end of day, the operations lead wants to know how many of the 30 orders have on-demand coverage and what the total estimated cost would be if they used the cheapest option for each.
For each row in my Urgent Orders workbook, check Shipday on-demand availability from column B to column C — write estimated pickup time in F, delivery time in G, and cost in H — highlight in red any row where no provider is available — then write the count of covered orders into cell J1 and the sum of estimated costs into cell J2
One prompt turns a 30-row quoting task into a finished decision-ready workbook.
Try It
Get the 7-day free trial of SheetXAI and open your order list Excel workbook with pickup and delivery addresses, then ask it to run on-demand availability checks against Shipday for every row. Also worth reading: bulk-creating delivery orders from an Excel workbook, and the hub overview on connecting Shipday to Excel.