app.py

# AUTOGENERATED! DO NOT EDIT! File to edit: Appointlet2GS.ipynb.

# %% auto 0
__all__ = ['iface', 'Appointlet', 'GoogleSheets', 'run']

# %% Appointlet2GS.ipynb 0
from selenium import webdriver
from selenium.webdriver.chrome.service import Service as ChromeService
from selenium.webdriver.chrome.options import Options
from webdriver_manager.chrome import ChromeDriverManager
from selenium.webdriver.common.by import By
import time
import os
import gspread
import pandas as pd
from pathlib import Path
import gradio as gr

# %% Appointlet2GS.ipynb 1
class Appointlet():
    def __init__(self, url = 'https://app.appointlet.com/unified_login'):
        self.url = url
        
    def setup(self):
        options = Options()
        options.add_argument('--incognito')
#         options.add_argument("--headless")
        service = ChromeService(ChromeDriverManager().install())
        driver = webdriver.Chrome(options=options, service=service)
        driver.maximize_window()
        return driver
    
        
    def download(self, account):
        email, password = open(account, 'r').read().splitlines()
        driver = self.setup()
        driver.get(url=self.url)
        driver.implicitly_wait(30)
        
        # input email
        driver.find_element(By.CSS_SELECTOR, "input[name='email']").send_keys(email)
        driver.find_element(By.CSS_SELECTOR, 'button.mt-16').click()
        
        # input password
        driver.find_element(By.CSS_SELECTOR, "input[name='password']").send_keys(password)
        driver.find_element(By.CSS_SELECTOR, 'button.mt-16').click()
        
        # remove welcome message
        try:
            driver.find_element(By.CSS_SELECTOR, 'button.btn-block').click()
        except:
            pass
        
        # remove introduction
        try:
            driver.find_element(By.CSS_SELECTOR, 'button.shepherd-cancel-icon').click()
        except:
            pass
        
        # Meeting filter
        # Launch meeting filter
        driver.find_element(By.ID, 'MeetingFilters').click()
#         # Filter by meeting types
#         driver.find_element(By.CSS_SELECTOR, 'svg.css-8mmkcg').click()
#         driver.find_element(By.XPATH, '//div[contains(text(), "Example Meeting")]').click()
        # Filter by status
        driver.find_element(By.CSS_SELECTOR, "input[name='isPending']").click()
        # Apply filters
        driver.find_element(By.XPATH, '//span[contains(text(), "Apply Filters")]').click()
        
        # Download csv file
        driver.find_element(By.CSS_SELECTOR, "div.MoreButton.dropdown > button[class='dropdown-toggle btn btn-outline-secondary']").click()
        driver.find_element(By.XPATH, '//span[contains(text(), "Export Attendees (CSV)")]').click()
        
        # Close the browser windows and ends the WebDriver session
        time.sleep(5)
        driver.quit()
        

# %% Appointlet2GS.ipynb 3
class GoogleSheets():
#     def __init__(self, creds_file = 'credentials.json', sh_file = 'googlesheet_info.txt'):
    def __init__(self, creds_file, sh_file):
        self.creds = creds_file
        self.sh = sh_file
        self.folder = '.'
        
    def get_sheet_info(self):
        sh_id, wk_name = open(self.sh, 'r').read().splitlines()
        return sh_id, wk_name
    
    def read_csv(self):
        # read the downoaded csv file into dataframe and remove the file
        for fn in os.listdir(self.folder):
            if fn.find('Meeting Attendees') != -1:
                file = os.path.join(self.folder, fn)
                df = pd.read_csv(file, low_memory=False)
                df = df.fillna('')
                os.remove(file)
        return df
        
    def update_worksheet(self):
        # Setup service account
        sh_id, wk_name = self.get_sheet_info()
        gc = gspread.service_account(filename=self.creds)
        
        # Open a sheet from a spreadsheet
        wk = gc.open_by_key(sh_id).worksheet(wk_name)
        
        # Clear the worksheet
        wk.clear()
        
        # Get the new data
        df = self.read_csv()
        
        # Writing the new data to Google Sheets
        wk.update([df.columns.values.tolist()] + df.values.tolist())


# %% Appointlet2GS.ipynb 4
def run(account, creds_file, sh_file):
    if not account:
        return 'Please upload an account file'
    else:
        Appointlet().download(account.name)
#         Appointlet().download(account)
#         GoogleSheets(creds_file.name, sh_file.name).update_worksheet()
        return 'Update Google Sheets completed!'

# %% Appointlet2GS.ipynb 7
iface = gr.Interface(fn=run, 
                     inputs=[gr.File(label='Account File'), 
                             gr.File(label='Credentials Json File'), 
                             gr.File(label='Googlesheet Info')], 
                     outputs=gr.Text(),
                     allow_flagging='never', 
                     title='Appointlet2GS Application', 
                     description='Download Meeting Attendees file From Appointlet and upload it to Google Sheets')
iface.launch(height=450, width=500, debug=True, enable_queue=True)