How to Connect Thanks.io to Excel (4 Methods Compared)

The Problem With Getting Sheet Data In and Out of Thanks.io

You have an Excel workbook full of data — recipient names, mailing addresses, personalized message fields, donor records. You need it pushed into Thanks.io to trigger physical mail orders, or you need order history pulled back out for reporting. And you need that to happen without an afternoon of manual CSV work.

Thanks.io is good at executing personalized direct mail at scale. But getting data from an Excel workbook into a live mail campaign is more steps than it looks. The default flow is a CSV export, a format check, an import into Thanks.io, an address validation round, and then the send — and that's before anything goes wrong.

Below are the four common ways teams handle this. Only the last one scales.

Method 1: Manual CSV Export

The default for Excel. You export the workbook to CSV, clean up the column headers to match Thanks.io's import spec, check that state fields are two-letter abbreviations, validate the zip codes, and upload. When the import rejects rows with formatting issues, you fix them and re-upload.

That's one campaign. When the next one comes around three weeks later, you do the same cycle again — same workbook, updated data, same friction. The CSV export is one more step compared to copy-paste, but the shape of the problem is identical: you are manually bridging the gap between your workbook and Thanks.io every single time.

Method 2: Power Automate

Power Automate has a Thanks.io connector. You can build a flow that triggers on a new worksheet row or a schedule, calls the Thanks.io API, and sends a piece of mail.

Quick check before going further: are you comfortable with flow triggers, connector actions, dynamic content mapping, and API authentication? If any of those feel foreign, this path is not for you — skip ahead to Method 3 or 4 and save yourself an afternoon.

If you cleared that gate, the flow works. Trigger on a table row or a manual run, map your Excel columns to Thanks.io fields, handle the zip code format, test with one row, promote it.

The structural ceiling shows up fast though.

A per-row flow is not a batch send. Each row triggers a separate API call, a separate action run, and a separate entry in the run history. When row 34 fails an address validation, the rest of the flow continues and you find out later when you go looking.

You probably just need the mailing to go out. You probably have no idea how to wire conditional error handling in Power Automate — and there's no reason you should. So you either hand it off to IT, or you build something fragile and hope the column names never change.

The more logic you add — filters, conditionals, multi-table lookups — the more brittle it gets.

Method 3: The Previous Generation — Connector Add-Ons

Until recently, the most practical option for recurring workbook-to-direct-mail workflows was a category of add-ons that let you define column mappings, save configurations, and re-run them. You picked your address range, tagged your fields, saved the setup, and executed.

That was a step up from manual exports. Saved configs meant repeatable runs without rebuilding the field map.

But you were still responsible for the mapping logic, the conditional row filtering, the renaming when a column changed. The tool handled the transfer — you still owned the thinking. When your workbook structure shifted, the config needed a fix before the next run.

This is the previous generation. It reduced the manual work without removing it.

The Easy Way: Using SheetXAI in Excel

There is a different way entirely. SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands what you're looking at, and through its built-in Thanks.io integration it can push to or pull from Thanks.io for you. No CSV exports, no column mapping configurations, no trigger setup. You just ask.

Example 1: Send letters to every donor row in the workbook

For each donor row in the Donors sheet — name (A), street (B), city (C), state (D), zip (E), donation amount (F) — send a Thanks.io letter using template ID from cell H1 and write the order ID into column G.

SheetXAI reads every row, executes the API calls, and writes the order confirmation back into the workbook so your records stay in sync.

Example 2: Check order status for disputed deliveries

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.

The pattern: instead of logging into Thanks.io and searching manually, you describe what you want and SheetXAI handles the lookup across every row.

Try It

Get the 7-day free trial of SheetXAI and open any Excel workbook with recipient addresses or Thanks.io campaign data, then ask it to do one of the tasks above. The Thanks.io integration is included in every SheetXAI plan.