This article covers Sheetgo Automations — the Google Sheets extension (Extensions > Sheetgo > Automations). Using the web app instead? See What is a Sheetgo data processor?
Sheetgo Automations includes five filter processors that let you refine your data before it is written to the destination. You can chain them together and control the order in which they run.
Note: If your automation has more than one source, you need to add Merge before any filter processors become available.
Filter Rows
Keeps or excludes rows based on conditions you define. Choose ALL (AND) or ANY (OR) match mode, add up to 10 conditions, and click Done.
Filter Columns
Select which columns to include in the destination and reorder them as needed. Check the columns to include and click Done.
Filter by Query
Apply Google Query Language (SQL) for advanced filtering. Enter your query expression and click Done.
Filter by Color
Keep rows based on cell background color. Choose the column and target color, then click Done.
Remove Duplicates
Remove repeated rows based on selected columns. Choose the reference columns and click Done.
