Apps Script + ChatGPT = MAGIC ✨
For years, I’ve used Autocrat to help me in creating products from Sheets. It’s worked well, but recently I needed something very specific, and I needed more options than Autocrat provided. Let me tell you, did ChatGPT deliver! It not only produced the script I needed, it also gave me suggestions on how to make the project even better!
The Product: Student Individual Curriculum Accommodation Plan (ICAP)
The (current) Barriers:
- They are paper, and not living in a common place for those who may need to access.
- At times, not everyone on the team knows when one is created for a student
The Solution:
- Digitize the ICAPs
- House them in a Shared Drive in Year of Graduation Folders
- Have an indicator on our Data Dashboard when students have an ICAP
The Project (🎶are you ready for it?)
1️⃣Shared Drive
I created a Shared Google Drive for the Child Study team to all have access to. In the Google Shared Drive, we have folders for Year of Graduation.
2️⃣Google Form
I created a Google Form that included key information needed for student ICAPs, including the accommodations needed from our DCAP, that you can see here. The data in the form is then exported to a Google Sheet. From this sheet, it will also populate on our Data Dashboard in Looker Studio, if a student has an ICAP (with a “Yes” or “No”) as well as if a student has gone through the child study process.
3️⃣ICAP Template
Using the questions that would serve as headers in the Google Sheet, an ICAP Template was created. You can see that here.
4️⃣Apps Script using ChatGPT
Knowing what I wanted the job to do, Form>Sheet>Template>YOG Folder, I used ChatGPT to write the script. In my prompt I included: bulleting the information that would come in, converting the doc to a PDF and deleting the Doc, as well as titling the PDF in a specific way. ChatGPT then told me what it needed to generate the script. A benefit was that ChatGPT even offered suggestions in the script that I hadn’t thought of! Check out my conversation with ChatGPT here, you can see where I also made errors in the script and ChatGPT assisted me in fixing it.
💡Closing Thoughts:
AI tools can assist us in workflows, and working more efficiently. However, we still need to run tests and trials and have knowledge in the output to know if it is working correctly. If you would like to see a video overview of this process, check it out below! I hope you try using Apps Script, with ChatGPT’s assistance. The possibilities are limitless!
Take care, Everyone!
oFISHally Yours,