Digital Inspiration

Sort by Random - How to Randomize the Order of Rows in Google Sheets

You have a workbook in Google Sheets that contains multiple rows of data and you are required to sort the list in a random order. For…

Exceeded maximum execution time Exception in Google Apps Script

Google Apps Script is a serverless environment that makes it easy for you to work with Gmail, Google Drive and other services that are part…

How to Replace Accented Characters (diacritics) with English letters in Google Sheets

The REMOVE_ACCENTED function for Google Sheets will replace all accented characters in the referenced cell, like the letters è, õ, ā, ĝ…

How to Find and Replace Text in Google Docs with RegEx Search Patterns

It is easy to search and replace text in Google Documents with the DocumentApp service of Google Apps Script. You can use use findText…

How to Change the Font in your Google Documents with Apps Script

An organization recently migrated their Word Documents from Microsoft Office to Google Drive. The migration has been smooth but the Word…

How to Replace Text and Hyperlinks in Google Documents with Apps Script

The company's handbook is written in Google Docs. The document spans several pages and now the writer has been asked to create links such…

How to Convert Column Number (e.g. 28) to Column Letter (e.g. AB) in Google Sheets

Google Sheets includes built-in functions for converting cell references in A1 notation to row and column numbers and another function for…

Google Documents - How to Replace Text in Header and Footer

The upcoming release of Document Studio includes support for adding markers in the header, footer and the footnotes section of your…

How to Schedule a Google Meeting with Google Calendar and Apps Script

This Apps Script sample shows how you can programmatically schedule video meetings inside Google Meet with one or more participants using…

How to Add a Watermark in Google Documents

Microsoft Word includes a useful "Insert Watermark" feature to help you easily add your brand's logo image or a text stamp that fades behind…

How to Use PayPal Subscriptions API with Node.js

Our Google add-on store uses PayPal Subscriptions with Digital Goods to process recurring payments and the invoices are sent to…

The Best Google Chrome Extensions

Here's a list of my favorite extensions for Google Chrome that I depend on every day. These recommended extensions will improve your…

How to Use Notion with Gmail and Google Sheets using Apps Script

Notion, my absolute favorite tool for storing all sorts of things from web pages to code snippets to recipes, just got better. They've…

Create React App with Multiple Entry Points

The Create React App frameworks lets you easily build single page applications but it doesn't support multiple entry points. To give you an…

Google Sheets - Find Values in One Column that are Missing in Another Column

A small business maintains their staff roster in a simple Google Sheet - the column A of the sheet contains a list of all employee names and…

How to Email Spreadsheets Automatically on a Recurring Schedule

The Email Spreadsheets add-on for Google Sheets will help you automate the reporting of spreadsheet data and dashboards by email. If you…

Get Email Alerts When COVID-19 Vaccines Become Available Near You

India is currently in the midst of a second wave of the Coronavirus and this one is far more devastating than what we have seen last year…

Find Google Sheets Linked to your Google Forms

When a user submits your Google Form, the response can be either saved in the Google Form itself or it can be written as a new row in a…

How to Add Options in Google Forms Questions from Google Sheets

An international school is building a Google Form where students can register their details. The form would have a drop-down list of…

How to Print the Function Call Flow with Stack Trace in JavaScript

The printStackTrace method of Java is useful for handling exceptions and errors during development. It tells you the exact line number in…

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…

How to Perform IP Address Lookup with Google Sheets

Websites can determine the visitor's geographic location using their IP address and serve more relevant content. For example, a weather…

The Best Online Tools To Know Everything About a Website

How do I contact the owner of a website? Where is a particular website hosted? What other websites are hosted on that same server? Is the…

How to Copy a Formula Down an Entire Column in Google Sheets

You are working inside a Google Spreadsheet where a formula needs to copied down to the last row of the sheet. You also need the formula to…

Let People Quickly Save your Events on their Calendars

You are organizing an online event - maybe a meeting on Zoom or a training session hosted on Google Meet - and you would like the attendees…

Awesome Mac Apps and Utilities - 2021 Edition

Whether you are a new Mac user or a seasoned veteran looking to do even more amazing things on your Mac, check out this updated collection…

How Spammers Avoid the Gmail Spam Filter through Google Forms

Gmail is very effective at filtering spam emails but spammers seem to have figured out a new way to bypass the spam filters and send emails…

The 101 Most Useful Websites on the Internet

Here are the most useful websites on the Internet that will make you smarter, increase productivity and help you learn new skills. These…

How to Learn Regular Expressions

Regular Expressions, or RegEx, are used for searching patterns in text. For instance, a RegEx like iP(hone|ad|od)s? will find mentions of…

How to Use Formulas with Google Form Responses in Sheets

When people submit your Google Form, a new row is inserted in the Google Sheet that is storing the form responses. This spreadsheet row…