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