How-to Guides - Page 8 of 128

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

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 the Notion API with Google Apps Script to connect Gmail, Google Forms, and Google Sheets with your Notion workspace.

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

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.

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

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

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

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

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

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.

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

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

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.

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

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

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

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

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.