Zapier Integration
This article includes:
- Connecting your Zapier account
- Zapier Common Terminology
- Available Compatible Apps
- Zapier Triggers
- Sample Data Sets
Zapier is the easiest way to automate your workflows and feed ticketing data into external third party tools.
It is a great way to connect our platform with a large variety of different
softwares and platforms. Once an order is created in our system, order or ticket
data can flow to any platform of your choosing that is supported by Zapier.
Note: We are currently in ‘Private’ Mode on Zapier and requires an invite from us directly to get started. Please contact your account manager for any questions and we can send over our Zapier connection link for access.
Once you have the connection link, please follow the below steps for a successful connection:
- Login to your Zapier account
- Login to Ticketsauce dashboard and at the top right of the screen go to My Account > API
- Write down the API keys noted, for your reference, as you will need the API keys to connect to Zapier.
- Follow the connection link and you should be able to enter the API keys and connect to Zapier successfully!
Zapier Common Terminology
Zap: A workflow item connecting one trigger in one system to one action in another.
- Example: When X happens, do Y.
- When an order happens, update/add it to my CRM.
Trigger: An action that happens in the first system. Triggers cause an action.
- Example: When an order is placed in TicketSauce, trigger the action of a new row being created in an excel sheet
Action: Something that happens in the second system, after a trigger happens in the
first system.
- Example: Update my CRM contact
Task: A completed Zap.
- Example: Executing an action after a trigger takes place.
Note: Pricing is based on the number of zaps and tasks you have in your account.
Examples
- Once an Order is created, update or create a new contact in ConstantContact
- Once an Order is created, add the order data to a new row in Google Sheets
- Once an Order is created, add data to my business dashboard on DataBox
Available Compatible Apps
Zapier has a list of apps that are compatible with their integration. To review available apps, you can click this link: https://zapier.com/apps
Once you find the app you are looking for, you can then find what the triggers & actions are.
Popular apps include:
- Google Sheets
- Gmail
- Slack
- Google Calendar
- Mailchimp
- Calendly
Zapier Triggers
We offer a number of triggers to provide ticketing data to any platform included in Zapier's extensive library of apps, such as Constant Contact, Salesforce, and more.
- New Order: Triggers each time a new order is created
- New Ticket: Triggers each time a new ticket is created (fires once per ticket on an order)
- New Check-In: Triggers each time a ticket is checked-in
- Event Created: Triggers each time a new event is created
- Event Published: Triggers each time an event is published
- FAQ
Sample Data Sets
New Order Trigger
Data available for each order (if collected/available):
id: 8ca65da7-d534-4a2e-80a3-54ea0ad1e040
event_id: 1234abcd-aa11-bb22-cc33-abcd1234
event_name: Example Event
event_date: 2019-01-01 16:00:00
first_name: Jane
last_name: Doe
dob: 1990-01-31
email: janedoe2131231@gmail.com
phone: (555) 123-4567
title: COO
company: Acme Co
address: 12345 Happy Ln.
address2: Apt. B
city: San Diego
state: CA
postal_code: 12345
country: US
opted_in: true
opted_in_sms: true
subtotal: 20.00
total_paid: 27.50
contributions: 25.00
promo_code: 10PERCENT
promo_code_amount: 2.00
promo_code_id: 1111aaaa-bb22-33cc-dd44-5555eeee6666
purchase_location: online
paid_date: 2019-04-05 15:22:00
paid_date_utc: 2019-04-05 20:22:00
affiliate_code: smiths123
ticket_count: 10
organization_name: Acme Events Management
organization_id: 5555zzzz-22aa-33cc-bda6-049176681234
order_type: credit
New Ticket Trigger
Data available for each ticket (if collected/available):
id: 6890abcd-ab12-1234-ef78-1234abcd
event_id: a3955433-f1c2-446a-bda6-049176687165
event_name: Example Event
event_date: 2019-01-01 16:00:00
order_id: 8765abcd-ab12-1234-ef78-1234abcd
ticket_type_id: 2345abcd-aa11-bb22-cc33-abcd2345
order_first_name: Jane
order_last_name: Doe
order_email: janedoe2131231@gmail.com
name: Jane Doe
email: janedoe2131231@gmail.com
phone: +1 (555) 123-4567
paid_price: 8.00
ticket_type_price: 10.00
seat_id: SectionA-C-16
ticket_type_name: General Admission: Adult
organization_name: Acme Events Management
organization_id: 5555zzzz-22aa-33cc-bda6-049176681234
New Check-In Trigger
Event Created
Data available each time a new event is created:
id: 605a3e1b-e6e4-41bc-bf38-53e84c2750bd
name: Example Event 123
active: false
location: The Whitehouse
address: 1600 Pennsylvania Avenue Northwest
address2: null
city: Washington
region: null
country: United States
postal_code: 20500
start: 2021-04-23 18:00:00
start_utc: 2021-04-24 04:00:00
end: 2021-04-23 20:00:00
end_utc: 2021-04-24 06:00:00
timezone: Pacific/Honolulu
attendee_limit: 0
is_dateless: false
created_utc: 2021-03-23 19:14:35
slug: example-event-123
tickets_active: true
website: null
summary: <p>This event is going to be awesome!</p>
status_change: created
Event Published
Data available each time a new event is published:
id: 605a3e1b-e6e4-41bc-bf38-53e84c2750bd
name: Example Event 123
active: false
location: The Whitehouse
address: 1600 Pennsylvania Avenue Northwest
address2: null
city: Washington
region: null
country: United States
postal_code: 20500
start: 2021-04-23 18:00:00
start_utc: 2021-04-24 04:00:00
end: 2021-04-23 20:00:00
end_utc: 2021-04-24 06:00:00
timezone: Pacific/Honolulu
attendee_limit: 0
is_dateless: false
created_utc: 2021-03-23 19:14:35
slug: example-event-123
tickets_active: true
website: null
summary: <p>This event is going to be awesome!</p>
status_change: published
FAQ
What is Zapier?
Zapier is a third party platform that connects multiple systems and APIs without the need of a developer. For more information, check out the Zapier website.
How do I get started?
Please contact your account representative. Our Zapier integration is currently private and we can walk you through how to get started.
Where can I see a full list of integrations Zapier supports?
More information and a full list of integrations can be found on the Zapier website.
I have a question about the data I can get from Zapier.
Please contact your account representative and they can give you more information on what data is included in each trigger.