How-to Guides - Page 3 of 128

Create a BMI Calculator using Google Forms and Google Sheets

Build your own BMI calculator app with Google Forms. The BMI report is generated in Google Sheets and the user receives an email with the BMI score.

SlideCasts - Sync YouTube Videos with your Google Slides Presentation

How to Transcribe Audio and Video Attachments in Gmail

Learn how to automatically transcribe audio and video files in Gmail messages with the help of OpenAI speech recognition API and Google Apps Script

How to Send a Welcome Email to Google Form Respondents

This tutorial explains how you can send a welcome email automatically to people who fill your Google Form. You can also attach files from Google Drive to the email notification.

How to Create Zoom Meetings with Google Script

How to use the Zoom API to automatically create and schedule Zoom meetings with Google Apps Script

How to Sort Google Sheets Automatically with Apps Script

If you are working with a Google Sheet that has a large number of tabs, it can be difficult to find the sheet you need if they are not organized properly. Use Google Apps Script to sort sheets automatically

Find Free Udemy Courses with Google Sheets and the Udemy API

Learn how to use the Udemy API with Google Apps Script to find free programming courses on Udemy on any topic.

New MX Records for Using Gmail with Google Workspace

You need to add MX records to your Google Workspace domain to send and receive emails with Gmail. And now, the MX records are simpler.

How to Use Conditional Logic in Google Documents

Learn how to add conditional content in Google Docs for automated document generation. Paragraphs, images, tables and other section of your document can be hidden or displayed when certain criteria is met.

Prevent your Gmail Email Messages from Getting Rejected as Spam

Prevent spammers from forging the “From” field of their bulk messages with your email address by using SPF (Sender Policy Framework) to authenticate your Google Workspace domain.

How to Make Phone Numbers Callable in Google Sheets and Docs

Learn how to create clickable phone numbers in Google Sheets and Google Docs for easy dialing. When someone clicks on the phone number in the spreadsheet, it will open the dialer on their mobile phone and initiate dialing of the specified phone number.

Useful NPM Tips and Tricks for Developers to Boost Productivity

This is a collection of useful npm tips and tricks that every developer should know. Learn how to automate tasks, check for vulnerabilities, manage dependencies, and more, to increase your productivity and efficiency.

Automating the Creation of Multiple Folders in Google Drive

Effortlessly create multiple folders in Google Drive for your classroom students with Apps Script

Lite YouTube Embeds - A Better Method for Embedding YouTube Videos on your Website

Learn how to efficiently embed YouTube videos on your website by adopting a quick and lightweight method that triggers the video to load only when requested, resulting in smaller web page sizes and enhanced core web vitals scores.

How to Efficiently Read Email Messages with the Gmail API and Apps Script

How to read email messages with the Gmail API and the UrlFetch service of Apps Script

Convert Google Docs and Google Sheets with Apps Script

The 101 Most Useful Websites on the Internet

The most useful websites on the Internet that will make you smarter, increase productivity and help you learn new skills

Useful FFmpeg Commands for Working with Audio and Video Files

FFmpeg is a versatile command-line tool for converting audio and video files. Here are some useful FFmpeg commands you should know.

Upload Files from Google Drive to Google Cloud Storage with Google Apps Script

This tutorial describes how you can upload files and folders from your Google Drive to a bucket in Google Cloud Storage using Google Apps Script.

Formulas in Google Sheets Disappear When New Rows Are Added - The Solution

The formulas in Google Sheets may get deleted when new rows are added in the sheet or when new responses come in through Google Forms. The fix is simple!

How to Use Google Docs as a Code Runner

There is a way to use Google Docs as a programming IDE and run JavaScript code inside the editor.

How to Send Personalized Text Messages from Google Sheets

Send personalized text messages in bulk from Google Sheets using your favorite SMS service

Find Out How Much Traffic a Website Gets

Learn about the best online tools that will help you find out the search traffic of any website, including your competitor's domain.

How Teachers can Email Parents of Students from Google Forms

Learn how teachers can automatically send emails to the parents of a student on behalf of the school after they submit a Google Form.

How to Make Personalized Place Cards with Guest Names

Place cards at weddings and parties can help your guests get to their designated table. The cards can be printed with guest names and table numbers assigned to each guest.