Action

Action is a step that performs a task such as making changes in your sheet or sending an email.

Send Email

This action sends an email notification to one or more recipients via your email account.

To

To parameter accepts email address. If there are multiple email addresses, separate them with comma.

You can pull email address from the sheet dynamically. For example, use {column_A} if the email address is defined in the first column and use {range_A1} if the email address is in a fixed range. This is useful when each row has different recipient.

Cc and Bcc are supported.

Subject

This is the subject of the sent email. Use variable to include content from sheet dynamically.

Body

This is message body of the sent email. Use variable to include content from sheet dynamically.

Supported variables

  • {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.
  • {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.

Move Row

This action moves the triggering row to another sheet.

Sheet

The parameter specifies the target sheet.

Variable is supported here if you want to specify the name of target sheet dynamically. You should make sure the sheet exists otherwise the action can not be perfermed correctly.

Row position

You can specify where the row is inserted in the target sheet:

  • append to bottom insert the row at the bottom of the sheet
  • append to top insert the row at the top of the sheet
  • insert after insert the row after a specific row of the sheet
  • insert before insert the row before a specific row of the sheet

Paste type

The data will be copied in one of the paste types:

  • Default the whole row with value, formula and format will be pasted
  • Value only paste the value only without formula annd format

Copy Row

This action duplicates the current row to the specified sheet.

It works pretty much the same as Move Row except that it does not delete the triggering row. Refer to Move Row for details.

Create Row

This action creates a new row in the specified sheet.

You can specify multiple column and value pairs to insert into the row. The columns not specified will be left blank.

Column

The column parameter accepts a column letter. For example, A represents the first column of the current row and B represents the second column.

Value

The value parameter accepts below 3 kinds of data:

  • any text value
  • any formula valid for google sheet, e.g., =today()
  • variable,, e.g., {column_A} refers to the value of the first column of the current row.

Row position

It specifies where the row is created in the target sheet. Refer to Row position for details.

Export Row

The action exports the row to a file for email attachment.

Export mode

Two modes are supported:

  • Default: the row will be exported to a table with default style
  • Custom: html code snippet and custom style are allowed

Content

This parameter is available when Custom mode is selected.

File format

Two file formats are supported now: PDF or HTML.

Format Row

This action formats the current row with the specified style.

Currently only text color and background color are supported.

Lookup Row

This action performs a lookup in the sheet and returns the found row for further processing.

Update Row

This action updates one or more columns of the current row.

You can specify multiple pairs of column name and value in the action.

Column

The name parameter accepts a column letter. For example, A represents the first column of the current row and B represents the second column.

Value

The value parameter accepts below 3 kinds of data:

  • any text value
  • any formula valid for google sheet, e.g., =today()
  • any value on the sheet via variable, e.g., {column_A} refers to the value of the first column of the current row.

Delete Row

This action deletes the triggering row.

No parameter is required for this action.

Hide Row

This action hides the triggering row.

No parameter is required for this action.

Export Sheet

The action exports the specified sheet to a PDF file for email attachment.

Sort Sheet

This action sorts the specified sheet.

Sheet

The parameter specifies the sheet to be sorted.

Sort by column

The parameter specifies the column to be sorted by and the sorting order. A->Z means ascending and Z->A means descending.

Head row

The parameter indicates the row index of head row if any. Only the row below the head row will not be sorted.

Update Sheet

The action will update one or more ranges in the specified sheet.

You can specify multiple pairs of range and value in the action.

Range

The name parameter accepts a range in A1 notation.

Value

The value parameter accepts below 3 kinds of data:

  • any text value
  • any formula valid for google sheet, e.g., =today()
  • any value on the sheet via variable, e.g., {column_A} refers to the value of the first column of the current row.

Create Sheet

The action will create a new sheet with the specified name.

Sheet name

The parameter specifies the name for the new sheet.

Template sheet

The parameter specifies the template to be used for new sheet creation.

Delay Action

This action will delay the execution by a period of time.

This may be useful when you want to wait a bit until the user completes the editing on other part of the row.

Duration

The time period to delay. The maximum is 60 seconds.

Branch Action

The action supports multiple condition-action branches.

Conditional Action

The action supports condition to filter the action.

Call HTTP

The action can call any HTTP service.

URL

The HTTP service endpoint url. You can choose to GET or POST as the method to access the service.

The optional HTTP header parameters.

Request body

The payload that will be posted to the sercie if HTTP method is POST. It could be json or other format accepted by the service.

Response

How the HTTP response is handled. You can choose to write the response to a specified sheet. By default, it will be ignored.

Call Webhook

The action sends an http post call to any configured webhook endpoint. For examples, Zapier.

Webhook URL

The webhook endpoint url.

Payload

The payload that will be posted to the webhook endpoint. Note it has to be valid json format.

Send Slack Message

This action sends a message to a Slack channel .

Webhook URL

The webhook endpoint for the Slack channel. You may refer to Slack link to see how to configure the URL.

Message

Variable is supported in the message body. See Supported variables for details.


Last modified August 14, 2023