Merge tags
Merge tags are used to refer to dynamic content in Logic Sheet automation. When you use merge tags in fields that accept merge tags, the app will "translate" them into their corresponding values when the workflow is being executed. For example, if you use the merge tag {{range B12}} in an email, the merge tag will be replaced by the value in cell B12 when the email is sent.

Format

Merge tags are all wrapped in double curly braces as in {{merge tag}}. While some merge tags are static, like {{automation name}} and {{spreadsheet url}}, others can be dynamic as you can change them to refer to more specific values.

Dynamic merge tags

Merge tags like {{range A1}}, {{column A}}, and {{form values 1}} are dynamic.
For example, in the merge tag {{range A1}}, you can change the value "A1" into "B10" to make the merge tag refer to the value in cell B10.
In {{form values 1}}, you can change the number 1 into 3 to make it {{form values 3}}, which will refer to the third value of the form submission that was received.

Trigger limits

Some merge tags only work with specific types of triggers. For example, the merge tags {{old value}} and {{new value}} only work with the trigger type "The spreadsheet is edited" because they only exist when there is an editing behavior.

Works with all triggers

{{range A1}}: The value of the range A1 of the worksheet you have selected. You can change the range to refer to any other cell such as {{range B10}} and {{range F9}}. Since this merge tag only returns one value, multi-cell ranges will only return the value of the first range. For example, {{range A2:B10}} will return the value of range A2.
{{column A}}: All values in column A(dynamic).
{{row 1}}: All values in row 1(dynamic).
{{sheet}}: The name of the sheet that was edited or set in the trigger step.
{{automation name}}: The name of the automation workflow you have set.
{{spreadsheet url}}: The URL of the spreadsheet that this automation belongs to.

Only work with spreadsheet edit trigger

{{old value}}: Applies to the "A spreadsheet is edited" trigger only. This merge tag will return the old value of the cell that has been edited. If an empty cell was edited, this merge tag will return "undefined". For example, if cell A1 was edited from 10 to 100, this merge tag will return 10.
{{new value}}: Applies to the "A spreadsheet is edited" trigger only. This merge tag will return the new value of the cell that has been edited. For example, if cell A1 was edited from 10 to 100, this merge tag will return 100.
{{editor}}: Applies to the "A spreadsheet is edited" trigger only. This merge tag will return the email address of the user who edited the spreadsheet.
{{edited range}}: Applies to the "A spreadsheet is edited" trigger only. This merge tag will return the cell that has been edited in an on edit trigger. For example, if cell A1 was edited from 10 to 100, this merge tag will return the string "A1".

Only work with form submission trigger

{{form values}}: All values of the form submission that was received.
{{form values 1}}: The first value (or the nth value if you set the number as n) of the form submission that was received.
Copy link