By default, Sheetgo will transfer all the source data to the destination. But sometimes, you may want to transfer specific information. To do this, you can use Sheetgo filters to specify which data to transfer. You can filter data in new or existing automations.
There are 4 ways to filter data with Sheetgo:
This option lets you set conditions to filter data. You can define one or more conditions that the source data must match for Sheetgo to transfer it to the destination file, for example:
Texts in "Column A" that are equal to a specific name.
Dates in "Column B" that match the current month.
Numbers in "Column C" that are greater than 100.
This filter lets you choose which columns to transfer to the destination and in what order. It's the simplest way to select only a few columns and a great resource for ensuring that you transfer only necessary data.
Filter by color is ideal if you use color coding in your spreadsheets. Specify a cell background color, and Sheetgo will only transfer data from cells with that color.
This more advanced filter allows you to extract specific data from your source spreadsheet. Use SQL-like queries if you want to transfer data only from specific columns or apply a complex criteria.
Compatibility notes:
Files must be stored in Google Drive to apply a filter.
Filter by color is available for Google Sheets only.
Filter by color is not available for Consolidate (merge) connections.
Conclusion
Sheetgo filters open up a world of possibilities for your data management. By enabling you to transfer specific data selectively, you can streamline your workflows, focus on the most relevant information, and enhance your productivity.
Leverage Sheetgo filters to optimize your data handling and make workflows more efficient and effective.
Need more help?
Contact us via chat, on our email ([email protected]), or send us a ticket!
Visit our Community for help, tips, tricks, and feedback for Sheetgo.