Automated Meet Manager Entries

Created by Chris F, 2020

Installation

Mac OS

1. Install python
2. Install the necessary packages:

pip3 install pyautogui readchar gspread oauth2client

• If there is an error using pip3 install, try python3 -m pip install.

Setup

1. Create a new client key.

• Go to Google Cloud Console and click on the Navigation Bar. Select "APIs & Services->Credentials".
• Click on the MeetManager Service Account.
• On the bottom of the page, click Create Key.
• Make sure JSON is selected as the key type and a download should begin. Save the file as creds.json and put it in the google_sheets folder.
• This step only needs to be done once.

2. After creating the google form, open the response sheet. Click the Share button and go to creds.json found in the google_sheets directory. Copy the client_email (Ex. "meetmanager@future-sonar-276916.iam.gserviceaccount.com") and paste it in the share box. Then click Done.

Running the program

1. Open the command line/terminal.
2. Run the program:

python3 <folder_location>/autoMeetManager/autoMeetManager.py --sheet <sheet_url>

• <folder_location> is the location of the autoMeetManager application in your folder system. You can navigate to the autoMeetManager folder so you can simply run:

python3 autoMeetManager.py --sheet <sheet_url>

- To navigate your file system from the command line use ```cd <subdirectory
or path>``` to change directories, ```ls``` to check current subdirectories,
and ```pwd``` to check the current directory.

• <sheet_url> is the url of the google sheet containing the meet entry data. To prevent errors, wrap the url in "".
• To run with configuration setup (required on first run) add the -c or --config flag:

python3 autoMeetManager.py --sheet <sheet_url> -c

3. Ensure the program is correctly configured by observing the first few meet entries.

Getting Google Form Responses