How-to Guides - Page 1 of 128

The best Mac apps to boost productivity and get things done faster on your Mac OS.

Your documents in Google Docs can now be organized into tabs and sub-tabs. While the multi-tab feature will make navigation easier, it also impacts how you work with documents in Google Apps Script.

The writing tools in Apple Intelligence let you rewrite emails and other text in a more professional or friendly tone. And you can quickly launch the writing tools with a keyboard shortcut on your Mac.

Learn how to generate software license keys and verify them using a Crypto API. The keys can be activated offline and do not require a database.

Learn how to create a simple payment page and accept payments on your website using Zoho Payments. Customers can pay you with UPI, and Credit Cards.

Export your WooCommerce customers email, name and address to Google Sheets with Apps Script. The script copies data from the WooCommerce customers table to sheets.

This guide will walk you through the process of restoring your GitHub repository to a specific commit using Git commands.

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.

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 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.