Make.com & n8n Function Reference (59 functions)

Make.com functions

addDays() — Returns a new date with the given number of days added
formatDate() — Converts a date into text using Moment.js-style tokens such as YYYY, MM, DD, HH and mm.
parseDate() — Converts text into a date by describing how the text is written with format tokens.

average() — Returns the arithmetic mean of the numbers in an array or of the values passed.
ceil() — Rounds a number up to the nearest whole number
formatNumber() — Formats a number as text with a fixed number of decimals
max() — Returns the largest number
round() — Rounds a number to the nearest whole number.
sum() — Adds up all numbers in an array or the values passed.

capitalize() — Converts the first character of the text to uppercase and leaves the rest unchanged.
indexOf() — Returns the 0-based position of the first occurrence of a value in the text, or -1 when not found.
lower() — Converts all characters in the text to lowercase.
replace() — Replaces every occurrence of the search value (text or regular expression) with the replacement.
split() — Splits a text into an array at every occurrence of the separator
substring() — Returns part of the text from a 0-based start position up to (not including) the end position.
trim() — Removes whitespace from the beginning and end of the text.
upper() — Converts all characters in the text to uppercase.

contains() — Returns true if the text contains the value, or if the array contains an element equal to the value
if() — Returns one of two values depending on whether the condition is true.
ifempty() — Returns value1 if it isn't empty, otherwise value2
switch() — Compares an expression against a list of values and returns the matching result, or the else value.

deduplicate() — Removes duplicate values from an array, keeping the first occurrence.
first() — Returns the first element of an array.
join() — Concatenates all array elements into one string, separated by the given separator.
last() — Returns the last element of an array.
length() — Returns the number of items in an array, or the number of characters in a text.
map() — Returns an array of the values of a key from an array of collections, optionally filtered by another key.
sort() — Sorts an array

get() — Reads a value from a collection using a dot-separated path, or an array element by its 1-based position.

DateTime.fromISO() — Parses an ISO 8601 date string into a Luxon DateTime so you can format or calculate with it.
plus() — Returns a new Luxon DateTime shifted forward by a duration
toFormat() — Formats a Luxon DateTime as text using tokens like yyyy, MM, dd, HH and mm.

Math.max() — Returns the largest of the numbers given
parseInt() / Number() — Converts a numeric string into a number
toFixed() — Rounds a number to a fixed number of decimals and returns it as a string.

new URL() — Parses a URL string so you can read parts like hostname, pathname, origin and searchParams.
match() — Searches a string with a regular expression and returns an array of matches, or null.
replaceAll() — Replaces every occurrence of a substring
split() — Splits a string into an array at each occurrence of the separator.
toLowerCase() — Returns the string with every letter converted to lowercase.
toUpperCase() — Returns the string with every letter converted to uppercase.

includes() — Returns true if the string contains the substring, or the array contains the value
?? (nullish coalescing) — Returns the fallback only when the value is null or undefined.
Ternary operator ? : — A one-line if/else that returns one of two values.

Array index [0] — Reads an array element by its 0-based position
at() — Reads an element by position and supports negative indexes, so at(-1) is the last element.
filter() — Returns a new array containing only the elements for which the condition is true.
find() — Returns the first element that matches the condition, or undefined if none does.
length — Property that returns the number of characters in a string or items in an array
map() — Returns a new array with the result of the function for every element.
reduce() — Reduces an array to a single value, such as a total, by carrying an accumulator through every element.
sort() — Sorts an array in place

JSON.parse() — Converts a JSON string into a real object or array.
JSON.stringify() — Converts an object or array into a JSON string
Object.keys() — Returns an array of an object's property names.
$json dot notation — Reads fields of the current item
?. (optional chaining) — Returns undefined instead of throwing an error when a value along the path is missing.