Freelancer, Google Apps Script Developer, Cat Lover.
Google Apps Script helper functions for handling rich text values in Google Sheets Introduction Join & Split text in Google Sheets with the built-in functions is handy and easy to use for normal text. However, we may need to handle rich text values which contain multiple different text attributes like font color, family, size, bold, … Read more
Create Any Nested Custom Menu Structure in Google Sheets, Docs, Slides, Forms Introduction Custom menu is a very handy tool to manage the custom scripts and functionalities for the end users. However, it’s a little bit of crowded and tedious when more and more scripts are added to the menu. To organize the scripts and … Read more
Automate email reply or draft reply with the ChatGPT and Google Apps Script Introduction In this Google Apps Script project, I am using ChatGPT to generate a reply message by providing the messages in the Gmail thread. The reply can be then sent out directly or created as a draft so you can review before … Read more
A set of tools for your Google Sheets living in the sidebar. Features Tab Tools In this feature, you can sort and color your tabs. It should be a useful tool if you have too many tabs in your spreadsheet. More features are coming …
Intro If you are new to Google Apps Script, this guide may help to complete the authorization process for your first script. If you want to learn more about it, here is the document from Google. Steps From the Custom Menu (after menu “Help”), try any custom function in it. It should open this dialog if the … Read more