A few years ago (6 years ago!), I shared about a solution I came up with to create the weekly “talking points” Google documents that my team relies on. We’ve been using that same solution with Google Apps Script ever since. It’s been rock solid, and saves us a lot of time from creating each one of these documents by hand.
I decided it was time to refresh this script and document, since we now have a third venue (at a new campus). And, when it’s time to refine – why not consult some AI in the process?
I started by sending ChatGPT my existing script and asking if it had any ideas to improve the prompts.
We immediately got to work redesigning the script – mostly focusing on the dialogs and flow.
I came up with a basic new design that featured the church logo and a simpler header. ##VENUE## and ##DATE## are placeholders that get replaced with the actual Venue name and Date of the document.
After some back and forth, here’s what the new dialog looks like:
This looks a lot better! I even added a progress bar:
If you’re hesitating to jump in using generative AI – give it a whirl! It can save you a lot of time and propose ideas you may not have thought about.
If you want to see my script, you can check it out here: https://github.com/josephdadams/document-generator-gas