get_cookie.py

import sqlite3
import win32crypt

def getCookie():
    userp = os.environ.get('USERPROFILE')
    
    # https://stackoverflow.com/a/23067039/678491
    # Connect to the Database
    cookiefile = "{}/AppData/Local/Google/Chrome/User Data/Default/Cookies".format(userp)
    conn = sqlite3.connect(cookiefile)
    cursor = conn.cursor()

    # Get data
    cursor.execute('SELECT host_key, name, encrypted_value FROM cookies WHERE name in ("FedAuth", "rtFa")')

    # cook a cookie joining rtFa and FedAuth
    cookie = []
    for c in cursor.fetchall():
        data = win32crypt.CryptUnprotectData(c[2], None, None, None, 0)[1].decode("utf-8")
        cookie.append('{}={}'.format(c[1],data) )
    cookie = ';'.join(cookie)
    return cookie