You can now integrate your Access Tonic Ticketing system with Zapier. Zapier allows multiple software platforms to work together and connects to a number of Apps.
Google Sheets
The most popular App that clients link with Access Tonic Ticketing is Google Sheets. If you integrate these, Access Tonic automatically sends purchase information to a Google Sheet. This saves time compared to downloading the Access Tonic customer data file, as the Google Sheet stays up to date with the live data.
How does it work?
When a purchase is made, we prepare the data to send through Zapier. Zapier requests this data from us every 5 to 15 minutes and adds it to the Google Sheet.
How is the data shown?
The data displays on the Google Sheet as follows:
Each ticket in a purchase is stored in a single line on the Google Sheet.
Each product type in a purchase is stored in a single line on the Google Sheet.
What actions are sent?
When triggered, Access Tonic has a number of actions that send data to Zapier. The actions are:
Purchase complete: When a client completes a purchase at the checkout.
Purchase changed: When you or a client update a purchase; a change to the event date, ticket type or comments.
Purchase refunded: When you refund a purchase.
You can set up the integration for an individual event page, or event brand page.
Purchase complete data
Anyone can set up this trigger on their event by signing up for a free Zapier account.
Note: If you use the free Zapier account, the Google Sheet updates each time a purchase is completed in the Access Tonic checkout. The spreadsheet doesn't update if a purchase is refunded or changed.
Purchase refund and purchase changed data
To receive a purchase refund or purchase changed data, you need a Zapier account that allows Multi-step Zaps. The minimum plan you need is a Zapier Starter account.
The advantage of receiving Multi-step Zaps is that if a purchase is refunded or edited then the original purchase line on the Google Sheet updates with the new data. This means the Google Sheet acts as a live version of the customer data download and any change made to a purchase is automatically reflected on the sheet.
The data Access Tonic sends to Google Sheets
Below is a breakdown of the total information Access Tonic can send to Google Sheets. You can select what information you want to receive:
Purchase Properties | Item Properties | Refund Properties |
Purchase Reference | Admin Fee | Refund ID |
Customer Phone Number | Item Name - (ticket name) | Refund Status |
Line Total | Item Price | Quantity Remaining |
Event Date | Item Type (ticket) | Quantity Refunded |
Event ID | Item ID | Refunded Item Name - (refunded ticket name) |
Purchase Date | Quantity | Refunded Item ID |
Zapier Message ID | Quantity Refunded | Requested By |
Customer Email |
| Requested By ID |
Comments |
| Requested On |
|
| Refund Message |
|
| Total Amount Refunded |
Getting started
To proceed with integrating your event with Zapier, please follow the below steps:
Note: The integration is managed by Zapier, but we can send you a step-by-step guide on how to link the two.
Set up a Zapier account.
Create your event page and ensure the status is set to 'Public' as Zapier will not work if the event page is set to hidden.
Then let your Account Manager know, they activate the Zapier integration on your events and send you an invitation to link your Zapier account with Access Tonic Ticketing.
Set up the Google Sheets and Access Tonic Ticketing integration on Zapier.