Exhibitor Hall

This script takes the Gen Con Exhibitor maps, extracts the vendor/booth number, then adds the data to a Google sheet with each map as a new tab.

Table of Contents

• About The Project
  • Built With
• Getting Started
  • Prerequisites
  • Installation
• Usage
• Features

About The Project

This project was designed to take the vendor and their associated booth numbers from the Exhibit Hall map and put them into a Google Sheet. Currently, Gen Con does not have a method to filter/export for specific vendors or booth easily and this script was designed to make it easier.

Note

At this moment, the script does not support the sponsors listed, but the feature is coming.

(back to top)

Built With

(back to top)

Getting Started

To get a local copy up and running see the following steps.

Prerequisites

In order to use the script, Python must be installed.

• Python 3.9+

Installation

1. Clone the repo

   git clone https://github.com/mriffey1/vendor-hall-exhibitors.git

2. Generate a service account key json at Google Cloud Console

For detailed instructions on how to create a service account, please visit For Bots: Using Service Account

3. Save the json file as sheet.json
4. Install required packages

   pip install -r requirements.txt

5. Rename the .env-sample to .env
6. In the .env file, update MAIN_FOLDER_PATH with the directory's path
7. Also update the link to GOOGLE_WORKBOOK that you wish to put the data in
8. Ensure you have given the service account access to the spreadsheet by sharing and giving the email address associated with the service account, Edit access

(back to top)

Usage

1. To run the script, navigate to the directory with vendor_hall.py and use the following terminal command

   python main.py

(back to top)

Features

• Adding Sponsor names and booth locations
• Creating option for Google Sheets or Excel file

(back to top)