Import Eventbrite Events to Airtable

In this guide, we'll look at 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' or something more specific 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

Import Eventbrite Events to Airtable

  • On the home screen of the Data Fetcher app, click 'Create request'.

Screenshot 2021-02-17 at 16.12.14.png

  • On the create request screen, enter the request name 'Fetch Eventbrite Events'.
  • In the URL enter the URL you copied from Simplescraper.
  • Create a table in your base called 'Events'.
  • In Data Fetcher, set the output table to the 'Events' table by clicking 'Use current'.
  • In Data Fetcher, set the output view to 'Grid view' by clicking 'Use current'.

Screenshot 2021-02-25 at 08.55.50.png
  • Click 'Run' to run the request. You'll see a loading message while the request runs, then the response field mapping modal will open.
  • Click 'Filter all' to remove all fields, then re-add the following field mappings:
  • 'data.name' -> 'Name'.
  • 'data.URL_link' -> 'Url'. Change the 'Data type' to 'Url' first and create a new field.
  • 'data.uid' -> 'Id'. Create a new field for this.
  • 'data.Date' -> 'Date'. Create a new field with type 'Single line text'. The dates we are scraping sometimes include some extra text so they are not quite valid dates. Therefore it's safer to use 'Single line text' and manually cleanse the dates when needed.
  • 'data.Image URL' -> 'Image URL'. Create a new field with type 'URL'.
  • Click 'Confirm'. The request will now run again and update the 'Events' table.
  • Click 'Save'.
Screenshot 2021-02-24 at 17.31.24.png
  • Click 'Advanced' to open the Advanced settings and under 'Update based on Field', choose the 'Id' 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.

  • In the Advanced settings under 'Pagination' select 'Offset'.
  • Turn on 'Fetch all pages'.
  • In the 'Offset parameter' input, enter 'offset'.
  • In the 'Limit parameter' input enter 'limit'.
  • In the 'Limit value' input enter '1000'.
  • Click 'Save'.

Update Events Automatically

At the moment we have to events our prices by manually clicking the 'Run' button. Let's configure them to update automatically by using Data Fetcher's scheduled requests feature.

  • In Data Fetcher, scroll to 'Schedule'.
  • You will need a paid account to use this feature, so click the link to upgrade your account if you haven't already. After upgrading, click the 'I've done this' button.
  • Add your Airtable API key if you haven't already.
  • Turn on 'Schedule this API request'.
  • Set how often you want the request to run.
  • Click 'Save'.