Google Sheets + Opendate
Google Sheets + Opendate
Google Sheets + Opendate integrations
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 this happens...
New Event On-SaleTriggers when an event goes on-sale in Opendate.TriggerPolling - automatically do this!
Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Opendate and Google Sheets
Discover other triggers and actions you can use with Opendate and Google Sheets
New Event ConfirmedTriggers 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 plan- New 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 plan - New 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 plan - New 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 plan - Venue 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 app- Artist NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- EventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Date Filter
- Page Number
ActionThis is an event a Zap performs.SearchFind existing data in your app- Artist NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Confirm IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- EventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- EventID
ActionThis is an event a Zap performs.SearchFind existing data in your app- EventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- EventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- confirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Venue Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- confirmRequired
- finance items idRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Event IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- EventIDRequired
- FinanceIDRequired
- FinanceLineItemsIDRequired
- FinanceCategoryIDRequired
- actual
ActionThis is an event a Zap performs.SearchFind existing data in your app- Orders 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 found- Event 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 found- EventIDRequired
- 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 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
- 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.- 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
- 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
- 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 plan - New 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 plan - New 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 plan - EventIDRequired
- 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 app- ScopeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Email AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- ConfirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Start DateRequired
- End DateRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- ConfirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Orders GUIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Start DateRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- EventID
- Note Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- Confirm IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- ConfirmRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Event IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- fan_IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- EventIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Eventbrite Event IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- confirmRequired
- Ticket IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Fan IDRequired
- VenueIDRequired
- SubscribedRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- NameRequired
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- EventID
- 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 found- Fan 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 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- 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
- Row count
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
- 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
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
Related categories