Category Archives for "Google Sheets"

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

Continue reading

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

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

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

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

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

Continue reading

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

Continue reading