Streamlining Tasks 10x: How I Used ChatGPT and Google Spreadsheets to Optimise My Work
As I scroll through my LinkedIn feed, I am frequently greeted with a quote that strikes a chord with me: “ AI won’t replace you, but a person using AI will. “ This sentiment is one that I have come to understand all too well in my recent work experience, where I was tasked with coordinating the allocations of graduate teaching assistants.
Upon my arrival in this new role late last year, I had a daunting responsibility of filling over 90 positions and obtaining approvals from more than 30 academics. It was clear to me that the traditional method of manual data entry and cross-checking of schedules was not only laborious, but also prone to error.
But, as with many challenges, a solution presented itself in the form of OpenAI’s ChatGPT and Google’s Spreadsheets. By harnessing the power of these tools, I was able to automate certain aspects of the allocation process and experience a significant improvement in efficiency.
In this article, I will share my experience using artificial intelligence (AI) in the form of ChatGPT and Google Spreadsheets to streamline the allocations process and demonstrate that, as the quote suggests, a person using AI can achieve greater success than one relying solely on manual means.
The allocation of graduate teaching assistants is a task that is all too familiar, and it is one that is burdened with a great deal of manual work. Entering data, organising student applications, coordinating academic approvals, creating statements of engagement, and communicating with students and supervisors are all part of the process.
The process of collecting applications and approvals was a particularly tedious task. Despite utilising Google Forms and Google Spreadsheets to store data, the coordinator was still required to manually look at each application to identify who had said “yes” or “maybe” to the positions. These names were then copied and pasted manually into corresponding cells for academic review.
The academics would then proceed by selecting students’ names by manually copying and pasting them into another cell. The next step, verifying each student’s schedule availability, was the most…