Google Sheets | blog.gsmart.in

0 How to do mail merge in G Suite using Google Sheet

Assume you are having a Google Sheet with tones of leads/contacts, that’s cool, right? More information to your arsenal. Now, this is the part where you want to make use of it by emailing them. Doing this manually is tedious and error-prone. Fortunately, there is a free add-on called Rapid MailMerge to automate Google Sheet […]

0 How to send mass email from Google Sheets using your Gmail Account

Perhaps, you would like to send emails to all – or some – of your client whose contacts or leads are available on your Google sheet. Sending such messages manually is often tedious and may lead to error. Instead, you can automate the process – and even personalize every email. Read along to learn about […]

0 How to do mail merge with attachment in Google Sheets

Suppose you want to send an email with attachment to a large set of contacts in a Google Sheet. Here is a step-by-step guide showing you how to do that fast. Get Rapid MailMerge Free add-on If you don’t have the free Rapid MailMerge add-on, get it quickly! It is quite handy to send emails […]

0 How to send email from Google Sheets

Suppose you have a Google Sheet full of contacts or leads. You want to send emails to all (or some) of them. Doing it manually will be error-prone and laborious. Here is how to automate it. You will also be able to personalize each email. Install Rapid MailMerge Add-on Rapid MailMerge is a free add-on […]

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 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 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 to use Google Sheets to mail merge labels

Wondering, what’s cooking today in our mind? Well, we are going to create a mail merge into a Google Sheet that enables you to create and print hundreds of address labels through Google Docs. Let’s find out the magic of this add-on. Note: Before proceeding to the first step, make sure you are logged on […]

0 How to merge cells in Google Sheets

There are a number of ways you can create a spreadsheet. There are times when the default layout of the spreadsheet doesn’t exactly match your needs. Merging the cells violates the default flow of rows and columns to slightly complicated structure. If you see the need for merging, consider it again. Often, keeping the default […]

Category Archives for "Google Sheets"