The Scenario
You work in marketing ops. Your director asked for a direct mail ROI report — campaign by campaign, how many pieces went out, to which regions, what mail type, and at what cost. All of that data is in Thanks.io. None of it is in a Google Sheet, which is where the dashboard lives.
It's Thursday afternoon. The report is due Friday at noon.
The bad version:
- You log into Thanks.io and navigate to order history.
- You export the order log to CSV and open it in a separate tab.
- The CSV has columns in a different order from the dashboard sheet, so you spend 20 minutes rearranging them before pasting.
- You realize the export only goes back 90 days and you need 6 months, so you run three separate exports and stack them.
The dashboard is supposed to be self-serve. The fact that you're the one pulling this together manually means something in the process isn't right.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It calls Thanks.io's order history API and writes the results directly into the sheet — in whatever column layout you specify.
Open the SheetXAI sidebar and paste this prompt:
Fetch the last 100 Thanks.io orders and write recipient name, address, mail type, order date, and status into the Order History sheet starting at row 2.
SheetXAI pulls the order data and populates the sheet in the column layout you specified, starting where you told it to.
What You Get
- Recipient name, full address, mail type, order date, and delivery status written into the Order History sheet.
- Data starts at row 2, preserving your header row.
- The layout matches what you asked for — no manual column reordering.
- The most recent orders appear first.
What If the Data Is Not Quite Ready
I need order IDs in the output too
The downstream dashboard uses order ID as the unique key for deduplication.
Pull the full recent Thanks.io order list and paste it into the Order History sheet with columns: Order ID, Recipient Name, Street, City, State, Order Date, Mail Type, Status — starting at row 2.
I need to filter to postcards only
The report this week is specifically about postcard performance, not letters or notecards.
Fetch the last 500 Thanks.io orders, filter to only rows where mail type is postcard, and write order ID, recipient name, address, order date, and status into the Postcard History sheet starting at row 2.
The sheet already has data and I want to append only new orders
You pulled data last week through order ID 4420. You only want orders after that.
Fetch Thanks.io orders and write only the ones with an order date after the latest order date already in column F of the Order History sheet, appending to the first empty row. Include order ID, recipient name, address, mail type, order date, and status.
Pull the orders, calculate cost per piece, and flag outliers
Thanks.io orders include a cost field. You want to add a calculated column and flag any order where cost is more than twice the average.
Fetch the last 100 Thanks.io orders with cost data, write order ID, recipient name, mail type, order date, and cost into the Order History sheet, then add a column G that flags any row where cost is more than twice the average cost of all rows in column F. Start at row 2.
One prompt pulls the data and builds the analysis layer at the same time.
Try It
Get the 7-day free trial of SheetXAI and open your direct mail reporting sheet — ask it to pull Thanks.io order history into the layout your dashboard expects. Once the data is in, see the delivery verification spoke to cross-check orders against disputed addresses.