Skip to main content

How to send custom questions from a checkout form to Google Sheets

You can use Zapier to automatically collect responses from custom questions into a Google spreadsheet, to help your Event Operations.

Written by Rhio

Zapier 'Zaps' are workflows that connect Ticket Tailor to other apps. They consist of a trigger, which is an event that starts a Zap, and one or more actions, which are events the Zap performs.

In this help article, we'll show you an example of how you can use Zapier to automatically collect responses from custom questions into a Google spreadsheet, for example, if you want to note down dietary requirements at a food and drinks event. This workflow contains multiple actions, called a chain.


Before you get started

How to send custom questions from a checkout form to Google Sheets

  • Click on 'Create Zap'.

  • In the 'Trigger' section, search for and select 'Ticket Tailor'.

  • For the 'Trigger Event', choose 'Order created'.

  • Select your Ticket Tailor account (or connect if you haven't already).

  • Click 'Test Trigger' to ensure Zapier pulls in sample data.

  • In the 'Action' section, search for and select 'Google Sheets'.

  • For the 'Action Event', choose 'Create Spreadsheet Row'.

  • Connect your Google account, and click 'Continue'.

  • On the Configure tab, select the spreadsheet and worksheet where you'd like to log the data.

    • If you don't have one, create a new Google Sheet, and add headers to your columns to align with your order data.

  • In the setup fields, map the data from Ticket Tailor to the corresponding columns in your spreadsheet.

  • Click 'Test Action' to send sample data to your Google Sheet.

  • Navigate back to Ticket Tailor and create a test order to ensure the Zap is working. You can void this order later.

  • Open your Google Sheet to verify that a new row has been added with the correct information.

  • If everything looks good, click 'Publish' to activate the Zap.

Did this answer your question?