Google Sheets + Ticket Tailor + Filter by Zapier
Add Google Sheets rows for new check-ins via Ticket Tailor
Keep a record of your check-ins in a Google Sheets spreadsheet effortlessly. Once this template is active, whenever an attendee arrives at your event and has their ticket scanned using the Ticket Tailor check-in app, Zapier creates a corresponding row in your Google Sheets spreadsheet.
Keep a record of your check-ins in a Google Sheets spreadsheet effortlessly. Once this template is active, whenever an attendee arrives at your event and has their ticket scanned using the Ticket Tailor check-in app, Zapier creates a corresponding row in your Google Sheets spreadsheet.
- When this happens...
Issued Ticket UpdatedTriggers when an existing issued ticket is updated.
TriggerInstantThis event starts a Zap instantly. - automatically do this...
Only continue if...Set up rules to specify when this Zap can continue running.
ActionFilterSet conditions for when a specific action should run in your Zap. - then do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Event Created
Triggers when a new event is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Updated
Triggers when an existing event is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Issued Ticket Updated
Triggers when an existing issued ticket is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Updated
Triggers when existing order is updated (currency values are always in cents, or equivalent, with no decimals).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Box Office Overview
Show box office statistics information.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Bundle idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Issued ticket idRequired
QuantityRequired
Check in at
Local unique id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
CodeRequired
Booking fee
Booking fee percent
Expires
Max redemptions
Price
Price percent
Ticket types
Products
TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Discount idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Discount idRequired
Name
Booking fee
Booking fee percent
Code
Expires
Max redemptions
Price
Price percent
Ticket types
Products
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Limit
Status
Start at
Start at (greater than)
Start at (greater than or equals)
Start at (less than)
Start at (less than or equals)
End at
End at (greater than)
End at (greater than or equals)
End at (less than)
End at (less than or equals)
Starting after
Ending before
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Event occurrence idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Starting after
Ending before
Limit
Override id
Start at
Start at (greater than)
Start at (greater than or equal)
Start at (less than or equal)
End at
End at (greater than)
End at (greater than or equal)
End at (less than)
End at (less than or equal)
Event series idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Starting after
Ending before
Limit
Status
Created at
Created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Access code
Call to action
Currency
Description
Max tickets sold per occurrence
Name
Postal code
Tickets available at
Tickets available at message
Tickets unavailable at
Tickets unavailable at message
Venue
Voucher ids
Waitlist active
Waitlist call to action
Waitlist event page text
Waitlist confirmation message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Hold idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Starting after
Ending before
Limit
Event id
Created at
Created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
Updated at
Updated at (greater than)
Updated at (greater than or equal)
Updated at (less than)
Updated at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Issued ticket idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Issued ticket idRequired
Void to hold
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order idRequired
Address 1
Address 2
Address 3
Email
First name
Last name
Phone
Postal code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Override idRequired
Max sellable tickets
Name
Overriding element id
Overriding element price
Overriding element quantity
Overriding element status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Starting after
Ending before
Limit
Event series id
Status
Created at
Created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
Updated at
Updated at (greater than)
Updated at (greater than or equal)
Updated at (less than)
Updated at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Store IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Store IdRequired
Name
Currency
Product ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event Series IdRequired
Ticket Group IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Access code
Booking fee
Description
Discounts
Hide after
Hide until
Hide when sold out
Max per order
Min per order
NameRequired
PriceRequired
QuantityRequired
Show quantity remaining
Show quantity remaining less than
Status
Group id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Ticket type idRequired
Access code
Booking fee
Description
Discounts
Hide after
Hide until
Hide when sold out
Max per order
Min per order
Modify quantity
Name
Price
Show quantity remaining
Show quantity remaining less than
Status
Zero tickets
Group id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Voucher idRequired
Voucher code idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Voucher idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Starting after
Ending before
Limit
Expiry date
Expiry date (greater than)
Expiry date (greater than or equal)
Expiry date (less than)
Expiry date (less than or equal)
Created at
Created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Waitlist signup idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Only continue if...Required
ActionThis is an event a Zap performs.FilterSet conditions for when a specific action should run in your Zap.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 planDrive
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
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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 appDrive
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
Event Deleted
Triggers when an existing event is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Issued Ticket Created
Triggers when a new issued ticket is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Created
Triggers when new order is created (currency values are always in cents, or equivalent, with no decimals).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event series id (prefixed with "es_")Required
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event series idRequired
Access code
Booking fee
DescriptionRequired
NameRequired
PriceRequired
Product ids
Status
Ticket type idsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Bundle idRequired
Access code
Booking fee
Description
Name
Price
Product ids
Status
Ticket type ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Limit
Starting after
Ending before
Event id
Event series id
Issued ticket id
Created at
Created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
Check in at
Check in at (greater than)
Check in at (greater than or equal)
Check in at (less than)
Check in at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Discount idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Limit
Code
Starting after
Ending before
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
End dateRequired
End time
Hidden
Override id
Start dateRequired
Start time
Unavailable
Unavailable status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Event occurrence idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Event occurrence idRequired
End date
End time
Hidden
Override id
Start date
Start time
Unavailable
Unavailable status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Access code
Currency
Description
Max tickets sold per occurrence
Postal code
Tickets available at
Tickets available at message
Tickets unavailable at
Tickets unavailable at message
Venue
Voucher ids
Waitlist active
Waitlist call to action
Waitlist event page text
Waitlist confirmation message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Status
Reference type
Reference id
Starting after
Ending before
Limit
Created at
created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event idRequired
NoteRequired
Ticket type idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Hold idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full nameRequired
Event id
Ticket type id
Hold id
Email
Send email
Barcode
Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Limit
Starting after
Ending before
Event id
Event series id
Order id
Barcode
Name
Email
Reference
Status
Created at
Created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order idRequired
Transaction id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Created at
Created at (greater than)
Created at (greather than or equal)
Created at (less than)
Created at (less than or equal)
Starting after
Ending before
Limit
Name
Email
Transaction id
Barcode
Event ids
Event series ids
Status
Referral tag
Store Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Max sellable tickets
Name
Overriding element idRequired
Overriding element price
Overriding element quantity
Overriding element status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Booking fee
Currency
Description
Event series ids
Instructions
Issue ticket voucher
Linked to all event series
NameRequired
PriceRequired
Quantity
Quantity per event
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product idRequired
Booking fee
Currency
Description
Event series ids
Instructions
Issue ticket voucher
Linked to all event series
Modify quantity
Name
Price
Quantity
Quantity per event
Quantity unlimited
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Limit
Starting after
Ending before
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event Series IdRequired
Bundle Ids
NameRequired
Max Per Order
Max Quantity
Min Per Order
Ticket Type Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event Series IdRequired
Ticket Group IdRequired
Bundle Ids
Name
Max Per Order
Max Quantity
Min Per Order
Ticket Type Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Ticket type idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Voucher idRequired
Starting after
Ending before
Limit
Expiry date
Expiry date (greater than)
Expiry date (greater than or equal)
Expiry date (less than)
Expiry date (less than or equal)
Created at
Created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Codes
Event series ids
Expiry
Interval
NameRequired
Partial redemption
Voucher type
ValueRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Voucher idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Voucher idRequired
Codes
Event series ids
Expiry
Interval
Name
Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event series idRequired
Event ids
Email
Is notified
Starting after
Ending before
Limit
Created at
Created at (greater than)
Created at (greater than or equal)
Created at (less than)
Created at (less than or equal)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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 planDont 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
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.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
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
About Google Sheets
Related categories
About Ticket Tailor
Related categories
