🔥 Google Sheets integration is live! Learn more

Import Eventbrite Events to Airtable

Feb 23, 2021Andy Cloke

In this guide, we'll learn how to import public events from Eventbrite to Airtable. Eventbrite turned off the 'Search by location' API endpoint in 2019, so we'll use Simplescraper along with Data Fetcher Airtable app.

Install Simple Scraper

  • You'll need to be using Google Chrome because Simplescraper is a chrome extension.
  • Install Simple Scraper in the chrome web store.

Scrape Eventbrite Events using Simple Scraper

  • Go to the Eventbrite page with the events you want to import into Airtable. We'll use music events in Sydney as an example:

https://www.eventbrite.com/d/australia--sydney/music--events/?page=1

  • Click the Simplescraper extension icon, followed by 'Scrape this website'.
  • Add the following properties by clicking 'Add a property'/ the '+' icon, entering the name then clicking on the screen, then adding the CSS selector:

URL

div.search-main-content > ul > li > div > div > div.search-event-card-rectangle-image > div > div > div > article > aside > a

Image URL

div.search-main-content > ul > li > div > div > div.search-event-card-rectangle-image > div > div > div > article > aside > a > div > div > img

Name

div.search-main-content > ul > li> div > div > div.search-event-card-rectangle-image > div > div > div > article > div.eds-event-card-content__content-container.eds-l-pad-right-2 > div.eds-event-card-content__content > div > div.eds-event-card-content__primary-content > a > h3 > div > div.eds-event-card__formatted-name--is-clamped

Date

main > div > div > section.search-base-screen__search-panel > div.search-results-panel-content > div.search-main-content > ul > li > div > div > div.search-event-card-rectangle-image > div > div > div > article > div.eds-event-card-content__content-container.eds-l-pad-right-2 > div.eds-event-card-content__content > div > div.eds-event-card-content__primary-content > div

Screenshot 2021-02-24 at 16.24.14.png

  • Click 'Select next-page element, then click on the '>'' icon at the bottom of the screen.
Screenshot 2021-02-24 at 17.01.41.png
  • Click 'VIEW RESULTS'.
  • Click 'Save recipe' in the left sidebar and sign up for Simplescraper.
  • Enter 'Scrape Events' for the recipe name.
  • Click on 'Create recipe' at the bottom of the screen.
  • Click on the recipe under 'MY RECIPES'.
  • Click on 'Run recipe' and let the recipe run.
  • Click on the '...' icon next to the recipe name, and click 'Edit'.
  • Scroll down to 'Page navigation'.
  • Set the 'Number of pages to scrape to the number you want.
  • Click on 'Show advanced options'.
  • Next to 'Schedule', set how often you want the crawler to run.
  • Click on the 'X' icon in the top right, then click on the 'API' tab.
  • Copy the API URL. It will look something like this:

https://simplescraper.io/api/6kvwfBjCehY5pa1aAXE8?apikey=UUes94OwOr132afsdafas8mjAV4MXf&offset=0&limit=20

Install Data Fetcher

Install Data Fetcher from the Airtable app marketplace. After the app launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.

Group 1Data Fetcher Sign Up .png

Import Eventbrite Events to Airtable

On the home screen of the Data Fetcher app, click 'Create your first request'. Requests in Data Fetcher are how you import data to or send data from your Airtable base.

click-create-your-first-request.png

On the create request screen in Data Fetcher, for Application, select 'Custom'.

custom-application-selected.png

Enter a Name for your request, e.g. 'Import Eventbrite Events'.

For URL, enter the URL you copied from Simplescraper.

Select the Output Table & View you want to import the data into.

output-table-1.png

Click 'Save & Run'.

The request will run and the Response field mapping modal will open. This is where you set how the available fields from Simplescaper should map to fields in the output table. For each field name, you can either import or filter it. For an imported field, you can set whether to map them to an existing field or create a new field. You can also set the field type for each new field.

Once you are happy with the mapping, click 'Save & Run'. Data Fetcher will create any new fields in the output table, then run the request and import the Eventbrite Events to Airtable.

Click 'Advanced' to open the Advanced settings and under 'Update based on Field', choose the 'Uid' field. The app will use this field to ensure the events in your base match those in Eventbrite.

Fetch More Events with Pagination

Let's set up pagination so that we import more events from Eventbrite. Simplescraper uses offset-based pagination.

Click 'Advanced settings', then for Pagination select 'Offset'.

Turn on 'Fetch all pages'.

For Offset parameter, enter 'offset'.

For Limit parameter, enter 'limit'.

In the Limit value input enter '1000'.

Click 'Save'.

Import Eventbrite Events to Airtable Automatically

At the moment, we have to click 'Run' in order to import the events from Eventbrite. We can use Data Fetcher's scheduled requests feature to automatically import the data every 15 minutes/ hour/ day etc.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

table-1-schedule-upgrade-button.png

A new tab will open where you can select a plan and enter your payment details to upgrade.

Screenshot 2021-12-29 at 10.25.19.png

Return to the Data Fetcher app and click "I've done this".

table-1-schedule-ive-done-this-button.png

Click 'Add API key' in order to add your Airtable API key. You can find your Airtable API key here.

Group 11(1).png

Enter your Airtable API key and click 'Save'.

save-airtable-api-key.png

Enable Schedule this request.

schedule-data-fetcher-request.png

Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save' The request will now run on the schedule and import the events from Eventbrite automatically.

Group 11(2).png

Other Recent Posts

How to Import Google Calendar Events to Airtable

How to Import Google Calendar Events to Airtable

Sep 26, 2022

Rosie Threlfall

Google Calendar
The Journey Bootstrapping a SaaS to $10k MRR

The Journey Bootstrapping a SaaS to $10k MRR

Sep 12, 2022

Andy Cloke

BootstrappingData Fetcher
How to Import Zoho CRM Data to Airtable

How to Import Zoho CRM Data to Airtable

Sep 8, 2022

Rosie Threlfall