The Array method filter() is used to filter an array based on a set of conditions.
Learn how to programmatically activate a sheet using Apps Script.
Learn how to iterate through every cell in a range in Google Sheets using Apps Script
The Array method every() is used to check if every value in an array meets a set of conditions.
The Array method indexOf() is used to find if a value is present in an array. It returns the index where the element is found or -1 if it is not found in the array.
The Array method forEach() is used to execute a function for every element in an array. It is also referred to as the forEach loop.
Learn how to build a simple expense report approval workflow using Google Forms, Google Sheets and Google Apps Script.
Instead of inserting charts manually, you can use Macros to automate this process.
Tired of manually resizing rows and columns in Google Sheets? Learn how to automate this using Apps Script!
Creating triggers using the Apps Script editor UI can be inefficient if you're creating many triggers. Learn how to use Apps Script to programmatically create triggers!
Learn how to add links to a cell 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 build custom user interfaces like alerts, prompts, sidebars, etc. in Google Sheets using Google Apps Script.
A custom dialog can be used to build custom prompts, alerts or other dialogs in Google Sheets.
Learn how to freeze rows and columns in Google Sheets using Apps Script.
Learn how to efficiently write multiple rows of data to a Google Sheets spreadsheet using Apps Script.
The Array method concat() merges two or more arrays into a single array
Learn how to view all of the formulas in your Google Sheets spreadsheet at once.
A custom sidebar can be used to build your own user interfaces (such as data entry forms) within Google Sheets.
A macro is 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.
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 radio-button-like functionality in Google Sheets using Google Apps Script.
Learn about several ways to run Google Apps Scripts in Google Sheets and when to use each method.
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 insert, remove and work with checkboxes in Google Sheets using Google Apps Script.
The Array method splice() is used to change an array by removing elements from it and/or adding elements to it.
Strings are text values and you'll use them a lot while programming. This tutorial covers the basics of working with strings in Google Apps Script.
Learn how to make your Google Sheets spreadsheet interactive using checkboxes.
This tutorial provides a comprehensive overview of named ranges in Google Sheets and how to use them with Google Apps Script.
This tutorial will walk you through several ways to read data from and write data to your Google Sheets spreadsheet 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.
A comprehensive list of keyboard shortcuts for the Google Apps Script editor to help you become more productive while using it.
This page has answers to questions submitted by readers of this blog.
Learn how to fix 404 errors in Web Apps built using Apps Script.
Learn how to create clickable buttons in Google Sheets using Google Apps Script.
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 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.
The Array method unshift() adds elements to the beginning of an array.
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.
The Array method shift() removes an element from the beginning of an array.
Learn how to build a 5-star rating system in Google Sheets using a custom function written with Google Apps Script.
The Array method pop() removes an element from the end of an array.
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 automatically import CSV files from a URL or from Google Drive into Google Sheets using Apps Script.
The Array method push() adds elements to the end of an array.
The Array method sort() sorts the elements in an array.
The Array method reverse() reverses the order of elements in an array.
The Array method join() concatenates the values in an array into a single string.
Learn how to automatically sort your Google Form's responses so you'll always see the most recent ones at the top.
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 send email notifications whenever your Google Sheets spreadsheet is edited.
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 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 send personalized emails from Google Sheets using Mail Merge.
This tutorial will teach you how to send an email for every row in a Google Sheet.
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.
In this post, I'll teach you how to automatically email a Google Sheet as as a PDF attachment from within Google sheets itself.
A comprehensive guide on sending emails from 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 build a guessing game in Google Sheets using Apps Script.
Learn how to use prompts to get user input in Google Sheets.
Learn how to authorize an Apps Script and the security and privacy considerations to keep in mind while doing so.
Learn how to build a simple mood tracking app using Google Sheets.
Apps Script is my superpower and it can become yours too! I am going to teach you to code using Google Sheets and Apps Script. I’m not going to teach you every single coding concept but I'll teach you enough to build simple applications.
Apps Script is a coding platform in G Suite that can be used to build simple applications on top of existing apps such as Sheets, Docs, Forms, etc.
A loop is a piece of code that runs a set of statements multiple times. Each run is called an iteration. There are two common types of loops in Apps Script: For and While.
An array is a special type of object that is used to store a list of values. You will use arrays extensively while working with Google Sheets using Apps Script.
Objects are used to organize the values in your Apps Script program that are related to one another.
Variables are used to store values. Constants are just like variables except you cannot change their value after assignment.
Learn how to use IF-ELSE statements in your Apps Script code to implement conditional logic.
Values are the data used by your program. There are six types of values in Apps Script. Operators are used to perform operations on values.
Learn how to write a custom function for Google Sheets using Apps Script.
Learn how to create an Apps Script.
Learn how to use Google Sheets and email reminders to remember birthdays.
Why I started a blog to teach spreadsheet users to code.