Import Registrations from Google Sheets to Accelevents
If you're using a worksheet like Google Sheets to manage your event registrations, you can have those registrations automatically appear in Accelevents by creating a Zap!
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.
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 action.
Part 1 Trigger
Part 1 Trigger
1. Accept the Accelevents' Invite
To ensure that you're using the correct app version, accept the Accelevents invite to build a Zap.
2. Choose Google Sheets as the Trigger
After creating the zap, click the trigger and select Google Sheets from the available apps.
3. Choose the Trigger Event
Select New or Updated Spreadsheet Row as the trigger event. When a Google Sheet row is updated or created, an order in Accelevents will be created.
4. 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.
5. 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
Part 2 Action
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 Import Ticket Holder/Buyer
Select Import Ticket Holder/Buyer in the action event choices.
3. Connect Your Accelevents Event to Zapier
Click Sign In, and 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. Select the Ticket Type
If you're assigning the same type of ticket to all registrants, select the Ticket Type from the static values.
If attendees will be assigned a ticket type depending on what they choose, you can add a Ticket Type ID column in Google Sheets, and the value should be the corresponding ticket type ID for the ticket type. In the example above, the ticket type ID for the Paid Ticket is 220637.
The ticket type ID determines which ticket will be assigned to the attendee (not the ticket name) and this should be present in the sheet. When you map it, click the 3 dots, select Custom, and choose the Ticket Type ID field with the value.
To get the Ticket Type ID in Accelevents:
Go to Settings > Integrations in your Accelevents admin console
Enable Tray Integration Platform
Click Configure
Select the ticket type from the dropdown and copy the ID number in the field below.
Copy all the ticket type IDs and list which ID is for which ticket.
Click Save.
5. Map the Other Fields
The name and email are required fields. For the other fields to show in the mapping, you need to enable them in the Ticket Buyer fields in Accelevents. Click Continue when you're done.
6. Test the Zap
Click Continue, then test the step to see if it will fetch the data from Google Sheets and add the attendee in Accelevents. Check your event if an order was created for the test.
6. Turn on the Zap
If the test was successful, you could now activate the Zap. Click Publish. When a row is updated or created in the sheet, a new order will be created in Accelevents.
