Zapier integration: Add a new row to a Google Sheet when a new ticket is created

Zapier lets you automatically collect all of your ticket data in a Google Sheet —with no code required. Follow the directions below to create an automation workflow that adds a new row to a Google Sheet every time a new ticket is created in your account.

For an introduction to Zapier integrations, see this article: 

Create integrations with Zapier.

Every Zap has two parts:

  • A Trigger
  • An Action

Create a trigger event

1. Log in to your Zapier account and select + Create Zap in the upper left (sidebar menu)

2. Search for and select as your Trigger event app. 

3. Under Event, select New Ticket

Then, click the Continue button.

4. Select a account. If you have not yet connected your account, you’ll be prompted to add one and log in to

Click the Continue button.

5. Select the property for which you would like to watch new tickets.

Then, click the Continue button.

6. Click the Test Trigger button to confirm that the right account is connected and your trigger is set up correctly.

Then, click the Continue button.

Create an Action event

1. Next, search for and select Google Sheets as the Action event app.

2. Under Choose an event, select Select Spreadsheet Row in the drop-down menu.

Then click the Continue button.

3. Click the Choose button to select or add a Google account to your workflow. Then, click the Continue button.

4. Under Action, select the Google Drive where you will store your ticketing data. Then, select a spreadsheet to receive the data and the Worksheet where the data will appear.

Set up a new Google Sheet with the following columns:

  • Name
  • Time
  • Message

In the remaining Action fields, map the data values from the ticket to the Google Sheets column labels:

  • Requester name > Name
  • Time > Time
  • Ticket Message>Message

Click the Continue button.

5. Click the Test action button to populate a row in the Google Sheet with data from a recent ticket.

Check the results in your Sheet.

6. Finally, click the pencil icon in the upper-right corner and give your Zap a name.

Hit the Publish Zap button.

7. To activate your new Zap, click the Publish & Turn On button.

Congratulations! You’re now collecting all your ticketing information in Google.

Looking for more Zaps? Check out the list on Zapier’s Integration page.

If you have questions or need assistance, reach out to our support team or schedule a call.

Was this article helpful?

14 out of 20 liked this article

Still need help? Message Us