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 a Google Sheet. 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 sheet, find the matching order (if there is one), copy the order ID, go back to the sheet, paste it in column B.
- You do this 30 times.
The cognitive cost of switching between tabs 60 times while the queue piles up is a specific kind of exhausting that has nothing to do with the actual support work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads every address in your column and queries Thanks.io's order search for each one, writing the results back in place.
Open the SheetXAI sidebar and paste this prompt:
For each street address in column A of the Disputed Deliveries sheet, 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, so you have a complete verification record without leaving the sheet.
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 immediately which tickets need escalation.
- All 30 lookups run in a single prompt — no tab switching.
What If the Data Is Not Quite Ready
I want a Found or Not Found flag plus the order ID
Your manager wants a simple status column that your team can filter on.
Search Thanks.io orders for each address in column A of the Disputed Deliveries sheet and write Found or Not Found into column B, plus the order ID into column C if found.
The addresses have inconsistent formatting
Some rows have "Ave" and some have "Avenue," which might affect search accuracy.
Normalize the address formatting in column A of the Disputed Deliveries sheet (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
A few customers claim they should have received two separate mailings. You need to know if both orders exist.
For each address in column A of the Disputed Deliveries sheet, 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
Some rows in column A have apartment numbers that Thanks.io may not match on. You want to strip those and run the search on just the street address portion.
For each row in the Disputed Deliveries sheet, 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 list — 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.