How-to Guides - Page 2 of 128

An Improved SUBSTITUTE Function for Replacing Multiple Values in Google Sheets

The SUBSTITUTE function in Google Sheets lets you find and replace a specific text value in a cell with another value. If you need to replace multiple values in a string with different values, you'll need to nest multiple SUBSTITUTE functions which can be cumbersome.

How to Search Emails in Gmail by Specific Time

Learn how to perform a date range search in Gmail and find email messages that were sent or received during a specific date and time

How to Extract Email Addresses from Gmail Messages

Learn how to extract email addresses and names from email messages in your Gmail account and import the email directory into Google Contacts or Outlook address book

How to Move Files Uploads from Google Forms to Specific Folders in Google Drive

Learn how to move uploaded files from Google Forms to a specific folder in Google Drive. You can also rename the files based on the form responses

How to Add Password to PDF Documents in Google Drive

Password protect PDF documents generated from Google Sheets. Add unique passwords to each PDF file and save them securely to Google Drive or send as email attachments.

How to Request UPI Payments with Google Forms

The customer places an order with Google Forms and the bill amount is calculated automatically based on the selected items. A customized UPI QR Code is generated to make the payment.

How to Access Secrets from Google Secret Manager using Apps Script

This detailed guide explains how you access your passwords, API keys and other sensitive data stored in the Google Secret Manager with Google Apps Script.

How to Search Google Drive Like a Pro!

How to Email Screenshots of Google Sheets on a Schedule

How to capture screenshots of Google Sheets and send the images via email automatically on a schedule to keep your team updated with the latest data.

How to Create Multiple Sub-folders in Google Drive Automatically

How to automatically create multiple sub-folders in Google Drive for each student and their subjects using Google Sheets and Document Studio.

How to Schedule Form Availability and Limit Submissions in Google Forms

Learn how to restrict the number of responses that a Google Form can accept. You can also specify a closing date for your Google Forms or schedule them to open on specific days

How to Send Email Reminders for Google Forms Automatically

Learn how to set up automatic send emails reminders for events created in Google Forms. The personalized reminders are sent to people who have filled out a form, ensuring timely notification as the event date approaches.

How to Automatically Copy Google Forms Responses to any other Spreadsheet

Learn how to automatically copy Google Form responses to a Microsoft Excel or Zoho Sheet when a new form response is submitted. You can also copy the form responses to multiple Google Sheets.

How to Verify API Keys for Gemini AI and OpenAI with Google Apps Script

Learn how to verify API keys for Google Gemini AI and OpenAI using Google Apps Script.

How to Send Confirmation Emails with Google Forms

How to auto-send emails to the person when submit a Google Form. The autoresponder email message can contain a custom note and a copy of the form answers.

How to Find the Wi-Fi Password of your Current Network

How to recover the forgotten Wi-Fi password on Windows, Mac, and Linux computers.

How to Automatically Rename Files in Google Drive with Apps Script and AI

Quickly rename files in Google Drive with Apps Script and Google Gemini AI. The script will automatically rename the files with a descriptive name based on the image content.

How to Send Google Forms Responses in an Email Message

How to send Google Forms response in an email message after a respondent submits the form. You can send a copy of the form answers to the submitter as well.

The Best Google Add-ons for Docs, Sheets, Slides and Google Forms

How to Write a Successful Blog

Learn how to write a popular and successful blog with these tips and advice from India's first professional blogger.

PR Hacks for Media Coverage - How to Pitch Journalists and Influencers with Mail Merge

Mail Merge for Gmail is the ultimate journalist outreach tool for Marcom and PR professionals. Send personalized and targeted email pitches and press releases to your media contacts with Gmail.

Conditional Email Notifications with Google Forms - Route Responses to Different Email Addresses

How to setup conditional email notifications in Google Forms. This powerful feature allows you to route form responses to different email addresses based on form answers or choices made by respondents.

How to Save Password Protected PDF Attachments from Gmail to Google Drive

Learn how to save password protected PDF attachments from your Gmail to Google Drive automatically. The PDF files will be saved to Google Drive as unencrypted PDF documents that can be opened without entering the password.

How to Send Google Forms with Pre-filled Answers

How to pre-fill answers in Google Forms using data from a Google Sheet and send the pre-populated Google Forms as personalized emails.

How to Send Base64 Images in Email with Google Apps Script

Gmail will not render base64 images embedded inside HTML emails but with Google Apps Script, you can use blobs to send the base64 encoded images