How to Connect Piggy to Google Sheets (4 Methods Compared)

The Problem With Getting Sheet Data In and Out of Piggy

You have a Google Sheet full of data — customer UUIDs, purchase totals, voucher codes, product SKUs — and Piggy needs to act on it. Or you need to pull credit balances, perk lists, and merge results back out into a sheet so your team can review them.

Piggy is good at running loyalty programs: awarding credits, issuing vouchers, managing contacts, and tracking redemptions. But the gap between a spreadsheet and the Piggy API is filled with repetitive, error-prone work. The usual flow is exporting a CSV, opening the Piggy dashboard, doing the operation customer by customer or batch by batch, copying results into a new column, and hoping nothing fell through the cracks.

Below are the four common ways teams close that gap. Only the last one gets you there without pain.

Method 1: Manual Copy-Paste

The default. Open your Google Sheet, grab the UUIDs from column A, go into Piggy, find each customer, run the action — award credits, check a balance, redeem a voucher — and come back to log the result.

For 10 customers that's inconvenient. For 200 it's a full afternoon. The work itself isn't hard. It's the sheer repetition of switching between two tabs for every row that grinds you down — and the gnawing awareness that you're going to fat-finger a UUID somewhere around row 140 and not catch it until someone complains that their credits never arrived.

Method 2: Zapier or Make

Both platforms have Piggy connector options. You can wire up a trigger on a sheet change or a schedule, call the Piggy API, and write the result back.

Before you go further — do you know what an API connector is? A trigger event? A dynamic field map? An OAuth credential scope? If those terms feel abstract, this path ends in a frustrating afternoon. Method 3 or 4 will serve you better.

If you're still here: the setup involves authenticating to Piggy's API, picking the right action endpoint, mapping every field by hand — UUID columns, credit amounts, promotion IDs — and then debugging the type mismatches when Piggy expects a string and your sheet sends a number.

The automation works, once it's built. But it fires on one row at a time.

Sending 200 credit awards through a Zap means 200 separate API calls, 200 trigger fires, and a task log that becomes genuinely hard to audit when row 83 times out and the rest continue without it.

You probably just need to award the credits and move on. You probably have no idea how to wire a multi-step Zap against Piggy's API — and that's a reasonable position to be in. So you hand it off to whoever on your team builds automations, and now the loyalty campaign is blocked on a Slack thread that may or may not get answered before Friday.

And once you need to do something that spans the whole sheet — like sorting by balance or filtering by tier — you've left Zapier's native row-by-row logic entirely.

Method 3: The Previous Generation — Connector Add-Ons

Until recently, the best option for repeatable spreadsheet-to-Piggy workflows was a category of add-ons that let you configure column mappings, save templates, and run them against a range.

That was a real step up from copy-paste. Configs were reusable. Output was consistent. You could hand the template to someone else and they could run it.

But you were still the one responsible for mapping every column, naming every field to match Piggy's API, setting up the schedule, and deciding which rows to include. The add-on moved the data; the judgment was still all yours. And the moment your sheet added a column or Piggy changed a field name, your saved config broke.

This is the previous generation. It worked, but it asked a lot.

The Easy Way: Using SheetXAI in Google Sheets

There is a different way entirely. SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you are looking at, and through its built-in Piggy integration it can award credits, pull balances, generate vouchers, validate codes, and more — without you configuring a template or building an automation. You just ask.

Example 1: Award 500 credits to everyone who spent over $100 last month

For each customer UUID in column A where column C says "Eligible", award 500 Piggy credits and write SUCCESS or FAILED into column D

SheetXAI reads the filter condition, hits the Piggy API for each matching row, and writes the result back inline. You see exactly which rows succeeded and which ones need a retry.

Example 2: Pull the full credit balance for your customer list and surface the top tier

For each UUID in column A, fetch the current Piggy credit balance, write it into column B, then sort the sheet descending by column B

The pattern: instead of pulling the data first, formatting it, and then analyzing it, you ask for the retrieval and the sort in one prompt. SheetXAI handles both steps without you leaving the sheet.

Try It

Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of customer UUIDs or voucher codes, then ask SheetXAI to run a Piggy operation against it. The Piggy integration is included in every SheetXAI plan.