Digital Inspiration

How to Create JSON Web Token (JWT) with Google Apps Script

You can use Google Script to create JSON Web Tokens (JWT) that can be provided to secure routes so that only authenticated requests that contain a valid token can connect to the APIs (e.g., the Zoom API ). All JSON Web Tokens have three parts: The…

Lite YouTube Embeds - A Better Method for Embedding YouTube Videos on your Website

It is easy to embed a YouTube video but you'll be surprised to know how much extra weight a single YouTube video embed can add to your web pages. The browser has to download ~800 kB of data (see screenshot) for rendering the YouTube video player…

JavaScript Objects Quick Reference

Any object in JavaScript is a collection of key-value pairs. The key, also known as a property, is a unique string that maps to a value which may be a Boolean, String or another object. Let's take a simple person object that contains properties like…

Build a COVID-19 Self Assessment Tool with Google Forms

Businesses and schools worldwide are using Google Forms to build COVID-19 self-declaration forms that employees, students and visitors must complete every day before they can attend work. Here is a sample COVID-19 Health Screening Form - if the…

How to Play YouTube Videos at Custom Speed

The settings pane in the YouTube video player lets you quickly change the default playback speed of the current video. You may go as high as 2x that will play the video at twice the normal speed. The lower limit is 0.25 that will slow down the video…

Generate firebase.json file for Firebase Redirects

We recently moved the user guide for Mail Merge and Form Notifications from the website labnol.org to digitalinspiration.com . As with any domain move, we had to manually setup 301 redirects so that the audience are automatically redirected to…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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 to the form respondent confirming that their response has been received. Push…

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…

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…

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…

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…

The 10 Useful Networking Commands You Should Know

What is my IP address? Who is the host of this website? Which mail service is this domain using? There exist web tools that can uncover these details but this sort of research can also be done using the command line on your computer. Let’s explore…

How to Add Options in Google Forms Questions from Google Sheets

A school is trying to create a Google Form where students can register their details. The form would have a drop-down of countries, the names of class teachers as a multiple choice question and a checkbox style question where students can pick one or…

How to Create Zoom Meetings with Google Script

This guide describes how you can programmatically create user meetings in your Zoom account with the help of Google Apps Script and the official Zoom API. As a first step, go to the Zoom Developer Dashboard and create a new app . Choose JWT as the…

How to Create Forms that Allow File Uploads to Google Drive

With File Upload Forms ( form demo ) for Google Sheets, you can receive large files of any size from anyone directly in your Google Drive. You can automatically send email confirmations to notify the form submitter. The forms can be created inside…