How to specify a fallback or default value in a mail merge template

If not all fields in your spreadsheet are filled you might want to specify a default value in your template instead of just showing an empty value.

A normal mail merge token looks like this {{ColumnName}}

or if it contains spaces:

{{ ["Column Name"] }}

This will insert the value found in the column called 'ColumnName' (or 'Column Name' respectively).

If the cell is empty it will result in an empty value being inserted. If you instead would like a different fallback value to be inserted simply specify the token like this:

{{ ColumnName | default: 'Default value' }}

or if it contains spaces

{{ ["Column Name"] | default: 'Default value' }}