How to Mail Merge with Outlook and Google Sheets

If you are an Outlook or Microsoft 365 user, you can still use Google Sheets to send personalized emails to multiple people at once with the help of Mail Merge.

How to Create Personalized Images in Bulk with Google Sheets

Learn how to auto-generate personalized images in bulk with Google Sheets. You can create uniqe and personalized business cards, employee badges, student certificats and more with minimal effort.

Emojis in Google Sheets

Learn how to use emojis in Google Sheets and the challenges they pose during conversion of Google Spreadsheets to PDF files.

How to Link Postal Addresses to Google Maps in Google Sheets

Learn how to make postal addresses clickable in Google Sheets with a formula. Create hyperlinks that directly link an addres to Google Maps places.

How to Email Google Sheets Automatically on a Recurring Schedule

Email spreadsheet reports and dashboards on a recurring schedule. You can email entire spreadsheet, specific sheets inside a workbook or even range of cells.

Google Maps Formulas for Google Sheets

Use Google Maps formulas inside Google Sheets to calculate distances, travel time, get driving directions, look up postal codes with reverse geocoding and more!

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.

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

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.

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.

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 Send Personalized Text Messages from Google Sheets

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

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.

How to Auto Format Google Form Responses in Google Sheets

Learn how to automatically preserve the formatting in Google Sheet when new Google Form responses are submitted.

Send WhatsApp Messages with a Google Sheets Function

Learn how to send WhatsApp messages with a Google Sheets function

How to Send WhatsApp Messages from Google Sheets using the WhatsApp API

Learn how to use the WhatsApp API to send personalized messages from Google Sheets to your WhatsApp contacts.

How to Open a Website in New Window from Google Sheets Menu

This tutorial how to open a web page in new window from a menu option in Google Sheets

How to Play an MP3 File in Google Sheets

This tutorial explains how to embed an audio file in Google Sheets and play the MP3 audio when you click the Play button.

How to Auto-Download Podcasts to Google Drive with Google Sheets

You use Google Sheets as your own Podcast Manager that will automatically download your favorite podcasts to Google Drive and instantly sync across all your devices.

How to Generate Dynamic QR Codes to Collect Payments through UPI

This tutorial explains how you can create QR Codes and merchant badges for collecting UPI payments through Google Pay, PhonePe, PayTM, Amazon or any BHIM UPI apps.

How to Use Conditional Formatting in Google Sheets to Highlight Information

Conditional formatting in Google Sheets allows you to apply automatic formatting to cells in spreadsheets that meet certain criteria. Check out some practical examples and master conditional formatting in Google Sheets.

How to Insert Images in Google Sheet Cells

Learn about the different approaches that will help insert images in Google Sheets and understand the reason why you may prefer one approach over the other.

How to Send SMS Messages with Google Sheets and Android Phone

Send personalized text messages to your contacts with the help of Google Sheets and Android phone. The SMS messages go directly from your phone SIM, no third-party SMS service is required.

How to Import PayPal Transactions into Google Sheets

Learn how to easy import transactions from PayPal into Google Sheets with Google Apps Script. You can import standard transactions, recurring subscriptions and donations.

How to Get the Last Row in Google Sheets when using ArrayFormula

How to Extract URLs from HYPERLINK Function in Google Sheets

How to Use Hyperlinks in Google Sheets

How to Create Dynamic Open Graph Images with Google Sheets

Generate dynamic Open Graph images for your website with Google Sheets without requiring Puppeteer. All pages on your website can have their own unique Open Graph images created from a Google Slides template.

How to Request Stripe Payments with Google Sheets

How to use Google Sheets to generate Stripe payment links and request payments in any currency from your customers anywhere in the world!

Convert and Email Google Spreadsheets as PDF Files

How to Change the Date Format in Google Sheets

You can customize the date format in a Google Sheet with the TEXT function and completely change the way the date and time values are displayed in the worksheet.

Find Product Prices in Google Sheets with Vlookup and Match Functions

How to use the Index and Vlookup functions in Google Sheets with Match and ArrayFormula to lookup product prices that are listed as a table in the spreadsheet.

How to Request Payments with Razorpay and Google Sheets

How to use Google Sheets to generate Razorpay payment links and easily accept payments from customers anywhere in the world!

Essential Date Functions for Google Sheets

Master all the important date functions for Google Sheets with working formula examples. Whether you are looking to calculate the number of working days before the project is due or days until your upcoming birthday, this is the place to start.

How to Use Notion with Gmail and Google Sheets using Apps Script

How to use the Notion API with Google Apps Script to connect Gmail, Google Forms, and Google Sheets with your Notion workspace.

Sort by Random - How to Randomize the Order of Rows in Google Sheets

Learn how to sort your data in a Google Sheet in randomized order using Excel formulas and Google Apps Script.

How to Replace Accented Characters (diacritics) with English letters in Google Sheets

The Google Sheets function will convert diacritics letters or characters with accents to their simple Latin equivalent. For instance, á or à will change to 'a', ê or ë will be replaced with e and so on.

How to Convert Column Number (e.g. 28) to Column Letter (e.g. AB) in Google Sheets

Convert column letters (AA) to corresponding numbers, or covert column numbers to A1 notation cell references in Google Sheets and Microsoft Excel.

Google Sheets - Find Values in One Column that are Missing in Another Column

How to compare columns in Google Sheets and highlight cell values that are in one column but missing in another column.

How to Add Options in Google Forms Questions from Google Sheets

Learn how to bulk add options in dropdown lists and multiple-choice questions in Google Form using values from Google Sheets

How to Perform IP Address Lookup with Google Sheets

How to determine the country, city and ISP name of IP addresses in bulk with Google Sheets and IP2Location service.

How to Copy a Formula Down an Entire Column in Google Sheets

Learn how to use the ARRAYFORMULA function in Google Sheets to quickly apply a formula to an entire column in the spreadsheet. The formula is also added to new rows automatically.

How to Use Formulas with Google Form Responses in Sheets

Learn how to add autofill formulas with Google Form responses in Google Sheets. The cell values are automatically calculated when a new Google Form response is submitted.

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

How to Preserve Formatting of Spreadsheet Cells in Mail Merge

You can format the source data in Google Spreadsheet in different colors, fonts and sizes and all your cell formatting will be retained in the email messages.

How to Highlight Duplicates in Google Sheets and Remove

How to quickly highlight cells with duplicate values in Google Sheets using conditional formatting. The duplicate cells can be easily removed from the spreadsheet with Google Script.

Measure Core Web Vitals of your Websites with Google Sheets

Core Web Vitals are a set of metrics defined by Google to help webmasters understand the performance of their websites. You can automate the measurement and tracking of core vitals with Google Sheets.