Including a Condition filter in your workflows lets you easily filter the data you want to transfer from source to destination. You can set one or more conditions to transfer only certain data to the destination file.

Here are a few basic conditions:

Filtering by Condition disables the Transfer formatting option.

First you have to add a data processor to your automation.

Under the Select a data processor, select Condition:

First, you have to select and order columns. If you are selecting just some columns, double check the order in which they show up on the bar, as that's how they will be transferred to the destination file. You can always rearrange them by dragging and dropping them.

In this example, the destination file's header will be: column A, column C, column B.

Next, you must set up one or more conditions. If you plan to use many conditions, you have to choose the Condition type to define how they will be evaluated:

Click Add condition to specify which conditions to filter the data. Next, use the drop-down menus to select the Column, Criteria, and Value that Sheetgo should evaluate for each condition.

There're a variety of criteria to choose from:

When you finish setting conditions, click Next step or Done editing and run your workflow.