“This app is blocked” error on Google Apps Script [solution]
If you found this post, you have most likely gone through the ‘normal’ authentication process before. Otherwise, check out this great post on how to authorise Google Apps Scripts by Kieran Dixon. The “This app is blocked” error is a little different, as there is no more buttons that we can click on to continue…
Build a Chinese Character Separator tool using Google Sheets!
When I was working as a salesperson, my company received a lot of prospective leads through Google Forms. When we wanted to reach out to these leads, we found that although we had specified separate ‘Name’ fields, a lot of prospects ended up putting both their Chinese and English names in a single ‘Name’ field.…