Create a google sheet worksheet header

createWorksheetHeader.py

def createWorksheetHeader(sheet):
    # Get the header data
    headerData = ['Hits', 'CourseName', 'CourseCode', 'Department', 'Lecturer', 'Students']
    # The row you want to enter
    index = 1
    # Insert the data to row with index
    sheet.insert_row(headerData, index)
    # format the color
    sheet.format('A1:F1', {'textFormat': {'bold': True}})