How-to Guides - Page 7 of 128

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

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

How to change the font family and font styles of multiple Word documents in your Google Drive with Apps Script

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

Use Google Apps Script to search and replace text and hyperlinks in Google Documents.

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

Convert column letters (AA) to corresponding numbers, or covert column numbers to A1 notation cell references in Google Sheets and Microsoft Excel.

Google Documents - How to Replace Text in Header and Footer

How to find and replace text in the Word document's header and footer section using the Google Document API.

How to Add a Watermark in Google Documents

How to insert a watermark in your documents in Google Docs. You may use watermarks to add logo images or any text that appears faint and washed out in the background of every page of your Word document.

Create React App with Multiple Entry Points

How to build a multi-page React application with multiple entry points using Create React App without ejecting.

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

How to compare columns in Google Sheets and highlight cell values that are in one column but missing in another column.

How to Improve the Security of your WordPress Blogs

Calculate the Battery Level and Charging Status with HTML5

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

Monitor the availability of Covid-19 Vaccines in your city and get email alerts when vaccine doses are available for people above 18 years of age.

Find Google Sheets Linked to your Google Forms

How to find the destination Google Spreadsheet and Sheet that is storing responses of the current Google Form with Google Apps Script

How to Add Options in Google Forms Questions from Google Sheets

Learn how to bulk add options in dropdown lists and multiple-choice questions in Google Form using values from Google Sheets

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

Print the Stack Trace and the function call flow of your JavaScript and Google Apps Script programs.

How to Perform IP Address Lookup with Google Sheets

How to determine the country, city and ISP name of IP addresses in bulk with Google Sheets and IP2Location service.

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

Learn how to use the ARRAYFORMULA function in Google Sheets to quickly apply a formula to an entire column in the spreadsheet. The formula is also added to new rows automatically.