{"id":1961131,"date":"2024-07-23T10:05:17","date_gmt":"2024-07-23T14:05:17","guid":{"rendered":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/?p=1961131"},"modified":"2024-08-30T09:47:50","modified_gmt":"2024-08-30T13:47:50","slug":"creating-a-zap-legacy","status":"publish","type":"post","link":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/creating-a-zap-legacy\/","title":{"rendered":"Creating a Zap"},"content":{"rendered":"\n<p>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<p>This is done by creating a &#8220;Zap&#8221; in Zapier. A zap is the simple &#8220;recipe&#8221; (instructions) that powers the automation of any of your workflows.<\/p>\n\n\n\n<p>Before reading further, make sure you have installed and configured Event Automator as <a href=\"https:\/\/staging.theeventscalendar.com\/knowledgebase\/k\/new-user-primer-event-automator\/\" target=\"_blank\" rel=\"noreferrer noopener\">explained here.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-using-the-events-calendar-as-a-trigger\">Using The Events Calendar as a Trigger<\/h2>\n\n\n\n<p>In this example, we&#8217;ll show you how to create a Zap that creates a new Google Sheets row when a new event is added to The Events Calendar on your WordPress site. Please note that the same principles apply to creating a Zap for Event Tickets.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In <a href=\"https:\/\/zapier.com\/app\/login\" target=\"_blank\" rel=\"noreferrer noopener\">Zapier,<\/a> click on the Zaps on the left side panel, then the + Create button.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1874\" height=\"530\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap1v1.png\" alt=\"\" class=\"wp-image-1962723\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap1v1.png 1874w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap1v1-300x85.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap1v1-1024x290.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap1v1-768x217.png 768w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap1v1-1536x434.png 1536w\" sizes=\"auto, (max-width: 1874px) 100vw, 1874px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Select <strong>The Events Calendar<\/strong> as a trigger.<br><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"556\" class=\"wp-image-1962724\" style=\"width: 900px;\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap2.png\" alt=\"\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap2.png 1180w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap2-300x185.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap2-1024x633.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap2-768x474.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/li>\n<\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Choose <strong>New Event<\/strong> and click on <em>Continue<\/em>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"978\" height=\"594\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap3.png\" alt=\"\" class=\"wp-image-1962725\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap3.png 978w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap3-300x182.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap3-768x466.png 768w\" sizes=\"auto, (max-width: 978px) 100vw, 978px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Choose your account, wait until it loads, and click on <em>Continue<\/em>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"965\" height=\"694\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap4.png\" alt=\"\" class=\"wp-image-1962726\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap4.png 965w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap4-300x216.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap4-768x552.png 768w\" sizes=\"auto, (max-width: 965px) 100vw, 965px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\">\n<li>You can now begin testing the trigger from Zapier. Once the testing completed, it will show one or more test records.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1091\" height=\"851\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap25.png\" alt=\"\" class=\"wp-image-1962746\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap25.png 1091w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap25-300x234.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap25-1024x799.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap25-768x599.png 768w\" sizes=\"auto, (max-width: 1091px) 100vw, 1091px\" \/><\/figure>\n\n\n\n<p id=\"important\"><strong>Important: <\/strong>Testing your trigger is a crucial step! <\/p>\n\n\n\n<p id=\"important\">Successfully testing the trigger allows Zapier to \u201csee\u201d all the event fields available on your site.<br>In other words, if Zapier can\u2019t see the fields on your site, your Zaps will not work.<\/p>\n\n\n\n<p>The event selected to test the trigger should display a list of mappable fields found in your events when selected.<\/p>\n\n\n\n<p><strong>Caution: <\/strong>Don&#8217;t be fooled by the fact that Zapier has found an event!<br>Look carefully at the screen. If you are not seeing a list of fields or if the event id displays as <em>no-new-events<\/em>, that event cannot be used to test the trigger.<\/p>\n\n\n\n<p>To fix that, you can:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select another event (if any)<\/li>\n\n\n\n<li>Create a new event on your site \n<ul class=\"wp-block-list\">\n<li>Refresh the page where you are testing the trigger on zapier.com<\/li>\n\n\n\n<li>The freshly created event should appear<\/li>\n\n\n\n<li>Select it and look for those mappable event fields<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">Summary<\/h4>\n\n\n\n<p>Selecting an event that lets you see all the mappable fields is necessary for Zapier to &#8220;know&#8221; what it&#8217;s working with. Real event data acts as an available data template for Zapier.<\/p>\n\n\n\n<p><strong>Pro tip:<\/strong> the same concept applies to Event Tickets triggers (attendees, tickets, ticket orders). You need to feed Zapier real data so that it connects the dots.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\">\n<li>Select the action you&#8217;d like to create (in this case, it&#8217;s Google Sheets).<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1142\" height=\"791\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap6.png\" alt=\"\" class=\"wp-image-1962728\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap6.png 1142w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap6-300x208.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap6-1024x709.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap6-768x532.png 768w\" sizes=\"auto, (max-width: 1142px) 100vw, 1142px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"7\">\n<li>Choose <em>Create Spreadsheet Row<\/em> as an event.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"680\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap7.png\" alt=\"\" class=\"wp-image-1962729\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap7.png 941w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap7-300x217.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap7-768x555.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"8\">\n<li>Select your <strong>Google Sheets account<\/strong> or Sign in and allow access if necessary.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1012\" height=\"664\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap8.png\" alt=\"\" class=\"wp-image-1962730\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap8.png 1012w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap8-300x197.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap8-768x504.png 768w\" sizes=\"auto, (max-width: 1012px) 100vw, 1012px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1767\" height=\"802\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap9.png\" alt=\"\" class=\"wp-image-1962731\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap9.png 1767w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap9-300x136.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap9-1024x465.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap9-768x349.png 768w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap9-1536x697.png 1536w\" sizes=\"auto, (max-width: 1767px) 100vw, 1767px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"9\">\n<li>Set the desired <strong>Drive<\/strong>, <strong>Spreadsheet<\/strong>, and <strong>Worksheet<\/strong>, and click on <em>Continue<\/em>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1416\" height=\"885\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap101.png\" alt=\"\" class=\"wp-image-1962732\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap101.png 1416w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap101-300x188.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap101-1024x640.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap101-768x480.png 768w\" sizes=\"auto, (max-width: 1416px) 100vw, 1416px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"10\">\n<li>Map each desired field to its destination column in the spreadsheet.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1118\" height=\"447\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap11.png\" alt=\"\" class=\"wp-image-1962733\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap11.png 1118w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap11-300x120.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap11-1024x409.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap11-768x307.png 768w\" sizes=\"auto, (max-width: 1118px) 100vw, 1118px\" \/><\/figure>\n\n\n\n<p><strong>Important:<\/strong>&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Make sure you have created headers for each of the desired fields in the destination spreadsheet (i.e.: row A should read &#8211; ID, Title, Start Date, etc.)<\/li>\n\n\n\n<li>Make sure you previously selected a valid event while testing the trigger in <a href=\"#important\" rel=\"nofollow\">step 6<\/a> to be able to map fields.<\/li>\n<\/ol>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"337\" class=\"wp-image-1962734\" style=\"width: 700px;\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap11.1.png\" alt=\"\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap11.1.png 1069w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap11.1-300x145.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap11.1-1024x493.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap11.1-768x370.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"11\">\n<li>Click on <em>Continue<\/em>.<\/li>\n<\/ol>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"444\" class=\"wp-image-1962735\" style=\"width: 700px;\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap12.png\" alt=\"\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap12.png 645w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzap12-300x190.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"12\">\n<li>Next, you&#8217;ll want to test your Zap.<\/li>\n<\/ol>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"429\" class=\"wp-image-1962738\" style=\"width: 700px;\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/Kbzap15.png\" alt=\"\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/Kbzap15.png 870w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/Kbzap15-300x184.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/Kbzap15-768x471.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n\n\n\n<p>If it was successfully created, your screen should look like this:<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"564\" class=\"wp-image-1962739\" style=\"width: 700px;\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/Kbzap16.png\" alt=\"\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/Kbzap16.png 883w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/Kbzap16-300x242.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/Kbzap16-768x618.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"418\" class=\"wp-image-1962740\" style=\"width: 700px;\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzaap17.png\" alt=\"\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzaap17.png 1033w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzaap17-300x179.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzaap17-1024x612.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/07\/kbzaap17-768x459.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n\n\n\n<p>Now you&#8217;re ready to publish your Zap.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Test your Zap (The Events Calendar as a Trigger)<\/h4>\n\n\n\n<p>Now you&#8217;re ready to test out your Zap. To do this:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to your WordPress admin area and create a new event.<\/li>\n\n\n\n<li>Wait at least 15 minutes (if you have a free account).<\/li>\n\n\n\n<li>Check the selected Google Sheets spreadsheet and worksheet.<\/li>\n\n\n\n<li>Refresh the page.<\/li>\n<\/ol>\n\n\n\n<p>A new row containing the data of the new event should appear.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using The Events Calendar as an Action<\/h2>\n\n\n\n<p>In this example, we&#8217;ll show you how to create a Zap that creates a new event in The Events Calendar on your WordPress site when a new Google Sheets row is created.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"1\">\n<li>In <a href=\"https:\/\/zapier.com\/app\/login\" target=\"_blank\" rel=\"noreferrer noopener\">Zapier,<\/a> click on the <em>+ Create Zap<\/em> button<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1900\" height=\"681\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap20.png\" alt=\"\" class=\"wp-image-1962741\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap20.png 1900w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap20-300x108.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap20-1024x367.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap20-768x275.png 768w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap20-1536x551.png 1536w\" sizes=\"auto, (max-width: 1900px) 100vw, 1900px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Select <strong>Google Sheets<\/strong> as a trigger<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1472\" height=\"842\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap21.png\" alt=\"\" class=\"wp-image-1962742\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap21.png 1472w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap21-300x172.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap21-1024x586.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap21-768x439.png 768w\" sizes=\"auto, (max-width: 1472px) 100vw, 1472px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Choose <strong>New Spreadsheet Row<\/strong> as an event, and click on <em>Continue<\/em><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1304\" height=\"613\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap22.png\" alt=\"\" class=\"wp-image-1962743\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap22.png 1304w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap22-300x141.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap22-1024x481.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap22-768x361.png 768w\" sizes=\"auto, (max-width: 1304px) 100vw, 1304px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1339\" height=\"668\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap23.png\" alt=\"\" class=\"wp-image-1962744\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap23.png 1339w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap23-300x150.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap23-1024x511.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap23-768x383.png 768w\" sizes=\"auto, (max-width: 1339px) 100vw, 1339px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>Set the desired <strong>Drive<\/strong>, <strong>Spreadsheet<\/strong>, and <strong>Worksheet<\/strong>, and click on <em>Continue<\/em>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1308\" height=\"823\" src=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap24.png\" alt=\"\" class=\"wp-image-1962745\" srcset=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap24.png 1308w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap24-300x189.png 300w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap24-1024x644.png 1024w, https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/08\/kbzap24-768x483.png 768w\" sizes=\"auto, (max-width: 1308px) 100vw, 1308px\" \/><\/figure>\n\n\n\n<p><strong>Important:<\/strong> the selected spreadsheet must have <a href=\"https:\/\/help.zapier.com\/hc\/en-us\/articles\/8496276985101#make-sure-the-first-row-is-a-header-row-with-column-names-0-0\" target=\"_blank\" rel=\"noreferrer noopener\">column headers<\/a> for this to work.<\/p>\n\n\n\n<p>Column headers are labels placed in the first row of your spreadsheet that describe the data contained in each column. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Event Automator allows you to use Zapier to integrate The Events Calendar and Event Tickets with your favorite third-party apps and tools. This is done by creating a &#8220;Zap&#8221; in Zapier. A zap is the simple &#8220;recipe&#8221; (instructions) that powers the automation of any of your workflows. Before reading further, make sure you have installed&#8230;<\/p>\n","protected":false},"author":77,"featured_media":1955565,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_swpsp_post_exclude":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"ep_exclude_from_search":true,"footnotes":""},"categories":[40,41,46],"tags":[47],"stellar-product-taxonomy":[182],"class_list":["post-1961131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-support-resources","category-getting-started","category-integrations","tag-integrations","stellar-product-taxonomy-event-automator"],"acf":[],"taxonomy_info":{"category":[{"value":40,"label":"Get Help"},{"value":41,"label":"Getting Started"},{"value":46,"label":"Integrations"}],"post_tag":[{"value":47,"label":"Integrations"}],"stellar-product-taxonomy":[{"value":182,"label":"Event Automator"}]},"featured_image_src_large":["https:\/\/images.theeventscalendar.com\/kb\/uploads\/2023\/02\/social-share-1024x538.png",1024,538,true],"author_info":{"display_name":"TEC Staff","author_link":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/author\/tec_staff\/"},"comment_info":0,"category_info":[{"term_id":40,"name":"Get Help","slug":"support-resources","term_group":0,"term_taxonomy_id":40,"taxonomy":"category","description":"","parent":0,"count":28,"filter":"raw","term_order":"0","cat_ID":40,"category_count":28,"category_description":"","cat_name":"Get Help","category_nicename":"support-resources","category_parent":0},{"term_id":41,"name":"Getting Started","slug":"getting-started","term_group":0,"term_taxonomy_id":41,"taxonomy":"category","description":"","parent":0,"count":67,"filter":"raw","term_order":"0","cat_ID":41,"category_count":67,"category_description":"","cat_name":"Getting Started","category_nicename":"getting-started","category_parent":0},{"term_id":46,"name":"Integrations","slug":"integrations","term_group":0,"term_taxonomy_id":46,"taxonomy":"category","description":"","parent":0,"count":115,"filter":"raw","term_order":"0","cat_ID":46,"category_count":115,"category_description":"","cat_name":"Integrations","category_nicename":"integrations","category_parent":0}],"tag_info":[{"term_id":47,"name":"Integrations","slug":"integrations","term_group":0,"term_taxonomy_id":47,"taxonomy":"post_tag","description":"","parent":0,"count":23,"filter":"raw","term_order":"0"}],"_links":{"self":[{"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/1961131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=1961131"}],"version-history":[{"count":6,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/1961131\/revisions"}],"predecessor-version":[{"id":1962747,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/1961131\/revisions\/1962747"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/media\/1955565"}],"wp:attachment":[{"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=1961131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=1961131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=1961131"},{"taxonomy":"stellar-product-taxonomy","embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/stellar-product-taxonomy?post=1961131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}