{"id":1964105,"date":"2025-02-16T05:20:23","date_gmt":"2025-02-16T10:20:23","guid":{"rendered":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/?p=1964105"},"modified":"2025-02-16T05:20:24","modified_gmt":"2025-02-16T10:20:24","slug":"creating-a-zap-orders-to-google-sheets","status":"publish","type":"post","link":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/creating-a-zap-orders-to-google-sheets\/","title":{"rendered":"Creating a Zap (Orders to Google Sheets)"},"content":{"rendered":"\n

Event Automator allows you to use Zapier to integrate The Events Calendar and Event Tickets with your favorite third-party apps and tools. <\/p>\n\n\n\n

This is done by creating a “Zap” in Zapier. A zap is the simple “recipe” (instructions) that powers the automation of any of your workflows.<\/p>\n\n\n\n

Before reading further, make sure you have installed and configured Event Automator as explained here.<\/a><\/p>\n\n\n\n

Using Event Tickets as a Trigger<\/h2>\n\n\n\n

In this example, we’ll show you how to create a Zap that creates a new Google Sheets row when a new ticket order is added to your WordPress site.<\/p>\n\n\n\n

    \n
  1. In Zapier,<\/a> click on the Zaps on the left side panel, then the + Create button.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
      \n
    1. Select Event Tickets<\/strong> as the trigger.<\/li>\n<\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
        \n
      1. Choose New Order<\/strong> as the Trigger event.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
          \n
        1. Choose your account, wait until it loads, and click on Continue<\/em>.<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
            \n
          1. You can now begin testing the trigger from Zapier. Once the testing completed, it will show one or more test records. — Make sure you’re working on the most recent record.<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            Important: <\/strong>Testing your trigger is a crucial step! <\/p>\n\n\n\n

            Successfully testing the trigger allows Zapier to \u201csee\u201d all the order fields available on your site.
            In other words, if Zapier can\u2019t see the fields on your site, your Zaps will not work.<\/p>\n\n\n\n

            The order record selected from the trigger test should display a list of fields that can be mapped along with their values.<\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            Caution: <\/strong>Don’t be fooled by the fact that Zapier has found an order!
            Look carefully at the screen. If you are not seeing a list of fields or if the fields do not contain values, that record cannot be used to test the trigger.<\/p>\n\n\n\n

            To fix that, you can:<\/p>\n\n\n\n