I will automate the routine tasks related to Google Sheets documents.
A Python script based on your specifications will be developed. Its features may include:
- Creating books and/or worksheets
- Inputting data into cells/rows/columns
- Retrieving and processing data from the sheet
- Inserting an external table or dataframe
- Inserting Google Sheets formulas or hypertext links
- Formatting certain elements of the sheet
The program may be implemented as a desktop app based on Qt Framework.
All operations are processed through Google Sheets API (Google Drive API may be required as well). The program is tested on a dedicated Google Cloud app, which utilizes OAuth tokens.
Development will be carried in Python 3.8, so keep in mind that the app wouldn't be running under Windows XP or earlier.
Development will be carried on Windows-based machine (until other is stated)