Send New Orders to Google Sheets with Zapier

Tickit offers a seamless integration with Zapier, allowing you to create powerful automated workflows whenever an order is received. With Tickit's Zapier integration, you can easily send purchasing data to an external source like Google Sheets, letting you slice and dice your data any way you please.

This document will guide you through the process of setting up a Zap that connects Tickit with Google Sheets.

Step 1: Create a New Zap

• Log in to your Zapier account and click "Make a Zap" in the top navigation menu.
• In the Zap editor, search for and select "Tickit" as the trigger app.
• Choose the trigger event "New Order" and click "Continue."

Step 2: Connect Your Tickit Account

• If you haven't connected your Tickit account to Zapier before, click the "Connect an Account" button.
• A new window will open, prompting you to sign in using the same email and password you use for the Tickit dashboard
• Click "Yes, Continue" to authorize Zapier to access your Tickit account.

Step 3: Configure the Trigger

• After connecting your Tickit account, Zapier will fetch a sample order to test the trigger. Ensure that the sample order data matches your expectations.
• Optional: you can choose to only receive data from specific events by choosing one or more events when you configure the trigger
• Click "Continue" to proceed.

Step 4: Set Up the Action

In the "Choose an Action App" search bar, type "Google Sheets" and select it. Choose the action event "Create Spreadsheet Row" and click "Continue."

Step 5: Connect Google Sheets

• If you haven't connected your Google Sheets account, click the "Connect an Account" button.
• Follow the prompts to authorize Zapier's access to your Google Sheets account.

Step 6: Set Up the Google Sheets Action

• Select the Google Sheets spreadsheet and worksheet where you want to send the Tickit purchasing data.
• Map the fields from the Tickit order to the corresponding columns in Google Sheets. For example, map the "Contact Name" field to the "Name" column.
• You can also use the "Insert a Field" option to include dynamic data in your Google Sheets rows.
• Once you've configured the mapping, click "Continue" to proceed.

Step 7: Test and Enable the Zap

• Zapier will show a summary of your configured Zap. Review the details to ensure everything is set up correctly.
• Click "Test & Continue" to test the connection between Tickit and Google Sheets.
• Zapier will create a test row in your specified Google Sheets spreadsheet using the sample data from Tickit.
• If the test is successful, click "Turn on Zap" to activate the Zap.

Done!

Congratulations! You have successfully set up a Zap using Tickit's Zapier integration to send order data to Google Sheets. From now on, whenever a new order is received in Tickit, Zapier will automatically create a new row in your specified Google Sheets spreadsheet!

But wait, there's more!

Zapier has more than 2000 integrations that you can connect with Tickit to make your workflow automations easy and powerful.

If you encounter any issues or have questions, please refer to the Tickit support resources or reach out to our customer support team for assistance. Happy ticket selling!