Variables

Variable is a way to pull data out of sheet or runtime when the automation runs. It can be used in conditions or actions to make your rule dynamic.

Common variable

• {spreadsheet_name} : the name of the spreadsheet
• {sheet_name} : the name of the current sheet
• {sheet_url} : the link of the sheet that the rule is processing
• {row_number} : the index number of the current row
• {row_values} : the values of the current row. It is a comma separated text.

Special variable

• {editing_user}: the name of the user who has triggered the change
• {editing_user_email}: the email of the user who has triggered the change

Sheet variable

• {column_A} : reference the column value of the current row. For example, you can use column_A to reference the first column and column_B for the second column.
• {range_A1} : reference the value of the specified range. For example, you can use range_A1 to reference the first column of the first row.