Export Attendees to Google Sheets Through Zapier
If you want your attendees to appear in a spreadsheet like Google Sheets, you can have them automatically appear in the spreadsheet when new registrations come in 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.
Spread Sheet Headers
Before setting up your zap, ensure that you already have a spread sheet and it has headers for the information that you want to export from Accelevents. In this example below, we want to extract the Order Number, Ticket Number, Name, Email, Job Title and Organization from the Accelevents Order.
Create the Zap
Click the arrows to see the next steps to set up the trigger and action.
Part 1 Trigger - New Ticket Purchase
Part 1 Trigger - New Ticket Purchase
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 Accelevents as the Trigger
Create a new zap, click the trigger, then search and choose the latest version of Accelevents. You will only see this version if you accept the invite in the previous step.
3. Select New Ticket Purchase Trigger
Select New Ticket Purchase Trigger in the trigger event choices.
4. 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.
5. Test the Trigger
Click Test Trigger so Zapier can check for a successful connection between the two platforms. Select which Accelevents record to test.
Important: Before testing, check the fields in the record you selected. It should include all the fields that you want to export (e.g., name, email, custom fields). If the fields are incomplete, add values in the Accelevents order and click "Find new records" in the zap to fetch the latest updated record.
Part 2 Action - Create Multiple Spreadsheet Rows
Part 2 Action - Create Multiple Spreadsheet Rows
1. Select Google Sheets for Action
Search and choose Google Sheets in the pop-up.
2. Select Create Multiple Spreadsheet Rows
Select Create Multiple Spreadsheet Rows in the action event choices.
3. Connect Your Google Account
If you've previously used Google Sheets for your Zaps, you can select the account from the dropdown or click + Connect a new account. Once selected, click Continue.
4. Choose the Spreadsheet and Worksheet fields
Select which spreadsheet and worksheet to update, then click Continue.
5. Map the Fields
After selecting the spreadsheet and worksheet, the labels in your worksheet will appear in the configure menu. Click the + button on each label, then map the data from Accelevents. Click Continue when you're done.
7. Test the Zap
Click Test Step, then check your sheet if the attendee information has been added.
8 Publish the Zap
If the test is successful, publish the zap. Any new registrations will now be added to your sheet.
