How-to Guides - Page 1 of 128

How to Import Data from One Google Sheet to Another - Learn with Practical Examples

Learn how to import data from one Google Sheet to another using the IMPORTRANGE and QUERY functions. You can filter data or only import specific rows that meet certain criteria.

How to Create Print-Ready Brochures and Flyers in Multiple Languages

Learn how to automatically generate brochures, PDF flyers or reports in multiple languages. It uses Google Translate for translation and is perfect for reaching an international audience!

How to Automatically Cleanup Revisions in Cloud Run Functions & Firebase

Whether you are running a serverless function on Google Cloud Run or Firebase, you can automatically remove inactive revisions and reduce clutter in your Google Cloud project.

How to Replace Bixby with Google Gemini AI in Samsung Phones

Bixby is the default voice assistant in Samsung Galaxy phones. You can easily replace it with Google Gemini and use the same power button to launch the Google voice assistant.

Essential Mac Apps and Utilities - 2025 Edition

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

Chat faster with AI Chatbots from Chrome's Address Bar

Instantly query any AI chatbot directly from Chrome's address bar and save precious time. Type @plex to chat with Perplexity AI or @claude to talk to Claude AI.

How to Automatically Format Google Form Responses in Google Sheets

Learn how to automatically maintain consistent formatting, styles, and date formats when new Google Form responses are added to your Google Sheets.

How to Work with Document Tabs in Google Apps Script

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.

Create a Keyboard Shortcut for Apple Intelligence Writing Tools on Mac

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.

How to Generate Software License Keys and Verify Them

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.

How to Accept Online Payments with Zoho Payments

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.

How to Export WooCommerce Customers to Google Sheets

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.

How to Rollback Changes to a Specific Commit in Github

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

How to Search Google Images by the Exact Size

Advanced Search Operators to Find Emails in Gmail

How to Convert Google Slides to PNG Images with Google Script

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.

How to Determine if your Mobile Phone will work in Another Country

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.

How to Find and Replace Text in Google Docs with RegEx Search Patterns

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

Find Legitimate Emails in your Gmail Spam Folder with AI and Google Script

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

YouTube Search Tricks - Search YouTube Videos with Simple Commands

How to Add a Universal Custom Menu to Multiple Google Workspace Apps

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

Send Personalized Emails with SMTP and Mail Merge in Google Sheets

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

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