Google Sheets and Microsoft Excel are no doubt the two most and widely used spreadsheet software today. In this tutorial I will be showing you how to use Google Sheets API and win32com module to integrate these two applications in Python.

We will be using win32com to control Excel spreadsheet and Google Sheets API to read data from Excel.

Install Google Client Python Library
https://youtu.be/euIHL4q4L0Q

Create a new project
https://youtu.be/wJ6WC0G8w4o

Create a client secret file
https://youtu.be/HzICUriU3k0

Create a Google Sheets Service instance
https://youtu.be/xE0kuiAPxtA

Export Excel To Google Sheets.py
Google.py