Update the Ticket Holder Information from Google Sheets to Accelevents Through Zapier
If you need to update the attendee information bulk or update other attendee information but you want to bypass some required fields, you can add the information into a spreadsheet like Google Sheets, then you can create a zap that will automatically update the order information in Accelevents when the spreadsheet is updated.
Accelevents has an official app published in Zapier for integrating with other platforms. The steps below will show you how to connect your Accelevents account to Zapier and then build your integration between your event and the other apps available in Zapier, such as Airtable.
A Zap is like your personal assistant following all your instructions to complete the task. It has two essential components: a trigger and an action. The trigger is an event or condition as to when the action will happen. The action is the command that will complete your goal.
Your zap would look like this:
Accept the Invite to Create a Zap
Accepting the invite will allow you to use the most up-to-date version of our Accelevents app. Click Accept & Build a Zap.
Create the Zap
Click the arrows to see the next steps to set up the trigger and actions.
Part 1 Trigger - New or Updated Spreadsheet Row
Part 1 Trigger - New or Updated Spreadsheet Row
1. Download the Ticket Holder Data from Accelevents
To make your zap work, your Google Sheets spreadsheet needs to have the column for the attendees' ticket number. This will allow the zap to update the correct ticket holder since the ticket number is unique. To get the ticket number of all attendees, download the Ticket Holder Data from Accelevents. Copy the Ticket Number column to your sheet and the other information you may need (e.g., name, email, column labels)
2. Accept the Accelevents' Invite
To ensure that you're using the correct app version, accept the Accelevents invite to build a Zap.
3. Choose Google Sheets as the Trigger
After creating the zap, click the trigger and select Google Sheets from the available apps.
4. Choose the Trigger Event
Select New or Updated Spreadsheet Row as the trigger event. When a Google Sheet row is updated or created, the attendee information in Accelevents will be updated.
5. Connect your Google Account
If you have used Google Sheets for your zaps before, select an account from the dropdown. You can also add a new one by clicking +Connect a new account. Once selected, click Continue.
6. Choose the Spreadsheet and Worksheet fields
Choose the spreadsheet and worksheet fields from the dropdowns, then click Continue.
7. Test the Trigger
Click Test Trigger so Zapier can check for a successful connection between the two platforms. Select which Google Sheets spreadsheet row to test.
Part 2 Action - Update Ticket Information
Part 2 Action - Update Ticket Information
1. Select Accelevents for Action
Search and choose the latest version of Accelevents. You will only see this version if you accept the invite in the previous step.
2. Select Update Ticket Information
Select Update Ticket Information in the action event dropdown.
3. Connect Your Accelevents Event to Zapier
Click Select and choose +Connect a new account, then a pop-up will appear where you can enter the API Key.
To get your Zapier API Key, open your event admin console in Accelevents
Go to Settings > Integrations
Enable the toggle for Zapier Integration
Click on Configure, then copy the generated API key.
Paste the API Key to the Zapier pop-up, then click Yes, Continue to Accelevents. Then click Continue in the Zapier settings.
4. Configure the Fields
Map all the fields that you want to update in Accelevents.
The required fields are for Ticket Holder and the Ticket ID (ticket number).
The fields will only show in the mapping if they are also enabled in Accelevents.
Note: We are still improving the feature to update the Ticket Buyer information, currently we can only update the ticket holder information. Stay tuned for updates.
5. Test the Step
Click Continue, then test the step to see if it will update information in Accelevents.
6. Publish the Zap
If the test is successful, publish the zap. After publishing, data will be pushed to Accelevents whenever a row with the the ticket number is updated or created.
