You can send HTML email from Google Apps Script. For example, suppose you want to send emails from your Google Sheet when certain events occur. You can send email using MailApp.sendEmail() function like this: MailApp.sendEmail({ to: email, subject: “This is a test email”, htmlBody: message }); where the message is a string with HTML content. […]
Continue reading
It is easy to remove duplicates and clean up your Google Sheet using one of the formulas. The best functions to use to find duplicates in a Google Sheet is MATCH() function and the COUNTIF() function. We use one of these functions to search for the current cell value in all the previous cells. Then […]
Continue reading
Suppose you want to trigger an email to yourself when a cell value is changed in the Google Sheet. Here are the steps that this script will do: – Collect the details about the row that was updated. – Compose an email with the details from the changed row – send the email to one […]
Continue reading
In another article here ( In Google Sheets, how to highlight duplicates using a simple formula ), we had discussed how to highlight duplicates using the MATCH() function. In this article, we will see how to find duplicates when there are more than one columns to search for duplicates. Suppose you have a google sheet […]
Continue reading
There are different ways to get the cell values. This article shows you different ways to get cell values from the Google Sheet. Some of the methods (like getCell(row, col) ) will be easier if you want to iterate through the cells. Get selected cell value in your Google Sheet Script First, let us add […]
Continue reading
Suppose you have a Google Sheet full of contacts. You want to add some of those contacts to your Google/Gmail Contacts. This article has all the sample apps script code to do it. By the way having all your contacts neatly organized in your Google Contacts list has several advantages. You can create groups, send […]
Continue reading
This is the second part on my Series on Google Apps Script advanced projects. See the first part of the article here. In the first part, we used ES6 and npm modules in the server side of Google Apps Script. In this article, we will move on to the client-side. We will create a Single […]
Continue reading
The promise of the G Suite developer program is too difficult to ignore: As they say: millions upon millions of G Suite users. Moreover, there is Gmail, Google Sheets, Google Docs, Google Analytics, and a huge set of Services to choose from. Or so I thought I made three Apps (two web apps and one […]
Continue reading
Imagine you have got a contact list of a number of leads. You collected it from different sources. So you don’t know if a certain contact is repeating. All you want is to search by the email and find all the duplicates. I searched around using Google for a quick solution. However I didn’t find […]
Continue reading
Google’s Apps Script should be of interest to all JavaScript developers. Apps Script is good for automation. Through it, you can directly access Google’s many services, such as Google Sheets, Gmail, Google Docs, Google Calendar, and more. With a little bit of imagination, you can create very exciting Apps and add-ons using Google Apps Script. […]
Continue reading