Using the google spreadsheets API, gspread library, and pyqt5, I've made a simple spreadsheet updater.
A dialog box opens up and asks the user for the data that is supposed to be updated in the spreadsheet online. When the user writes the data and submits, the spreadsheet is updated automatically.
Use the package manager pip to install the libraries.
pip install gspread
pip install pyqt5 from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint-
Set up to get the API access. To gain the access, go to the "google cloud platform" and create a new project and install and enable the "google drive" & "spreadsheet" which can be found in the library section.
-
Get the JSON file from your API. This JSON file contains all your credentials that allow the API to connect and interact with your code. I named my JSON file "creds"
-
Create a new spreadsheet and name it and share it with the "client-ID" email that you receive in the JSON file from the API
If you want to create a GUI with custom dialog boxes then I suggest you to learn to use pyqt5. It is a great tool that is in my opinion much better than the alternatives that I've come across.
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.