Project Overview:
Automated the process of updating overdue loan information from a locally hosted web app to Google Sheets. This project aimed to improve efficiency and reduce manual errors in tracking loaned items, such as laptops and chargers, by synchronizing overdue data with Google Sheets. Originally this project was done in Apple Automator but I then transferred it to Python.
Key Tasks and Accomplishments:
Data Retrieval & Processing
- Extracted overdue loan information from a locally hosted web app used to manage device loans.
- Parsed and formatted the extracted data for compatibility with Google Sheets.
Script Development & Automation
- Developed a Applescript script to automate the data sync process.
- Scheduled regular updates to maintain data accuracy and reduce administrative workload.
Technologies & Tools Used:
- Applescript
- Apple Automatoin
Skills Demonstrated:
- Data Processing & Management
- Scripting for Task Automation
- Error Handling & Debugging