Creating a new google sheet workbook and transferring pandas dataframe data

CreateNewWorksheet.py

def createMasterListWorkSheet():
   # get cleaned data from the RemoveDuplicateData Function
    newData = RemoveDuplicateData()

    # get the row count from the dataframe and convert to type int so as to be serialized to json (Produces error if not converted)
    rowCount = int(newData['hits'].count())
    # create a new sheet
    sheet.add_worksheet(title="MASTER_LIST", cols=6, rows=rowCount + 1)
    # Get the instance
    newSheet = sheet.worksheet("MASTER_LIST")

    # Insert the cleaned data
    newSheet.insert_rows(newData.values.tolist())

    # # Insert headers to the masterlist worksheet by calling the InsertHeader Function
    createWorksheetHeader(newSheet)
    print("Successfully Created MASTER LIST Worksheet")