Google sheets API is used with gspread and oauth2client in Python.
Install 2 python libraries as below:
pip install gspread oauth2client
You can follow the operation details in the 串接Google Sheet API 操作試算表運算
Run the example code GoogleSheetsAPI.py
after API setting.