All Posts by Prasanth Janardanan

How to send HTML email in Google Apps Script

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:

where the message is a string with HTML content. An Example Suppose you have a Google sheet with a list […]

Continue reading

How to delete duplicates in Google Sheets

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

How to send email when cell value changes in Google Sheets

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 Google Sheets, how to compare two columns for duplicates

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

How to get cell value in Google Sheets using apps script

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

How to add new contacts using Google Apps Script (example code)

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

Building Single Page Apps (with Vue and Bootstrap) on Google Apps Script

Building a complete web app on Google Apps Script

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

1 My experience trying to get approval for an App that uses G Suite API

restricted api

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

In Google Sheets, how to highlight duplicates using a simple formula

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

Using ES6 and npm modules in Google Apps Script

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