Guide

How to create wallet passes from a Google Sheet

To create wallet passes from a Google Sheet, use the free Wallet Pass Builder add-on: design one pass with variables like {name}, match them to your columns, and click Create passes. Every row gets its own Apple Wallet and Google Wallet pass, each person's link is written back into the sheet, and editing a row updates the pass already on their phone. Here's the whole setup, plus two ways to do it without the add-on.

Last updated November 15, 2026. Facts about Apple Wallet and Google Wallet were checked against Apple’s and Google’s own documentation, linked in the sources.

The short answer

  1. In WalletPassBuilder, design a pass with variables such as {name} and {member_id} where each person’s details go.
  2. Install Wallet Pass Builder from the Google Workspace Marketplace, then open it in your sheet from Extensions and connect your account.
  3. Pick the pass, match each variable to a column, choose the column that identifies each person (usually email), and click Create passes.
  4. The add-on fills in a Pass link column. Send each person their link; it opens Apple Wallet on an iPhone and Google Wallet on Android.

The add-on is free to install. New WalletPassBuilder accounts get 20 free pass credits, and Apple Wallet setup is handled for you, so there’s nothing to configure with Apple.

Wallet Pass Builder for Google Sheets

A pass for every row, with links and status written back to the sheet.

Three ways to do it

RouteBest forUpdates passes when a row changes
Google Sheets add-onA list you keep in Sheets: members, staff, attendees, studentsYes, with Sync changes
CSV upload in the builderA one-off batch, or a sheet from Excel or another toolUpload again
ZapierA pass the moment a new row is added, sent on by email or textYes, with an update step

1. Design one pass with variables

Every pass from the sheet starts from one pass you design once. Wherever a detail differs per person, type { in the builder and add a variable: {name} as the title, {member_id} in a field and as the QR code, {tier}, {points} or {expires} wherever they belong. Publish it, and it’s ready for the sheet.

The Personalized pass template already uses variables. No account yet? Click New pass in the add-on and pick a template there. For a worked example, see how to make QR code membership cards.

2. Set up the sheet

EmailNameMember IDTier
ada@example.comAda LovelaceM-1001Gold
grace@example.comGrace HopperM-1002Silver

3. Install the add-on and connect

  1. Open Wallet Pass Builder on the Google Workspace Marketplace and click Install.
  2. In your sheet, go to Extensions, then Wallet Pass Builder, then Open.
  3. Click Connect WalletPassBuilder, sign in or create an account in the new tab, and approve. The sidebar updates by itself.

4. Create the passes

  1. Under Select Pass, choose your pass. Only live passes with variables are listed.
  2. Under Map Columns, choose the column for each variable. Each one shows the value from row 2 as a preview.
  3. Next to Match by, choose the column that identifies each person.
  4. Click Create passes. The add-on adds a Pass link and a Pass status column and fills them in, row by row.

5. Send each person their link

Each link is that person’s own pass. Opened on an iPhone it adds the pass to Apple Wallet; on Android, to Google Wallet. Send the links however you already reach people: a Gmail mail merge, your email tool, a text message, or printed as a QR code. For what to write, see how people add a pass to Apple Wallet or Google Wallet.

6. Edit a row, update the pass

Change a tier, add points, fix a typo or add new people, then click Sync changes. Only new and edited rows are sent. Passes already saved update on people’s phones; there’s no new link to send. Click Sync all to send every row again.

To tell everyone at once, such as a new offer or an event change, send a lock-screen message from the dashboard. See wallet pass notifications.

A photo or banner for each person

If the pass has a banner or a photo, each person can have their own, such as a staff ID photo. Add a column of image links, either a direct link to an image or a Google Drive file shared with anyone who has the link, and map it under Banner or Photo. Leave a cell empty to use the pass’s own image.

Without the add-on: upload a CSV

  1. In Google Sheets, choose File, then Download, then Comma-separated values (.csv).
  2. In the builder, open Settings, then Dynamic data, then Open data sheet, and click Upload CSV. Click a row to preview that person’s pass.
  3. Create the pass. Every row gets its own link: click Download list (.csv) to get them all, ready for a mail merge.

Prefer a pass the moment a row is added? Use Zapier: a new spreadsheet row triggers Issue a Pass to a Person. See how to create wallet passes with Zapier.

What people use it for

Membership cards

Name, member number, tier and renewal date, with the member number as the QR code checked at the door.

Event tickets and badges

One row per attendee, with their name, ticket type and a unique code. See digital event tickets.

Staff and student IDs

A photo column, name, role and ID number, updated from the sheet when someone changes role.

Points and balances

Keep each customer’s points or balance in a column, and sync after you update it.

Good to know

Frequently asked questions

How do I create wallet passes from a Google Sheet?+

Install the free Wallet Pass Builder add-on from the Google Workspace Marketplace, open it from Extensions in your sheet and connect your WalletPassBuilder account. Pick a pass you designed with variables such as {name}, match each variable to a column, choose the column that identifies each person (usually email) and click Create passes. Every row gets its own Apple Wallet and Google Wallet pass, and the add-on writes each person's pass link back into the sheet.

Can Google Sheets make Apple Wallet passes?+

Not by itself. Apple Wallet passes have to be signed with an Apple certificate, which a spreadsheet can't do. An add-on such as Wallet Pass Builder sends your rows to a pass platform that signs each pass and gives you a link that opens Apple Wallet on an iPhone and Google Wallet on Android.

Does each row get its own pass?+

Yes. Each row becomes one person's pass, filled in with that row's values: their name, member number, tier, points or ticket details. The column you choose under Match by (usually email) ties the row to the pass, so syncing again updates that person's pass instead of making a second one.

What happens when I change a row?+

Click Sync changes and the add-on sends only the new and edited rows. Passes people have already saved update on their phones, with no new link to send.

Is the Google Sheets add-on free?+

The add-on is free to install. The passes use WalletPassBuilder pass credits, the same as passes made in the dashboard: new accounts get 20 free credits, and the plan is $49 a month with 1,000 credits. Updating a pass from the sheet doesn't use credits.

Who handles the Apple Wallet setup?+

WalletPassBuilder does: Apple Wallet setup is handled for you, including signing and certificate renewals. Want passes under your own Apple Developer account? Add your Pass Type ID any time.

Can I do it without installing an add-on?+

Yes. Download the sheet as a CSV and upload it to the data sheet in WalletPassBuilder's builder, or connect Google Sheets to WalletPassBuilder through Zapier so every new row issues a pass. The add-on is the only route that writes links back into the sheet and updates passes when you edit a row.

Sources

Apple’s newer developer pages load dynamically, so where a number comes from Apple it is taken from its Wallet Developer Guide and support pages. If Apple’s or Google’s current documentation differs, follow theirs.

Be on the lock screen in a few minutes.

Your first pass is quick to make. Pick a template, add your logo, and share the link.