Posts tagged with: google-sheets

Learn about several ways to run Google Apps Scripts in Google Sheets and when to use each method.

Learn how to programmatically activate a sheet using Apps Script.

Learn how to add links to a cell in Google Sheets using Apps Script.

Stay on top of important dates with minimal effort! This tutorial shows you how to receive timely event reminders using Google Sheets and Apps Script.

Learn how to use ARRAYFORMULA with custom functions in Google Sheets to process entire columns efficiently

Tired of manually resizing rows and columns in Google Sheets? Learn how to automate this using Apps Script!

A macro is a simple way to automate repetitive tasks in Google Sheets. Using a macro, you can record a set of actions and then reuse them in the future with just a single click.

Instead of inserting charts manually, you can use Macros to automate this process.

Automate reminders for recurring annual events using Google Sheets and Calendar

Learn how to convert Excel to Google Sheets using Apps Script and then import data from the converted spreadsheet into a master Google Sheets spreadsheet!

Learn how to use the onSelectionChange() trigger to detect when the user selects a new range in Google Sheets.

In this post, I'll teach you how to automatically email a Google Sheet as as a PDF attachment from within Google sheets itself.

Learn how to use Google Sheets and email reminders to remember birthdays.

Learn how to build a guessing game in Google Sheets using Apps Script.

Learn how to build custom user interfaces like alerts, prompts, sidebars, etc. in Google Sheets using Google Apps Script.

Learn how to create clickable buttons in Google Sheets using Google Apps Script.

Learn how to make your Google Sheets spreadsheet interactive using checkboxes.

Learn how to clear the contents, formatting, data validations, etc. in a range using Apps Script.

A comprehensive guide on converting Google Sheets to PDF, Excel, CSV, TSV, ODS or HTML using Apps Script

Learn how to use Apps Script to create a slide in a Google Slides presentation for every row in a Google Sheets spreadsheet.

Learn how to automate parts of your content creation workflow using Apps Script.

Learn how to create a new sheet for each row in a Google Sheets spreadsheet using Apps Script.

A custom dialog can be used to build custom prompts, alerts or other dialogs in Google Sheets.

Custom menus in Google Sheets make it easy for end users to access the functionality that you've developed using Google Apps Script. Learn how to create custom menus in Google Sheets.

A custom sidebar can be used to build your own user interfaces (such as data entry forms) within Google Sheets.

Learn how to build a simple app to email notes to yourself from your phone using Google Sheets, Google Forms and Google Apps Script.

Learn how to enable autocomplete for your custom functions when you use them within formulas in Google Sheets.

Did you know there is an easy way to enter the same value in every cell of a Range in Google Sheets using Apps Script?

Learn how to build a simple expense report approval workflow using Google Forms, Google Sheets and Google Apps Script.

In this tutorial, I'll show you how to export a list of your Drive files to a Google Sheets spreadsheet.

Learn how to automate the "find and replace" feature in Google Sheets using Apps Script.

Determine which menu item was selected from a custom menu in Google Sheets using a single handler function.

Learn how to freeze rows and columns in Google Sheets using Apps Script.

Automatically generate Google Slides presentations using data from a Google Sheets spreadsheet.

Learn how to create a custom function in Google Sheets that automatically identifies the email provider (Gmail, Microsoft 365, etc.) from any email address.

Learn how to create your own formulas in Google Sheets to get the name of the spreadsheet and the sheets it contains.

Learn how to hide a sheet, or show a hidden sheet in Google Sheets using Apps Script.

In Google Sheets, you can use Apps Script to hide rows where a cell has a specific value.

In this tutorial, you'll learn how to write a custom function to convert a string to Proper case in Google Apps Script.

Learn how to write a custom function to get the HTML color code (also known as a Hex code) of a cell's background color.

Learn how to automatically import CSV files from a URL or from Google Drive into Google Sheets using Apps Script.

Learn how to make a table in Google Sheets that is less error prone and is more effective at conveying information.

Learn how to make your custom function know which cell it is being run from.

Learn how to use the throw statement to inform users that an error has occurred in a custom function.

Learn how to insert an image into a cell in Google Sheets using Apps Script.

Learn how to iterate through every cell in a range in Google Sheets using Apps Script

Learn how to iterate through rows in a Google Sheets spreadsheet using Google Apps Script and take some action on each row.

Learn how to send personalized emails from Google Sheets using Mail Merge.

Learn how to automatically merge adjacent cells that contain the same value in Google Sheets using Apps Script

Are you going to win a car or a goat? Learn how to use simulation and Google Sheets to solve a world famous problem!

Learn how to use Google Sheets and Apps Script to receive an email every morning with a motivational quote.

This tutorial provides a comprehensive overview of named ranges in Google Sheets and how to use them with Google Apps Script.

Learn how to build a navigation menu in Google Sheets to make it easy for users to find and open the right sheet.

A pop up alert message is used to display important information that the user must pay attention to. Learn how to display pop up alert messages in Google Sheets using Google Apps Script.

Learn how to build radio-button-like functionality in Google Sheets using Google Apps Script.

A range represents a single cell or a group of adjacent cells in your spreadsheet. In this tutorial, you'll learn about what ranges are and how to use them.

This tutorial will walk you through several ways to read data from and write data to your Google Sheets spreadsheet using Google Apps Script.

Learn how to rename a sheet in Google Sheets using Apps Script.

In this tutorial, I'll describe how to return values, errors and arrays from a custom function.

This tutorial will teach you how to send an email for every row in a Google Sheet.

A comprehensive guide on sending emails from Google Sheets.

If you've worked in any organization of any size, you've probably had to put together and send reports on a regular basis to your team. In this post, I'll show you how to automate sending emails from Google Sheets based on a schedule.

Learn how to automatically send email notifications whenever your Google Sheets spreadsheet is edited.

Learn how to send HTML email from Google Sheets using Apps Script. I'll also show you how to create the HTML email template using Gmail and Google Docs.

Learn how to view all of the formulas in your Google Sheets spreadsheet at once.

Learn how to build a 5-star rating system in Google Sheets using a custom function written with Google Apps Script.

Streamline data entry and minimize data entry errors by embedding a Google Form in a Google Sheets spreadsheet using Google Apps Script.

Learn how to build Tic Tac Toe in Google Sheets using Apps Script.

A toast is a notification that provides some contextual information to the user in an unobtrusive manner. Learn how to display toast notifications in Google Sheets using Google Apps Script.

Triggers enable you to automate your tasks and workflows in Google Sheets. In this article, you'll learn more about triggers, how they work and how to create them.

Learn how to use prompts to get user input in Google Sheets.

I'm writing a series of posts to explain basic coding concepts using Google Sheets. In this post, I will explain what a value is and I will also introduce the concept of a data type.

Learn how to implement a simple website monitoring solution using Google Sheets and Apps Script.

Learn how to insert, remove and work with checkboxes in Google Sheets using Google Apps Script.

Learn how to efficiently write multiple rows of data to a Google Sheets spreadsheet using Apps Script.

Learn how to write a custom function for Google Sheets using Apps Script.