This article covers Sheetgo Automations — the Google Sheets extension (Extensions > Sheetgo > Automations). Using the web app instead? See What is a Sheetgo data processor?
Data processors are an optional step between your source and destination. They let you merge, format, and filter your data before it is written to the output. You can chain multiple processors.
Merge
Combines all selected sources into a single dataset. When your automation has more than one source, Merge must be added before any filter processors. Row order in the output follows the source order set in step 1, which you can adjust using drag-and-drop.
Note: Filter processors require Merge to be configured first when your automation has more than one source.
Data Formatting
Carries formatting from your source files through to the destination, and lets you enforce specific data types per column.
Transfer formatting
When enabled, the following elements are transferred from source to destination:
Number formats — dates, currency, percentages
Cell styles — colors, fonts, alignment
Column widths and frozen panes
Conditional formatting rules
Tip: Formatting maps by column header, so it works correctly even when columns are filtered or reordered.
Enforce column types
Converts values in each column to a specific data type. Each column gets its own dropdown, set to Automatic by default.
Type | Example |
Automatic | Detects type from the data |
Plain text | — |
Number | 1,234.56 |
Percent | 12.34% |
Currency | $1,234.56 |
Currency rounded | $1,235 |
Date | 2025-01-15 |
Time | 14:30:00 |
Date & Time | 2025-01-15 14:30:00 |
Duration | 26:30:00 |
Scientific | 1.23E+04 |
Accounting | $ 1,234.56 |
Financial (red negatives) | — |
Filter processors
Processor | What it does |
Filter Rows | Keeps or excludes rows based on conditions you define. Supports AND/OR logic and up to 10 conditions per automation. |
Filter Columns | Select which columns to include in the destination and reorder them as needed. |
Filter by Query | Apply Google Query Language for advanced, expression-based filtering. |
Filter by Color | Keep only rows that have a specific cell background color. |
Remove Duplicates | Detect and remove repeated rows based on selected columns. |