The Scenario
You work in customer support. Thirty customers have opened tickets claiming their mailed item never arrived. Your manager wants a response within 24 hours that either confirms a send record exists or escalates to the fulfillment team. All 30 disputed addresses are in column A of an Excel workbook. The answers are somewhere in Thanks.io order history, but you have to look them up one at a time.
You have 23 other tickets open and the queue is not getting shorter.
The bad version:
- You open Thanks.io and navigate to order search.
- You type the first address from the workbook and find the matching order, copy the order ID, switch back to the workbook, paste it in column B.
- You do this 30 times.
The cognitive cost of switching between windows 60 times while the queue piles up is a specific kind of exhausting that has nothing to do with actual support work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads every address in column A and queries Thanks.io's order search for each one, writing the results back without you leaving the workbook.
Open the SheetXAI sidebar and paste this prompt:
For each street address in column A of the Disputed Deliveries worksheet, search Thanks.io orders by address and write the matching order ID and send date into columns B and C.
SheetXAI runs the lookup for all 30 rows and fills in whatever Thanks.io returns.
What You Get
- Column B shows the Thanks.io order ID for each address, or "Not Found" if no matching order exists.
- Column C shows the send date for confirmed orders.
- Rows with no match are clearly marked so you know which tickets need escalation.
- All 30 lookups run in a single prompt.
What If the Data Is Not Quite Ready
I want a Found or Not Found flag plus the order ID
Search Thanks.io orders for each address in column A of the Disputed Deliveries worksheet and write Found or Not Found into column B, plus the order ID into column C if found.
The addresses have inconsistent formatting
Normalize the address formatting in column A (expand common abbreviations like Ave to Avenue, St to Street, Blvd to Boulevard), then search Thanks.io orders for each address and write the matching order ID into column B and send date into column C. Write Not Found if there is no match.
I need to check multiple order dates per address
For each address in column A of the Disputed Deliveries worksheet, search Thanks.io orders and return all matching orders. Write the count of orders found into column B, the most recent order ID into column C, and the most recent send date into column D.
Clean the address list, run the lookups, and flag anything suspicious
For each row in the Disputed Deliveries worksheet, extract just the primary street address from column A (remove apartment and unit designations), search Thanks.io orders by that address, and write the order ID into column B and send date into column C, or Not Found if no match. Note in column D if the original address had an apartment number stripped.
One prompt handles the normalization and the full lookup pass.
Try It
Get the 7-day free trial of SheetXAI and open your disputed delivery workbook — ask it to search Thanks.io orders for every address in column A and write the confirmation data back. Once the verification is done, see the bulk address update spoke to push corrected addresses back to Thanks.io for the re-send.