The forEach() loop in Apps Script

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 because it is a common way to loop through every element of the array to take some action on each element.

Syntax

array.forEach(callbackFunction)

Parameters

callbackFunction (required):

  • This is the function that will be executed once for every element in the array.

The callbackFunction can accept three arguments:

  • value (required): The current value being processed.

  • index (optional): The index of the value in the array.

  • array (optional): The original array that the forEach() method was called on.

Return value

The forEach() method will return undefined.

Examples

Example 1: Log the elements of an array

Example 1.1

In the code below, the function logValue(value) is the callback parameter in the forEach() method. This function is executed once for every element in the array colors and it logs that value.

function forEachEx1_1() {
 var colors = ["red", "blue", "green", "black", "orange", "purple"];
 colors.forEach(logValue);
}

function logValue(value) {
 Logger.log(value);
}

Output

Screenshot of the execution log in the Apps Script editor.

Example 1.2

Instead of defining the function logValue() separately and then passing it as a parameter, you can also define it in-line. The code below shows you how to do this.

function forEachEx1_2() {
 var colors = ["red", "blue", "green", "black", "orange", "purple"];
 colors.forEach(function(value) {
   Logger.log(value);
 });
}

Output

Screenshot of the execution log in the Apps Script editor.

Example 2: Log the elements of an array along with their index

The code below logs the elements in the array colors along with each element's index. Here, we use the required parameter of the callback function which is the value and an optional parameter which is the index. When the callback function is executed for an element, the elements value and index will be passed to it and this information is logged.

function forEachEx2() {
var colors = ["red", "blue", "green", "black", "orange", "purple"];
colors.forEach(function(value, index) {
  Logger.log("The value at index " + index + " is " + value + ".");
});
}

Output

Screenshot of the execution log in the Apps Script editor.

Example 3: Access the array inside the callback function

In the code below, we use the required parameter of the callback function which is the value and two optional parameters:

  • index: This is the index of the value in the array.

  • array: The original array itself.

In each iteration, the code will log the value, its index and the original array.

function forEachEx3() {
var colors = ["red", "blue", "green", "black", "orange", "purple"];
colors.forEach(function(value, index, array) {
  Logger.log("The value at index " + index + " is " + value + ".");
  Logger.log(array); //Logs the original array
});
}

Output

Screenshot of the execution log in the Apps Script editor.

Example 4: The forEach method will skip undefined values in an array

If an array has an undefined value, the forEach() method will skip it and the callback function will never be called.

In the code below, the array colors has an undefined value between the elements "red" and "green". When you use the forEach() method, this element will be skipped and the callback function will not be called for this value.

Therefore, when you see the logged output, you will not see an undefined value. The code also increments a counter called count every time the callback function is called. This counter will also not be incremented for this undefined value. Therefore, the value of the counter at the end of the forEach() loop will be one less than the length of the array colors. This discrepancy arises because the forEach() method skips the undefined value in the array.

function forEachEx4() {
 var colors = ["red",, "green", "black", "orange", "purple"];
 var count = 0;
 colors.forEach(function(value) {
   Logger.log(value);
   count++;
 });
 Logger.log(colors.length);
 Logger.log(count);
}

Output

Screenshot of the execution log in the Apps Script editor.

Example 5: The forEach method will always return undefined

function forEachEx5() {
 var colors = ["red",, "green", "black", "orange", "purple"];
 var count = 0;
 var result = colors.forEach(function(value) {
   Logger.log(value);
 });
 Logger.log(typeof result);
}

Output

Screenshot of the execution log in the Apps Script editor.

Example 6: You cannot break out of a forEach() loop

Unlike the for loop or the while loop, you cannot break out of a forEach loop using the break keyword. The forEach() method will always process every element in an array that is not undefined. The only way to break out of the forEach loop during execution is by throwing an error. This is not advisable. If your use case needs the ability to break out of a loop, please do not use the forEach loop.

Conclusion

In this tutorial, you learned how to use the forEach() method of an array to take some action on each of its elements. The forEach() method is also known as the forEach() loop because it is a convenient way to loop through every element in an array.

Master Google Sheets Automation

Sign up to receive exclusive Automation tips and tutorials!
I'll send you actionable tips on automating tasks with Google Sheets and coding with Apps Script. You'll also be notified whenever new content is published.
PLUS: Get instant access to my Birthday Reminder Template! 🎂
By signing up you agree to the Privacy Policy & Terms.

Have feedback for me?

I'd appreciate any feedback you can give me regarding this post.

Was it useful? Are there any errors or was something confusing? Would you like me to write a post about a related topic? Any other feedback is also welcome. Thank you so much!