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
Last modified August 14, 2023