The purpose of this script is to automate the process of retrieving data from a complex Google Sheet and a simple text file, then enter the information contained in the text file (whether explicitly or implicitly) into the appropriate location of the Google Sheet.
- Python
- Jupyter Notebook - for incremental testing purposes
- gspread_pandas - Python module used to pull and push data via Google Sheets API
- Pandas - to wrangle and analyze data
- Numpy
- Datetime/Time
Further information, including screenshots of the Google Sheet referenced, will be forthcoming.