Digital Inspiration - Tech Tips, Tutorials & How-to Guides

Adding a custom menu in Google Sheets, Docs, Slides, and Forms using Google Apps Script is straightforward.
As an illustration, the following code snippet adds a custom menu to the parent Google Sheet that reveals the spreadsheet name upon clicking.
The above code defines two functions: onOpen which executes when the app opens, and showName which is triggered when the menu item is clicked....

The Mail merge add-on lets you send personalized emails to multiple recipients in one go. The emails are always sent via your Gmail account or your Google Workspace email address. Google also imposes a limit on the number of emails you can send per day...

Google Sheets offers a built-in SUBSTITUTE function that can can find and replace a specific text in a cell with another value. For instance, you can use =SUBSTITUTE("My favorite color is red", "red", "blue") to replace the text red in the string with...

Prefilled Google Forms, where some of the fields in the form are pre-populated with answers you already have, make the process of filling out your forms easier and faster.
Your contacts are more likely to fill out the form as it takes less time for them to complete the remaining fields....