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.

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.

Editing 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
• {editing_range}: the A1 notation of the cell range that is being edited
• {editing_value}: the value of the cell that is being edited
• {editing_old_value}: the old value of the cell that is being edited

Action specific variable

• {lookup_row}: the row number after a Lookup Row action is performed
• {http_response_code}: the http response code after Call HTTP action
• {http_response_text}: the http response text after Call HTTP action