Microsoft Excel + PassKit Membership

Update rows in Microsoft Excel when new passes are installed to wallets in PassKit Membership

Keep your Microsoft Excel records up-to-date with this efficient workflow. Whenever a new pass is installed to the wallet in the PassKit Membership app, this automation will instantly update a row in a selected Microsoft Excel spreadsheet. Save time, reduce manual data entry errors, and ensure accurate tracking of your membership updates.

When this happens...
Pass Installed to Wallet
Triggers when a pass is installed to a wallet. Dependent on the Pass Holder being connected to internet.
TriggerInstant
automatically do this!
Update Row
Updates a row in a specific worksheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Program IdRequired
Trigger
Instant
Try It
- Program IdRequired
Trigger
Instant
Try It
- PassKit Generated Member Id (22 characters)
- Program Id
- External Id
- Points
- Secondary Points
- Tier Points
Action
Write
- PassKit Generated Member Id (22 characters)
- Program Id
- External Member Id
- Address
- Latitude
- Longitude
- Altitude
- External Event Id
- External Device Id
- External Service Id
- Notes
- Mata Data Key
- Mata Data Value
Action
Write
- PassKit Generated Member Id (22 characters)
- Program Id
- External Id
Action
Write

- ProgramRequired
- TierRequired
Action
Write
- PassKit Generated Member Id (22 characters)Required
Action
Write

- PassKit Generated Member Id (22 characters)
- Program Id
- External Id
- ProtocolRequired
- Alternative Email
Action
Write
- ProgramRequired
- TierRequired
- Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write

- Program IdRequired
Trigger
Instant
Try It
- Program IdRequired
Trigger
Instant
Try It
- PassKit Generated Member Id (22 characters)
- Program IdRequired
- External Id
- Tier IdRequired
Action
Write
- PassKit Generated Member Id (22 characters)
- Program Id
- External Member Id
- Address
- Latitude
- Longitude
- Altitude
- External Event Id
- External Device Id
- External Service Id
- Notes
- Mata Data Key
- Mata Data Value
Action
Write
- PassKit Generated Member Id (22 characters)
- Program Id
- External Id
- Points
- Secondary Points
- Tier Points
Action
Write
- Program IdRequired
- External IdRequired
Action
Write
- PassKit Generated Member Id (22 characters)
- Program Id
- External Id
- Last Name
- First Name
- Full Name
- Suffix
- Salutation
- Gender
- Date of Birth
- Email Address
- Mobile Number
Action
Write
- PassKit Generated Member Id (22 characters)
- Program Id
- External Id
- Points
- Reset Points
- Secondary Points
- Reset Secondary Points
- Tier Points
- Reset Tier Points
Action
Write
- PassKit Generated Member Id (22 characters)
- Program Id
- External Member Id
- Expiry Date
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more