Refound your company for the AI era at ZapConnect 2026. Save your spot →
Google Sheets + Perkstar integrations
Add new Perkstar customer enrolments to Google Sheets rows
Keep a portable enrolment register without copying IDs by hand. This automation adds a Google Sheets row for each new Perkstar customer enrolment, with stable event, customer, enrolment, card, source, and timestamp fields available for mapping. Choose a spreadsheet with matching column headers during setup.
- When this happens...

New Customer EnrolmentTriggers when a customer is enrolled in a loyalty card.TriggerInstant - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Perkstar and Google Sheets
Discover other triggers and actions you can use with Perkstar and Google Sheets
Automation FiredTriggers when an automated-message firing is recorded.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Card
- Include test events
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Find customer byRequired
- Customer lookup valueRequired
- CardRequired
- Points to awardRequired
- Source points award IDRequired
- Note
- Create customer if missing
- First name
- Last name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Find customer byRequired
- Customer lookup valueRequired
- CardRequired
- Create customer if missing
- First name
- Last name
- Enrolment source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Find customer byRequired
- Customer lookup valueRequired
- CardRequired
- Purchase amount (minor units)Required
- Source order or payment IDRequired
- Note
- Create customer if missing
- First name
- Last name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Find transaction byRequired
- Transaction referenceRequired
- Original action (when using source ID)
- Reason
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CustomerRequired
- Email address
- Phone number
- External reference
- First name
- Last name
- Date of birth
- Has marketing consent
- Has ad tracking consent
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Find customer byRequired
- Customer lookup valueRequired
- CardRequired
- Status
ActionThis is an event a Zap performs.SearchFind existing data in your app- Find customer byRequired
- Customer lookup valueRequired
- CardRequired
- Status
- Create customer if missing
- First name
- Last name
- Enrolment source
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Overwrite All Columns
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Api_docs_info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet NameRequired
- Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Customer AnonymisedTriggers when a customer’s personal data is anonymised.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Customer Lifecycle Group ChangedTriggers when a customer moves between lifecycle groups, not when a saved segment changes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Card
- Include test events
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Find customer byRequired
- Customer lookup valueRequired
- CardRequired
- Stamps or visits to addRequired
- Source activity IDRequired
- Note
- Create customer if missing
- First name
- Last name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Email address
- Phone number
- External reference
- First name
- Last name
- Date of birth
- Has marketing consent
- Has ad tracking consent
- Unique request ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Find customer byRequired
- Customer lookup valueRequired
- CardRequired
- Activity typeRequired
- Source transaction IDRequired
- Purchase amount (minor units)
- Balance change
- Note
- Create customer if missing
- First name
- Last name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Find customer byRequired
- Customer lookup valueRequired
- CardRequired
- Balance to redeemRequired
- Source redemption IDRequired
- Note
- Create customer if missing
- First name
- Last name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Enrolment or passRequired
- MessageRequired
- Source event IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Find customer byRequired
- Customer lookup valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Find customer byRequired
- Customer lookup valueRequired
- Email address
- Phone number
- External reference
- First name
- Last name
- Date of birth
- Has marketing consent
- Has ad tracking consent
- Unique request ID
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related categories




