Google Sheets To Excel.py

import win32com.client as win32
from Google import Create_Service

CLIENT_SECRET_FILE = 'client_secret.json'
API_SERVICE_NAME = 'sheets'
API_VERSION = 'v4'
SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']

gsheet_id = '<Google Sheets Id>'
gsheet_name = 'sheet1'

service = Create_Service(CLIENT_SECRET_FILE, API_SERVICE_NAME, API_VERSION, SCOPES)
gs = service.spreadsheets()
rows = gs.values().get(
    spreadsheetId=gsheet_id,
    range=gsheet_name,
).execute().get('values')

xlApp = win32.Dispatch('Excel.Application')
wb = xlApp.Workbooks('YourExcelFile.xlsx')
wsData = wb.Worksheets("Data")

wsData.Cells.ClearContents()

rowNumber = 1
colCount = len(rows[7])

for row in rows:
    wsData.Range(wsData.cells(rowNumber, 1), wsData.cells(rowNumber, colCount)).value = row
    rowNumber += 1