Digital Inspiration

How to Get the Permanent URL of an Email Message in Gmail with Apps Script

All email messages in your Gmail inbox have a permanent web address and you can add this URL to your bookmarks to quickly access that…

How to Import Lodash in your JavaScript Projects for Lowest Bundle Size

Lodash is an extremely popular JavaScript library that provides a lot of useful functions for working with strings, arrays and objects in…

How to Change the Date Format in Google Sheets

Dates in Google Sheets are internally stored as numbers and the value is equal to the number of days since 30th December 1899, midnight…

Make all Shapes the Same Size in Google Slides

Microsoft PowerPoint has this really useful feature that lets you to easily resize multiple shapes in a slide to the same size. You can…

Useful Regular Expressions for Validating Input in Google Forms

Your organization has a few vacant positions and you are planning to use Google Forms to prepare a pre-interview questionnaire for job…

Improve Performance of Google Apps Script with Memoization

A folder in Google Drive contains a bunch of CSV files and you are required to write a Google Script to find a particular value in the CSV…

Find Product Prices in Google Sheets with Vlookup and Match Functions

You run a coffee shop and you are looking for a spreadsheet formula to quickly look up prices of the product that your customer has ordered…

How to Write a Successful Blog

In 2004, I left the corporate world and started a tech & how-to blog called Digital Inspiration . I have been blogging for more than 1…

How to Request Payments with Stripe Checkout and Google Sheets

Stripe payment links make it easy for you to accept credit card payments from customers anywhere in the world without even having a website…

How to Delete Blank Rows from Tables in your Google Documents

The Document Studio add-on helps you generate Google Documents from data in Google Sheets and Google Form responses. You can create a…

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 Request Payments with Razorpay and Google Sheets

Razorpay is a popular payment gateway in India that allows you to accept online payments from customers anywhere in the world. Your…

How to Share Files in Google Drive with Multiple Users

The Google Drive API makes it easy to share files and folders with other users programmatically with the help of Apps Script. For instance…

Useful npm Tips and Tricks that Developers Should Know

Node Package Manager, or npm, is a tool to install and manage JavaScript packages in your project. And if you have Node installed on your…

Essential Date Functions for Google Sheets

Dates are internally stored as sequential serial numbers in Google Sheets. This serial number represents the number of days elapsed since…

How to Convert HTML to PDF with Google Script

With Google Apps Script, you can easily convert any HTML content into a PDF file. The converted PDF file can be either saved to a folder in…

How to Create a Telegram Bot for Sending Notifications using Google Apps Script

Would you like to receive notifications in your Telegram messenger when a new form response is submitted in Google Forms. Or maybe send a…

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…

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…