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!

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 Email Spreadsheets Automatically on a Recurring Schedule

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

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

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!

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.

How to Use Google Sheets with D3.js and Google Visualization

How to Make Pixel Paintings with Google Spreadsheets

How to Get Hidden and Filtered Rows in Google Sheets with Google Script

Convert Numbers to Words using Indian Numbering in Google Sheets

Use a custom Google Sheets function to convert numbers to words in Indian Rupees using lakhs and crores grouping.

Track Coronavirus (COVID-19) Cases in India with Google Sheets

The Coronavirus (COVID-19) tracker uses sparklines in Google Sheets to help you visualize the spread of the coronavirus outbreak across different states of India over time.

How to Import MailChimp Subscribers to Google Sheets

Learn how to import subscribers' email addresses from your MailChimp mailing lists into Google Sheets and Google Contacts.

Convert Google Documents and Spreadsheets with Apps Script