Welcome to our guide on integrating TidyHQ and Google Sheets with Zapier, allowing you to automatically add ticket purchase information to a Google Sheet.

Choose TidyHQ as your Trigger and select the Event Ticket Pack Activated event. Connect your TidyHQ account if you haven't already.

Test the trigger step and continue with the latest record.

After setting your trigger, add an Action. Choose Google Sheets as your action app and select the Create Spreadsheet Row event. Connect your Google account if needed and choose the spreadsheet and worksheet where you want to add the ticket purchase information.

Let’s now choose the fields from TidyHQ to add to the Google Sheet.

Test the Google Sheets action step to ensure that rows are being added with the correct information. When you're ready, turn your Zap on, then whenever tickets are purchased, a spreadsheet row will be added to your Google Sheet.

Note: the EPOCHTODATE function in Google Sheets can convert the timestamp to a more user-friendly format as seen below.

We can refine the Zap by adding a Filter step. This step allows us to filter ticket purchases based on specific criteria, such as the event name. In the example below, only tickets which are purchased for the ‘Community Picnic’ event will be added to the Google Sheets. This logic can be extended to whatever you like, such as the ticket name or if the buyer is in a particular group.

If you are experiencing issues that none of our articles has helped you solve, please contact by clicking the button below:

If you'd like to know more, chat with us in the Messenger! 😊