How-to Guides - Page 2 of 128

Learn how to convert Google Slides into high-resolution PNG images using Google Apps Script. Choose between the Google Slides API and the Google Drive API based on your requirements.

Your mobile phone may not work in another country if the frequency bands supported by your phone don't match the frequency bands used by carriers in that country.

Use Google Apps Script to search and replace text in Google Documents with regular expressions.

Use AI to improve spam detection in Gmail and find legitimate emails that were mistakenly marked as spam by Google algorithms.

Use Google Apps Script to create a custom menu that will work inside Google Sheets, Google Docs, Slides and Google Forms.

How to send personalized emails using Mail Merge in Google Sheets with SMTP. You can send emails via SendGrid, Postmark, AWS SES, Zoho Mail, or any other SMTP server

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.

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

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

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

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.

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.

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 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 automatically create multiple sub-folders in Google Drive for each student and their subjects using Google Sheets and Document Studio.

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

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.

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.

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

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 recover the forgotten Wi-Fi password on Windows, Mac, and Linux computers.

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.