document.addEventListener("DOMContentLoaded", function () { const url = window.location.href; $('section[class^="text"] a').each(function() { if($(this).attr('href').includes(url + '#')) { $(this).attr('target', '_self'); } }); });

How to Import Eventbrite Events to Airtable with 5 Easy Methods

Mariam Ispiryan • June 21, 2022 • 9 min read

Your most recent Eventbrite event is coming up soon and you are scrambling to plan it. You want to gather all the possible data from previous events and also conduct competitor research to showcase the high chances of your event being a success. For this, you’ll need a platform that focuses on managing and storing data, which also has the ability to sync with Eventbrite.


The tool you’re looking for is Airtable. The tool provides a way for companies to start and operate project workflows, store and manage data, and much more.


Today, we will demonstrate 5 quick ways to set up the syncing process of Airtable and Eventbrite to save you hours of work.

Let’s go!



Table of Contents


  1. Import Eventbrite events data as a CSV file
  2. Import Eventbrite events data with CSV Import app
  3. Import Eventbrite events data to Airtable with Data Fetcher and SimpleScraper
  4. Import Eventbrite data to Airtable with Zapier
  5. Import Eventbrite events data to Airtable with Make


One of the best things about Airtable is its flexibility.

Connect your Airtable database to Softr and build beautiful no-code web apps in minutes.

Importing Eventbrite events data as a CSV file


If you don’t want to become a premium user to access the CSV import app and are looking for something less customizable, importing the CSV file can be possible with the following instructions.


Step 1: Export Eventbrite Events data as a CVS file,

Eventbrite has a separate section where you can go through all the data connected with your event.


We chose to export the “Attendee Summary” report, here’s how:

Now, let’s get back to importing the CSV file to Airtable

Step 2: Open the view where you want to import your file.

Step 3: Click “Add or Import” next to the list of tables.

Step 4: Click the “CSV file”.

Step 5: Select the CSV file to import. (Note, the file size limit on CSV uploads is 5MB)


The imported adjustment dialog will pop up, where you can preview your CSV file, and adjust field mappings before importing.


After you’re done with changes, click the “Import” and you have your Eventbrite events data successfully imported to Airtable.

One of the best things about Airtable is its flexibility.

Connect your Airtable database to Softr and build beautiful no-code web apps in minutes.

Import Eventbrite events data with CSV Import app


CSV import app is an Airtable app available for premium users and has a 25,000-row limit. The CSV import app allows you to customize and edit the imported records and merge data with existing ones.


To work with the CSV import app, open the base where you want to import your Eventbrite events and follow the instructions:


Step 1: Install the CSV import app by clicking the "Apps" button at the top right corner of your view.

Step 2: Click the "Install an app" button.

Step 3: Find and install the CSV import app.

Step 4: Import the Eventbrite CSV file into the app.

Step 5: Configure settings and field mappings before importing the CSV file into your base.

These were the default steps required for importing Eventbrite events data to Airtable. The next steps are optional but important if you want to import your data without difficulties.



Additional steps


Step 6: If your table has existing records, enable the “Merge with existing records”.

merge with exisitng reocrds

Step 7: Toggle on “Skip blank or invalid CSV values", if there are blank fields in the CSV.

skip blank or invalid csv values

Step 8: Enable “Create missing select options” to create a new option in case there are single/multiple-select fields in your table.

missing select records

Step 9: Set field mappings to match Airtable rows with your CSV file.


To successfully set field mappings, select the field toggle, choose a column from the drop-down menu, and map the value.

map a value

One of the best things about Airtable is its flexibility.

Connect your Airtable database to Softr and build beautiful no-code web apps in minutes.

Import Eventbrite events data to Airtable with Data Fetcher and SimpleScraper


Data Fetcher is another option Airtable offers to sync many platforms with Airtable for its users with the “Plus” or higher plan. But, at the moment, Data Fetcher alone won’t help you with importing Eventbrite Events to Airtable. That’s where Simplescraper comes to the rescue. Simplescraper is a Chrome extension, designed to be the most simple and powerful web scraper you've ever used in no code.


The method will be handy if you need to gather data on different events. (More on this later)



With Simplescraper, we will scrape all the required data from Eventbrite to then import the data to Airtable with Data Fetcher.


Let’s get it started!



Scrape Eventbrite events data with Simplescraper


To scrape data from Eventbrite follow the instructions below:

Step 1: Go to the Chrome app store and download the Simplescraper extension.

simplescraper chrome extension

Step 2: Go to the Eventbrite Events page you want to scrape. We want to scrape data on Eventbrite online events page.


Step 3: From the Google Chrome extension menu at the top right corner of the page, track Simplescraper and click on the icon and choose “Scrape the website”.

scrape this website

Step 4: At the top of the page a new bar will appear, where you should click on “Add a property”.

add a property

Step 5: Add and name properties to proceed. Each property presents a different type of data you want to scrape


Step 6: Select the item you want to scrape, by clicking on the screen where the element is located.

Simplescraper allows scraping URLs, image URLs, names, and dates.


Step 7: Change the CSS selector, at the button of the bar for the tool to scrape the data successfully. You can get the CSS selectors from here. On the contrary, Data Fetcher recognizes the types of data with their default CSS selectors.


We want the scrape all the names, dates and images of the online events:

Change the CSS selector

Step 8: After you’re done, click “View Results”.

Step 9: Click “Save recipe” in the left sidebar and sign up for Simplescraper.

save recipe simplescraper

Step 10: Sign up for a free Simplescraper account.

Step 11: Enter a name for the recipe.

Step 12: Click on 'Create recipe' at the bottom of the screen.

Step 13: Click on the recipe under 'My Recipes'.

Step 14: Click on 'Run recipe' and let the recipe run.

Step 15: Go to the Eventbrite API section and copy the API.


That would be it. You can also download the CSV file and import Eventbrite events data with the CSV import app or as a CSV file as we showcased above.

Import Eventbrite events data with DataFetcher


Step 1: Install the Data fetcher app from the Airtable marketplace you can find in the right upper corner of your base

Step 2: Create a free account and start a new request

Step 3: The request screen will pop up where you could select “Custom” from the Application’s menu.

custom application

Step 4: Enter a Name for your request.

Step 5: For URL, enter the Eventbrite API URL you copied from Simplescraper.

eventbrite url

Step 6: Select the Airtable Output Table & View you want to pull in Eventbrite Events into.

output table & view

Step 7: Click 'Save & Run'.

save and run

The request will run and the Response field mapping tab will open., Select how the Eventbrite fields should be mapped to Airtable rows.

Step 8: Once you’re done with field mapping, click 'Save & Run'.

field mapping

Data Fetcher will create the fields in the output table, run the request and import the data from Eventbrite to Airtable.


These were all the steps required for syncing Eventbrite with Airtable manually and for free.

One of the best things about Airtable is its flexibility.

Connect your Airtable database to Softr and build beautiful no-code web apps in minutes.

Import Eventbrite data to Airtable with Zapier


Zapier is an automation tool that allows end-users to integrate the web applications they use and automate workflows. Zapier is one of the best automation tools which will also help you sync Eventbrite with Airtable.


With Zapier you can pull data on new Eventbrite attendees and copy new Eventbrite events to Airtable.


In our example, we will create a trigger when an attendee registers for our sample event.



Connect Eventbrite with Zapier


Step 1: Sign in/sign up to Zapier.

sign in/ sign up to zapier

Step 2: Go back to the Eventbrite x Airtable page and click on the Connect Airtable + Eventbrite button to get started.


Step 3: Select or connect an Eventbrite account

connect eventbrite with zapier

Step 4: If you're connecting a new account, allow Zapier to access your Eventbrite account.

connect eventbrite ith zapier

Step 5: Select the name of the person or the organization who owns the event and click “Next”.

eventbrite organization

Step 6: Select the types of events you want to see in the imported data.

event type

Step 7: Select the event you want to set a trigger for.

event

That would be all you need to do for connecting Eventbrite to Zapier.

Moving on to connecting Airtable to Zapier.



Connect Airtable to Zapier


Step 1: Connect a new account or proceed with a pre-connected Airtable account.

connect your Airtable account

Step 2: A new window will pop up where you should enter your Airtable API.

You can get your API key from your account page.


Step 3: Click “Yes, Continue”, once you enter your API key.

airtable api

Step 4: Choose an output base, and a table for data importing.

outpute base
output table
output view

Step 5: Select the fields you want to edit in the output table. 

output fields

Step 6: Map fields from Eventbrite into Airtable

Image alt

Step 7: Test out the Zap.

test out zap
test out zap

That would be it. You can always manage your Zap, turn it off/on, and even delete it if there is a need.

eventbrite x airtable zap

One of the best things about Airtable is its flexibility.

Connect your Airtable database to Softr and build beautiful no-code web apps in minutes.

Import Eventbrite events data to Airtable with Make


Next, we move on to Make.


Make (formerly Integromat)is an automation tool as well, but it’s much more customizable and offers a bigger number of modules (request) when importing Eventbrite events data to Airtable.


With Make, you can also watch, create, list, and delete attendees, events, orders, and tickets in your Eventbrite account in an automated manner.



Connect Eventbrite to Make


Step 1: Sign up/sign in to your Make account to enter “My Organization page”.

Step 2: Click “Create a new scenario” to start syncing Eventbrite with Airtable.

Step 3: Select Eventbrite and choose an Eventbrite module to build the scenario.


We’ve chosen the “List Attendees” module for Make to retrieve a list of attendees for our event. You can learn more about the modules here.


Step 4: Connect an Eventbrite account to Make

Step 5: Allow Make to access your Eventbrite account

Step 6: Select the organization or the person whose events you want to list

Step 7: Select the events you want to list

Step 8: Choose the status of attendees you want to track.

Step 9 (optional): Enter the date and time to list event attendees that were modified after a specific time period.

eventbrite customization

Step 10: Run the module once, to check if it works.

run eventbrite module once

The next part of the syncing process is connecting Airtable to Make.



Connect Airtable to Make


Step 1: Click on the + button on the lower right corner of the page.

Step 2: On the opened dialog, find Airtable and select the right action.

Step 3: Select the “Create a new record” trigger, to have the attendee’s data imported to the table automatically.

Step 4: Connect an Airtable account by clicking “Add” and entering your Airtable API key.

connect eventbrite to zapier

Step 5: Select an output Base and a Table to create new records.

Step 6: Select records to import your Eventbrite data.

We wanted to list the First Name, Last Name, Status, and Email of the attendees in the output table.

airtable output features

Step 7: Run your scenario one to check if your data is imported to Airtable records successfully.

Image alt

One of the best things about Airtable is its flexibility.

Connect your Airtable database to Softr and build beautiful no-code web apps in minutes.

Final Thoughts


We've provided the most effective ways to connect Airtable to Eventbrite so you can easily import event data. Going through this process may seem fairly complicated and time-consuming, to begin with, but It will definitely save you time and effort if you follow the steps we have in the guide. Good luck!

Client Portal | Internal Tools | Web App Builder | Free Website Builder Made with Softr