Schparkly Scraper

An automated Python tool that collects business contact emails from expo exhibitor lists.

Installaton

1. Download expoGui.app.zip
2. Extract file
3. Move expoGui.app from your downloads folder into your applications folder (you can use the macos finder sidebar shown in the picture below)
4. Open up the terminal using either command + space combination to search for it OR by navigating into your launchpad and searching for it there (may be under utilities or other)
5. Once in terminal, copy and paste both these lines into it and press enter

chmod +x /Applications/expoGui.app/Contents/MacOS/* xattr -dr com.apple.quarantine /Applications/expoGui.app

6. Application should work now when opened from the application tab in the finder!

Usage

1. Insert expo/tradeshow exhibitor list
2. Select at least one search mode (recommended to only use one) however multiple can be used in conjunction for thorough searching
3. click the scrape button
4. wait for the scraper to find contacts
5. Download results .xlsx spreadsheet results
6. Additonally, the single page scraper can be used to scrape emails from the inputted website

Expectations

• Typically a long exhibitor list of 100-150 companies will take between 20-30 minutes to execute
• If the program shows "please wait..." in the text box, it's still scraping. only upon completion can the results be exported
• Not all company contacts will be scraped

Features

Expo list scraper:

Three different modes:

• Direct links: scan's websites for direct website links
  • The link to company websites is directly present on the exhibitor list i.e.

• modal links: scan's websites for modal pop uplinks
  
  • The link to company websites is present on a pop up card shown on the exhibitor list
  • Note the two images below as reference:
    • in order to find the website, the exhibtor must be clicked and then a pop up appears

• subpage links: scan's website subpages for company links
  
  • The link to company websites is present on a subpage found by clicking on a specific exhibitor on the list.
    • in order to find the website, the exhibtor must be clicked and then a pop up appears
      • for example: In order to navigate to the exhibitor called "apopo", the exhibitor must be clicked then the website link is shown on a different page
      • https://londonpetshowlive.com/exhibitors/ ----> https://londonpetshowlive.com/exhibitors/apopo/