Connect Accelevents to Other Apps Using Zapier

If you want all attendees to appear in a Google Sheet, follow the steps below for your Zap.

Select Google Sheets from the pop-up.

In the list of events and actions, choose between these 2 if you want to create rows in Google Sheet, then click Continue:

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.

Choose your Google Sheet file under Spreadsheet, then choose which tab in that spreadsheet you want to use in Worksheet. Ensure you have the proper headings in the sheet, as those will populate in your action settings.

After selecting your sheet, scroll down to see the fields you can map. In this example, the sheet has these column headings:

In the action settings, all those headings also appeared. The next step is to choose what information will be placed under each column. Search for the Accelevents fields from the dropdown for each item on your sheet.

Click Continue after mapping all the information.

Click Test Step to see if the Zap works. The example below shows 2 tickets and 2 add-ons in 1 order. All items are exported to Google Sheets, 1 item per row.

If the test was successful, you can activate the Zap by clicking Publish. Any new registrations will be added to your Google Sheet after publishing.

In the trigger above, we selected the New Ticket Purchase Trigger, so the steps below will alert you in Slack if there are new registrations. If you want to get a notification for newly checked-in attendees, just change the trigger above to User Check-In and follow the steps below for the action.

Select Slack from the pop-up.

Each app will have its own list of events and actions, depending on its function. In the example below, we chose to Send Private Channel Message in Slack when someone registers for the event. If you want to send the message directly to a Slack user, choose Send Direct Message in the action and click Continue.

Sign in to Slack to authorize Zapier to send information to it, then click Continue.

Choose the Slack channel where you want the message to appear, then select the content. When you're done, click Continue at the bottom.

In the example below, we include the following:

If you are setting up an alert for yourself when attendees check in, choose your username, and enter the message and other content to include in the message like the below example.

Click Test step to see if your zap works.

In this example, our Zap worked with Slack and got a new message sent through the private channel. It included the bot image we added, the attendee name, email, and the custom message.

If the test was successful, you can activate the Zap by clicking Publish. You will be alerted in Slack whenever there is a new registration.

After creating your Accelevents trigger (steps 1 to 4 from Trigger), click the + button to add an action.

1. Search and select Looping By Zapier from the pop-up.

2. Choose Create Loop from Line Items for the Event, then click Continue.

3. Under Line items, label each value you want to loop, then select the applicable data for each field.

4. Add your intended value to the rest of the fields, then click Continue.

5. Click Test step to test your loop.

6. Under preview_loop_values, information on multiple ticket holders will appear. Click Publish.

7. Click the + button to add a next step. In this step, we'll choose where to export the information. For this example, we choose Google Sheets

8. After selecting Google Sheets, the Event is to Create Multiple Spreadsheet Rows. Make sure to have a Google Sheet file with headers matching the label for each loop value in Step 3.

9. Sign in to Google Sheets, then select Drive with the file to export attendees, select the spreadsheet, and select the worksheet.

10. Select the appropriate value for each row. Select the value with Preview Loop Values at the beginning, then select Continue.

11. Test the step. The information on the ticket holders will appear on your spreadsheet.

12. Publish your zap and ensure it's been turned on. After publishing all registrations should be exported to Google Sheets.

Create a new Zap, click Trigger, then search and select Google Sheets from the pop-up.

Choose New Spreadsheet Row under Event, then click Continue. This means that whenever new data is added to a row in your sheet, it will be carried over to Accelevents.

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.

Choose your Google Sheet file under Spreadsheet, then choose which tab in that spreadsheet you want to use in Worksheet, then click Continue. Ensure you have the proper headings in the sheet, as those will populate in your action settings, and add a sample data to be imported.

Click Test Trigger so Zapier can check for a successful connection between the two platforms.

Select a transaction to test. Then click Continue with selected record. If the test is successful, it will move on to the next step, creating an Action. Click here to see the steps for creating an Action.

If you want registrants through a Google Form to automatically get Accelevents tickets, follow the steps below on how to set up the trigger for a Google Form.

Create a new Zap, click Trigger, then search and select Google Forms from the pop-up.

Select New Form Response from the Event dropdown, then click Continue. Each time a response is submitted, Zapier will relay the information to Accelevents to give a ticket to the person who submitted the form.

If you've previously used Google Forms for your Zaps, you can select the account from the dropdown or click + Connect a new account. Once selected, click Continue.

Choose your Google Form file under Form, then click Continue.

Click Test Trigger so Zapier can check for a successful connection between the two platforms.

Select a transaction to test. Then click Continue with selected record. If the test is successful, it will move on to the next step, creating an Action. Click here to see the steps for creating an Action.