How-to Guides - Page 7 of 128

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

When you send an email with Google Apps Script, the Gmail API returns a unique ID that you can use to determine the URL of the email message in your sent items.

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

How to correctly include specific functions of the popular lodash library in your web JavaScript project without having to import the entire library.

How to Make Someone Else's YouTube Playlist Your Own

Convert a Google Document into an EPUB File

How to Force Reset Google Workspace Users' Passwords with Apps Script

Learn how the Google Workspace admin can change the Google account passwords of multiple users in their organization automatically with Google Apps Script.

How to Change the Date Format in Google Sheets

You can customize the date format in a Google Sheet with the TEXT function and completely change the way the date and time values are displayed in the worksheet.

Make all Shapes the Same Size in Google Slides

Make all shapes in Google Slides the same size as the height and width of the first shape.

How to Make Your Phone Number Memorable

Useful Regular Expressions for Validating Input in Google Forms

Collection of regular expressions to validate user input in Google Forms quizzes and surveys.

Improve Performance of Google Apps Script with Memoization

How to use JavaScript memoization to optimize and improve the performance of your Google Apps Script code.

Find Product Prices in Google Sheets with Vlookup and Match Functions

How to use the Index and Vlookup functions in Google Sheets with Match and ArrayFormula to lookup product prices that are listed as a table in the spreadsheet.

How to Delete Blank Rows from Tables in your Google Documents

How to remove all blank rows from one or more tables in a Google Docs document with Google Apps Script. You may also delete blank rows from tables in Google Slides.

How to Request Payments with Razorpay and Google Sheets

How to use Google Sheets to generate Razorpay payment links and easily accept payments from customers anywhere in the world!

How to Share Files in Google Drive with Multiple Users

How to Import CSV Files to BigQuery with Google Apps Script

Essential Date Functions for Google Sheets

Master all the important date functions for Google Sheets with working formula examples. Whether you are looking to calculate the number of working days before the project is due or days until your upcoming birthday, this is the place to start.

How to Convert HTML to PDF with Google Script

Learn how to convert HTML files to PDF documents in your Google Drive with the help of Google Scripts and Cloud Functions

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

Learn how to create your own Telegram bot with Google Apps Script and post notification messages from Google Sheets, Forms and other Google apps.

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

How to use the Notion API with Google Apps Script to connect Gmail, Google Forms, and Google Sheets with your Notion workspace.

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

Learn how to sort your data in a Google Sheet in randomized order using Excel formulas and Google Apps Script.

Cannot Install Gmail and Google Drive Add-ons - Troubleshooting Guide

Exceeded maximum execution time Exception in Google Apps Script

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

The Google Sheets function will convert diacritics letters or characters with accents to their simple Latin equivalent. For instance, á or à will change to 'a', ê or ë will be replaced with e and so on.

How to Use Google Text to Speech API

Gmail Sender Icons - A Gmail Addon for Busy People

Quickly identify emails from known domains in the Gmail inbox with their favicons