OR 

How to Highlight Duplicates in Google Sheets and Remove

The Email Extractor app pulls emails addresses of your contacts from Gmail into a Google Sheet. You can then use Mail Merge or Document Studio to send personalized emails to your contacts from within the sheet itself. That said, the imported

favicon of http://www.labnol.org

Google Apps Script for Developers

Google Apps Script makes it is easy for you to integrate data and functionality from Gmail, Google Drive, Google Maps, YouTube, and most other Google APIs. Apps Script is JavaScript under the hood so you don‘t have to learn a new language and you don

favicon of http://www.labnol.org

How to Search Google Images by the Exact Size

Google Images earlier offered a useful "search by size" option in advanced search to help you find logos, wallpapers and other images on the Internet by their exact size (or resolution). For instance, you could limit your search for landscape

favicon of http://www.labnol.org

Measure Core Web Vitals of your Websites with Google Sheets

Google‘s web.dev virtual conference happened last month and if there‘s one key takeaway from the event, it is the "core web vitals" initiative. Website owners can no longer afford to ignore core vitals as these are now a ranking signal in Google

favicon of http://www.labnol.org

How to Preserve Formatting of Spreadsheet Cells in Mail Merge

The Mail Merge app merges data from a Google Spreadsheet and sends them as personalized emails . You can format your sheet data in multiple colors, choose different font families, vary the size of your text, include hyperlinks , line breaks and

favicon of http://www.labnol.org

How to Use a Different Reply-to Address in Gmail

With Document Studio , you can specify a different reply-to email address for outgoing email message. When the recipient hits the "Reply" or "Reply All" button, the To field in their email reply gets populated with the email address that you‘ve

favicon of http://www.labnol.org

How to Make your Documents Read-only in Google Drive

The files in your Google Drive are private by default and only the owner has initial permissions to view, edit or delete their files. If you choose to share a file with other people, you can decide whether others have read-only access to your files

favicon of http://www.labnol.org

How to Request Additional Quota for your YouTube API Project

A UK based organization recently organized an online conference with 300+ participants and each of the attendees were asked to upload a video to a common YouTube channel post the event. The organizers created a YouTube uploader to make it easy for

favicon of http://www.labnol.org

How to Password Protect Google Documents and PDF files in Google Drive

Introducing PDF toolbox , a new Google Drive addon that lets you password protect PDF files and Google Documents. The app can also help you unlock PDF files that are already protected with a password in your Google Drive. Watch the video tutorial

favicon of http://www.labnol.org

How to Search Emails in Gmail by Specific Time

Gmail supports a plethora of search operators to help you instantly find that elusive email message buried in your mailbox. You have size search - like larger_than:5mb - to find the big messages in your account. File search - like has:attachment

favicon of http://www.labnol.org

Download Gmail Messages as EML Files in Google Drive

This Google Script will help you download your email messages from Gmail to your Google Drive in the EML format. What is the EML Format The .eml file format is popular for transferring emails from one email program to another since it complies with

favicon of http://www.labnol.org

How to Receive Push Notifications for Google Forms on your Mobile Phone

The Google Form Notifications add-on sends the form data in an email message each time a respondent submits your Google Form. It can also send automated emails tothe form respondent confirming that their response has been received. Push

favicon of http://www.labnol.org

How to Enable Third-party Cookies in Google Chrome

The newer versions of Google Chrome block third-party cookies by default. Cookies are considered "bad" as they are mostly used for tracking users on the Internet but some cookies serve a useful purpose as well. For instance, a GSuite add-on may

favicon of http://www.labnol.org

How Businesses can Check Health Status of Employees with Aarogya Setu

The Government of India has recently introduced an "open API" for Aarogya Setu , the world‘s most popular contact tracing app that has more than 110 million users across the Android and iOS platform. The Aarogya Setu API, in simple English, will

favicon of http://www.labnol.org

Google Maps Formulas for Google Sheets

You can bring the power of Google Maps to your Google Sheets using simple formulas with no coding. You don‘t need to sign-up for the Google Maps API and all results from Google Maps are cached in the sheet so you are unlikely to hit any quota limits

favicon of http://www.labnol.org

This YouTube Video Has n Views - How the Video Title Updates Itself

If I were to pick a YouTube video with the most accurate and most up-to-date title, this video by Tom Scott will probably take the top spot. The title of the video says "This video has n views‘ and this title updates automatically as the number of

favicon of http://www.labnol.org

How to Get your Visitor‘s Location from their IP address

The PayPal website mentions a list of 200 countries where the PayPal service is officially available. There are about 46 countries and regions left where buyers cannot transact using PayPal. As highlighted in the Google Map above, the regions where

favicon of http://www.labnol.org

Reclaim Disk Space - How to Find the Biggest Files in your Google Drive

Your Google account storage is shared between Gmail, Google Drive, and Google Photos. What do you do when your Google account is running out of storage space? You either buy more storage from Google or the inexpensive option is that you spend some

favicon of http://www.labnol.org

How to Send Emails from a Different Address (Alias) with Gmail

Say you have two email accounts - personal@gmail.com and work@company.com - the former is your personal email address while the latter is your work (corporate) email address. You are logged into your personal Gmail account but would like the mail

favicon of http://www.labnol.org

How to Send HTML Emails with Gmail

This tutorial describes how you can easily send HTML emails in Gmail without using any extensions. You can format your Gmail messages to include tables, buttons, custom fonts, social media icons, wrap images around text, and more. A little

favicon of http://www.labnol.org

How to Embed Barcode and QR Code In Google Forms Notifications

The Google Form Notifications add-on lets you automatically send Google Form responses in an email message to one or more recipients. The email notifications are dispatched the moment your form receives a new submission. The more recent version of

favicon of http://www.labnol.org

Google Drive Monitor - Get Email Alerts When Files are Deleted in your Drive

When you delete a file in Google Drive, it moves to the trash folder and stays there indefinitely until you manually empty the bin. That is how it has always been but, sometime this month, Google made one important change to how the trash bin works

favicon of http://www.labnol.org