blog.gsmart.in | GSuit App and Addon Development

0 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 […]

0 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 […]

0 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 […]

0 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 […]

0 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 […]

0 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 […]

1 My experience trying to get approval for an App that uses G Suite 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 […]

0 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 […]

0 How many emails get sent a day?

It is an interesting statistic to know. How many emails are sent per day in the whole world? It is estimated that 293 billion emails are sent every day. The number will grow to 333 billion by the end of 2022. According to some estimates, 53.5% of all the emails sent is spam. For a […]

0 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. […]

« Previous 1 2 3 4 5 … 8 Next »