Google Sheets + Opendate
Create Google Sheets spreadsheets when new events are on-sale in Opendate
When a new event goes on-sale in Opendate, this template will create a Google Sheet in which you can track ticket sales.
When a new event goes on-sale in Opendate, this template will create a Google Sheet in which you can track ticket sales.
- When this happens...
New Event On-SaleTriggers when an event goes on-sale in Opendate.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Event Confirmed
Triggers when a new event is confirmed in Opendate.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Finance Category
Triggers when a new Finance Category is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Inbound Submission
Triggers when a new Inbound submission is created
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Order
Triggers when a new order is created in Opendate.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planVenue UUIDRequired
SubscribedRequired
First Name
Last Name
Email Address
Phone Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EventIDRequired
IncomeRequired
Expense TypeRequired
ActivityRequired
On SettlementRequired
Issued OnRequired
Payment Method
ArtistID
Payee
Reference Number
CategoryID
Description
Amount
estimate
actual
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event Date
Event Start Time
VenueID
Event NameRequired
Operator
Upside Percentage
Dollar Amount
ArtistID
TeamIDRequired
Ticket 1 Name
Ticket 1 Qty
Ticket 1 Price
Ticket 2 Name
Ticket 2 Qty
Ticket 2 Price
Ticket 3 Name
Ticket 3 Qty
Ticket 3 Price
Ticket 4 Name
Ticket 4 Qty
Ticket 4 Price
Expense 1 Name
Expense 1 Amount
Expense 2 Name
Expense 2 Amount
Expense 3 Name
Expense 3 Amount
Expense 4 Name
Expense 4 Amount
Expense 5 Name
Expense 5 Amount
Event has a facility maintenance fee
Facility Maintenance Fee Amount Per Ticket
Soft Merch Rate
Hard Merch Rate
Does the Offer have a Merch Rate
Event has a charity deduction
Charity Deduction Per Ticket
Income 1 Name
Income 1 Price
Income 1 Qty
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tag IDRequired
Taggable IDRequired
Taggable Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id
ActionThis is an event a Zap performs.SearchFind existing data in your appArtist NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDate Filter
Page Number
ActionThis is an event a Zap performs.SearchFind existing data in your appArtist NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appConfirm IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEventID
ActionThis is an event a Zap performs.SearchFind existing data in your appEventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appconfirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appVenue Name
ActionThis is an event a Zap performs.SearchFind existing data in your appconfirmRequired
finance items idRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEvent IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEventIDRequired
FinanceIDRequired
FinanceLineItemsIDRequired
FinanceCategoryIDRequired
actual
ActionThis is an event a Zap performs.SearchFind existing data in your appOrders GUIDRequired
EventIDRequired
Event Date
Order Qty
Menu Display Name
Menu Price
Food and Beverage Tax
State Tax
category
type
size
VenueIDRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundEvent DateRequired
EventIDRequired
Orders GUID
Order Qty
Menu Display Name
Menu Price
Food and Beverage Tax
State Tax
category
type
size
VenueIDRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundEventIDRequired
FinanceIDRequired
FinanceLineItemsIDRequired
FinanceCategoryIDRequired
actual
IncomeRequired
Expense TypeRequired
ActivityRequired
On SettlementRequired
Issued OnRequired
Payment Method
ArtistID
Payee
Reference Number
CategoryID
Description
Amount
estimate
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo 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.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
New Event On-Sale
Triggers when an event goes on-sale in Opendate.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Event Published
Triggers when a new event is published in Opendate.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Finance Item
Triggers when a new item is added to the Finance section in Opendate
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEventIDRequired
Event Date
Orders GUID
Order Qty
Menu Display Name
Menu Price
Food and Beverage Tax
State Tax
category
type
size
VenueIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tag NameRequired
Tag TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.confirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appScopeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmail AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appConfirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStart DateRequired
End DateRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appConfirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrders GUIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStart DateRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEventID
Note Name
ActionThis is an event a Zap performs.SearchFind existing data in your appConfirm IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appConfirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEvent IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appfan_IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEventbrite Event IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appconfirmRequired
Ticket IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFan IDRequired
VenueIDRequired
SubscribedRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundEventID
Event Date
Event Start Time
VenueID
Event NameRequired
Operator
Upside Percentage
Dollar Amount
ArtistID
TeamIDRequired
Ticket 1 Name
Ticket 1 Qty
Ticket 1 Price
Ticket 2 Name
Ticket 2 Qty
Ticket 2 Price
Ticket 3 Name
Ticket 3 Qty
Ticket 3 Price
Ticket 4 Name
Ticket 4 Qty
Ticket 4 Price
Expense 1 Name
Expense 1 Amount
Expense 2 Name
Expense 2 Amount
Expense 3 Name
Expense 3 Amount
Expense 4 Name
Expense 4 Amount
Expense 5 Name
Expense 5 Amount
Event has a facility maintenance fee
Facility Maintenance Fee Amount Per Ticket
Soft Merch Rate
Hard Merch Rate
Does the Offer have a Merch Rate
Event has a charity deduction
Charity Deduction Per Ticket
Income 1 Name
Income 1 Price
Income 1 Qty
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFan IDRequired
VenueIDRequired
SubscribedRequired
Venue UUIDRequired
SubscribedRequired
First Name
Last Name
Email Address
Phone Number
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
About Google Sheets
Related categories
