For Loop Using Dynamic Set
What Does This Code Snippet Do? Unlike the incremental For Loop where you specify the number of iterations you want the loop to execute…
For Loop Using Dynamic Set
What Does This Code Snippet Do? Unlike the incremental For Loop where you specify the number of iterations you want the loop to execute…
For Loop Using Increments
What Does This Code Snippet Do? This code snippet is a basic For Loop that takes in a set iteration length and also lets you specify where…
Find the Max Length of Nested Arrays
What Does This Code Snippet Do? This findMaxLengthOfNestedArrays() code snippet takes an array of arrays (aka nested arrays) and calculates…
Find Column Number By Column Header Name
What Does This Code Snippet Do? This getColumnByName() code snippet is a fast and efficient way to quickly identify the Column Index of a…
Filter Out Rows Using Regex
Using Regex Using Regular Expressions allows you to analyze a value and find a match according to some logic. It's a pretty vast topic, so I…
Filter Out Blank Rows
What you'll need Before you can filter anything, you'll need a data set to filter by. More specifically, you'll need a data Array. An array…
Find The Difference Between Two Arrays
Why would you need a find the difference between two Arrays? When you're working with multiple data sets, you might run into a situation…
Get Unique Values from Array
What is a Unique Array? Just as straight forward as it sounds, it's an Array where all of the values within it are unique - meaning, there…
Converting JSON into a flat Array
This code snippet helps you convert an object into a flat array that you can use to import into a Google Sheet. Important Note: This snippet…
Converting an Object Array into a flat Array
This code snippet helps you convert an array of objects into a flat array that you can use to import into a Google Sheet. This is pretty…
Converting an Array into an Object Array
This snippet helps you convert an array into an object array. Converting an array into an object array is useful when you need to export…
Basic REST API Request Call Using XML
This is a basic REST API call that parses out XML data and returns it back to you. To do a POST request using XML data, check out the Basic…
Basic REST API POST Request Using XML
This how-to guide will cover making a POST request to an API using XML data. For retrieving XML data from an API and parsing it out, check…
Basic REST API POST Request Using JSON
This how-to guide will cover making a POST request to an API using JSON data. For retrieving JSON data from an API and parsing it out, check…
Auto-Sorting a Specific Google Sheet Range
Sorting your Google Sheet using Apps Script is very simple. Firstly, you'll need to decide how you want to sort your data - either by the…
How To Get All Sheets From A Google Sheet Using Apps Script
The first thing you'll need to do is set your spreadsheet as a variable. In the below example, we use the openByUrl() method to do this, but…
Basic REST API GET Call Using JSON
This is a basic REST API call that parses out JSON data and returns it back to you. To do a POST request using JSON data, check out the…
Lookup The Matching Row Index Using a Search Term
This snippet is very helpful when you need to make updates to a specific row in a Google sheet and have an identifier that you can use to…
Converting Columns between a Number or a Letter
When you're scripting in Google Apps Script to automate data in a Google Sheet, you'll be working with Columns a lot. Sometimes you'll get…
Get Data from a Sheet
There are a few different ways to get all of the data from a specific sheet. The fastest way is to use the .getDataRange() method. The only…
Sending Emails Using Apps Script
The built-in libraries in Google Apps Script makes sending emails extremely easy. By default, you have two libraries to choose from: MailApp…
Creating Backup Files of a Google Sheet
There's a few different reasons for creating data snapshots of your Google Sheet. One of them is just to make sure you have a copy of the…
Create a Custom Menu Option
The onOpen trigger is mainly used to add in additional menu options that can help you execute scripts without having to open up your Script…
Auto-Sorting Your Google Sheet
Sorting your Google Sheet using Apps Script is very simple. Firstly, you'll need to decide how you want to sort your data - either by the…