Join & Split Rich Text Values in Google Sheets

by

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

Single Function to Handle Custom Menus with Apps Script

by

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

Add View Count with Microsoft Power Automate

by

Intro In this post, I shared a solution to add view count to blogger posts with Google Apps Script. However, we need to add some custom code to every single post manually. This is a solution to add the code automatically to the post with Power Automate. Instructions 1. Build an automated cloud flow. 2. … Read more

Add View Count to Your Blogger Posts

by

An Alternative Solution with Google Apps Script GAS106 Intro “Post View” or “View Count” feature is not supported in the post of Google Blogger for some reason. And it’s even not in the blogger API service. To show the post views on every single post of yours for the viewers. Here is my simple and … Read more

Create Gmail Replies or Drafts with ChatGPT

by

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