Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

Apply conditional formatting to cells in a Google Sheets spreadsheet based on their values.

Creates a new worksheet in a Google Sheet.

Permanently delete a worksheet from a Google Sheets spreadsheet. Warning: This action cannot be undone.

Apply date, number, or style formatting (colors, bold, italic, strikethrough) to a range of cells in a Google Sheets spreadsheet.

Rename a worksheet in a Google Sheets spreadsheet.

Sort data within a specified range in Google Sheets by a chosen column in ascending or descending order.

Update one or more rows in a specific spreadsheet (with line item support).

Find up to 500 rows based on a column and value as line items.

Finds a worksheet by title.

Return up to 1,500 rows as a single JSON value or as line items.

Get a specific Google Spreadsheet by its ID. Returns the raw spreadsheet data from the Google Sheets API.

Finds a spreadsheet by name, or creates one if none is found.

Finds or creates a specific lookup row.

Triggers when a pass is issued (share link, form, order, or API), before the holder adds it to a wallet. Carries the add-to-wallet link for a text or email step.

Triggers when a holder removes a pass from their wallet or it is revoked.

Adds (or deducts, with a negative number) loyalty points for one holder. Crossing the reward threshold triggers the full reward flow — new code, face change, push notification.

Creates a loyalty program on one of your passes — the same rules and credits as the Studio wizard. On a coupon pass it builds the three-stage loop; on a membership card it runs in single-card mode (stages on the back, optional tiers). The program starts as a draft; launch it with Update Loyalty Program.

Invites a connected Shopify store's existing customers to a membership pass by email, with claim links that link each card to the Shopify customer. Nothing is charged until a customer adds their card. Runs a sweep now and can leave the hourly sweep on for new customers.

Sends a message to everyone holding a pass, now or at a date and time: a campaign. iPhone shows it on the lock screen and as the latest update on the back of the pass; Android as a Google Wallet notification. Costs 2 credits per notified device, charged at the start.

Redeems a pass code the way the staff app does: validates the code, decrements uses, pushes the updated pass to the holder's wallet, fires Pass Redeemed, and advances a loop when the pass is spent. An event ticket is never refused for a second scan: the answer says when and where it was scanned before. Add an Order ID to record an online order instead of a counter scan.

⚠️ Deliberately revokes EVERY pass sharing a barcode (leaked shared code, cancelled event ticket batch). Dry Run is ON by default — it reports how many passes WOULD be revoked without touching them. Turn it off to execute.

Updates template fields — and optionally the venue location — and pushes the change to EVERY active holder of the pass. Use for event changes, moving pop-ups, or template-owned fields (title, details, terms, expiry).

Updates a pass design — name, status (publish or archive), distribution, colors, texts, images by URL — and pushes it to every holder like a Studio save. Per-holder values live in Update One Holder's Pass.

Finds a pass holder by email, phone (any format), or barcode content. Returns identity, pass instances, and loyalty state.

Returns one loyalty program: status, earning rules, offers, single-card back lines, tiers, and the passes it runs on.

Lists the account's holder profiles — one row per person, with every email, phone, and member id seen on their passes — as line items. Paginated. Not available on team API keys.

Lists a program's members with points balance, loop state, active code, tier, and identity, as line items. Paginated.

Update Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.

Copy data from one range to another within a Google Sheets spreadsheet, with options for what to paste (values, formatting, etc.).

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Format a row in a specific spreadsheet.

Set data validation rules on a range of cells in Google Sheets to control what data can be entered.

Update a row in a specific spreadsheet with optional formatting.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a spreadsheet by name.

Get data from a specific range in a Google Spreadsheet using A1 notation (e.g., "A1:D10", "B2:E5").

Get a specific spreadsheet row by its row number (ID). Row 1 is typically the header row.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row.

Finds or creates a specific find worksheet.

Triggers when a pass is redeemed — at the counter, on an order, or via the API.

Triggers when a pass is updated and pushed to holders.

Creates a pass design headlessly — the same object the Studio builds, images by URL. Drafts are free; publishing costs the same credits as in the Studio.

Drafts the translation of a pass into one language. Nothing is saved: review the rows, then send them with Update Pass (Added Languages + Translations).

Issues a pass to a customer by email or phone. With an email, Pass Studio sends the Apple & Google Wallet buttons unless Send Wallet Email or the pass's invite email is off. Deduplicates per email, phone, or barcode when you supply one — re-running for the same customer returns the existing pass.

Feeds an order into the Pass Studio engine: detects Pass Studio codes, matches the customer to a holder, accrues or redeems loyalty points, and issues a pass when appropriate. Idempotent — re-sending the same order is safe.

Redeems a reward on a membership card in one call: deducts the reward's cost from the member's points, clears or rewrites the Reward lines on the back of the card, pushes the card with an optional notification, and fires Pass Redeemed. For merchants whose own software decides when a reward is earned.

Revokes ONE holder's pass — it visibly dies in their wallet. If several live passes share the barcode, the action fails safely; use Revoke ALL by Barcode for deliberate mass revocation.

Updates fields on a single holder's pass and pushes it to their wallet. Template-owned keys (title, details, terms, expiry) are rejected — use Update Pass for ALL Holders for those.

Launches, pauses, or edits one loyalty program: status, name, earning rules, offers, notifications, single-card back lines, tiers. Send only what changes.

Returns one pass — design (colors, texts, image URLs, fields), status, distribution, share URL, editable field keys and labels, and the active-holder count.

Lists the holders (pass instances) of one pass, newest activity first, as line items — feed them to Looping by Zapier. Paginated: pass the returned Next Cursor to get the next page.

Lists the account's loyalty programs with their rules, status, and the pass ids each one runs on, as line items.