Excel To Google Sheet.py

from Google import Create_Service
import win32com.client as win32

xlApp = win32.Dispatch('Excel.Application')
wb = xlApp.Workbooks.Open(r"<Excel File Path>")
ws = wb.Worksheets('<Worksheet Name>')
rngData = ws.Range('A1').CurrentRegion()

# Google Sheet Id
gsheet_id = '<Google Sheet Id>'
CLIENT_SECRET_FILE = 'client_secret.json'
API_SERVICE_NAME = 'sheets'
API_VERSION = 'v4'
SCOPES = ['https://www.googleapis.com/auth/spreadsheets']
service = Create_Service(CLIENT_SECRET_FILE, API_SERVICE_NAME, API_VERSION, SCOPES)

response = service.spreadsheets().values().append(
    spreadsheetId=gsheet_id,
    valueInputOption='RAW',
    range='WorksheetName!A1',
    body=dict(
        majorDimension='ROWS',
        values=rngData
    )
).execute()