upload.py

import os
import csv
from selenium import webdriver, common
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
from selenium.webdriver.firefox.options import Options
from dotenv import load_dotenv, find_dotenv

# loading env file
load_dotenv(find_dotenv())

# initializing the titles and rows list
csv_fields = []
csv_rows = []

filename = "data.csv"

opts = Options()
#opts.set_headless()

browser = webdriver.Firefox("./")

def performSignIn():
    browser.get('https://kdp.amazon.com/en_US/')
    browser.find_element_by_css_selector("span#signinButton").click()

    browser.find_element_by_id("ap_email").send_keys(os.getenv('U_USEREMAIL'))
    browser.find_element_by_id("ap_password").send_keys(os.getenv('U_PASSWORD'))

    browser.find_element_by_id("signInSubmit").click()

def createPaperback(title, subtitle, description, keywords):
    browser.get('https://kdp.amazon.com/en_US/title-setup/paperback/new/details?ref_=kdp_kdp_BS_D_cr_ti')

    browser.find_element_by_id("data-print-book-title").send_keys(title)
    browser.find_element_by_id("data-print-book-subtitle").send_keys(subtitle)

    # fill author info if available
    browser.find_element_by_id("data-print-book-primary-author-prefix").send_keys(os.getenv('U_AUTHOR_PREFIX'))
    browser.find_element_by_id("data-print-book-primary-author-first-name").send_keys(os.getenv('U_AUTHOR_FIRST_NAME'))
    browser.find_element_by_id("data-print-book-primary-author-middle-name").send_keys(os.getenv('U_AUTHOR_MIDDLE_NAME'))
    browser.find_element_by_id("data-print-book-primary-author-last-name").send_keys(os.getenv('U_AUTHOR_LAST_NAME'))


    # wait for the text editor to become available and then click the source button
    wait = WebDriverWait(browser, 10)
    wait.until(EC.visibility_of_element_located((By.CSS_SELECTOR, '#cke_editor1 a.cke_button__source.cke_button_off')))
    browser.find_element_by_css_selector("#cke_editor1 a.cke_button__source.cke_button_off").click()

    browser.find_element_by_css_selector("textarea.cke_source").send_keys(description)


if __name__=="__main__":

    performSignIn()

    with open(filename, 'r') as csvfile:
        csvreader = csv.reader(csvfile)

        for row in csvreader:
            csv_rows.append(row)

        print("Found %d entries"%(csvreader.line_num - 1))


        for row in csv_rows[1:]:
            title = row[0]
            subtitle = row[1]
            description = row[2]
            keywords = row[3]
            print(row)

            createPaperback(title, subtitle, description, keywords)