{"id":3878,"date":"2025-05-21T15:42:54","date_gmt":"2025-05-21T19:42:54","guid":{"rendered":"https:\/\/techministry.blog\/?p=3878"},"modified":"2025-05-21T15:42:54","modified_gmt":"2025-05-21T19:42:54","slug":"revisiting-and-refining-a-google-apps-script-with-the-help-of-generative-ai","status":"publish","type":"post","link":"https:\/\/techministry.blog\/?p=3878","title":{"rendered":"Revisiting and Refining a Google Apps Script with the help of Generative AI"},"content":{"rendered":"\n

A few years ago (6 years ago!), I shared about a solution<\/a> 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.<\/p>\n\n\n\n

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?<\/p>\n\n\n\n

\"\"
This was my starting prompt.<\/figcaption><\/figure>\n\n\n\n

I started by sending ChatGPT my existing script and asking if it had any ideas to improve the prompts.<\/p>\n\n\n\n

\"\"
The response<\/figcaption><\/figure>\n\n\n\n

We immediately got to work redesigning the script – mostly focusing on the dialogs and flow.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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.<\/p>\n\n\n\n

After some back and forth, here’s what the new dialog looks like:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

This looks a lot better! I even added a progress bar:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n
\"\"<\/figure>\n\n\n\n

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.<\/p>\n\n\n\n

If you want to see my script, you can check it out here: https:\/\/github.com\/josephdadams\/document-generator-gas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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 … Continue reading “Revisiting and Refining a Google Apps Script with the help of Generative AI”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2,16,17,26,38,50,51],"class_list":["post-3878","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-ai","tag-chatgpt","tag-church","tag-google-apps-script","tag-ministry","tag-production","tag-programming"],"_links":{"self":[{"href":"https:\/\/techministry.blog\/index.php?rest_route=\/wp\/v2\/posts\/3878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techministry.blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techministry.blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techministry.blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techministry.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3878"}],"version-history":[{"count":0,"href":"https:\/\/techministry.blog\/index.php?rest_route=\/wp\/v2\/posts\/3878\/revisions"}],"wp:attachment":[{"href":"https:\/\/techministry.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techministry.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techministry.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}