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 sheet.
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 Google Sheet. 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 sheet in one pass.
Paste this into the sidebar:
For each row in my On-Demand Quote sheet, check Shipday on-demand availability from the pickup address in column B to the delivery address in column C — write the cheapest provider name and price into columns D and E
What You Get
- One Shipday on-demand availability check per row, processed as a batch.
- The cheapest available provider name written into column D.
- The estimated cost written into column E.
- Rows where no provider is available get "no coverage" in column D 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 On-Demand Quote sheet, combine column B (street) with column F (city) and column G (zip) into a full pickup address, then check Shipday on-demand availability to the delivery address in column C — write the cheapest provider and estimated price into columns D and E
You only want quotes for rows above a certain order value
Orders under $50 in column H are handled by the internal fleet. Only rows at $50 or above need on-demand quotes.
For each row in my On-Demand Quote sheet where column H is greater than or equal to 50, check Shipday on-demand availability from column B to column C — write the cheapest provider and price into columns D and E — leave D and E blank for rows below the threshold
You want all available providers listed, not just the cheapest
The operations lead wants to see the full provider list with prices to make routing decisions herself.
For each row in my On-Demand Quote sheet, 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 D so she can compare
Pull quotes, flag no-coverage rows, sort by price, 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 On-Demand Quote sheet, check Shipday on-demand availability from column B to column C — write the cheapest provider into column D and estimated cost into column E — highlight in red any row where no provider is available — then write the count of covered orders into cell G1 and the sum of cheapest prices into cell G2
One prompt turns a 30-row quoting task into a finished decision-ready worksheet.
Try It
Get the 7-day free trial of SheetXAI and open your order list 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 a Google Sheet, and the hub overview on connecting Shipday to Google Sheets.