One of the basic processes that you can achieve with Sheetgo is to split data from one source to one or multiple destinations, the split process will need to be added to the Data processors step of your workflow. After selecting the source file, you will select the split processor and then specify your destination. In the screenshot below, you will notice what your split automations will look like.

The split process allows you to distribute data from a CSV, TSV or Google Sheets. It is useful for sharing specific data with collaborators and for controlling access to sensitive data. Combined with automatic updates, it can be used to generate automated reports or to allocate tasks to team members automatically.

A column in the master sheet (source) will determine how to split data. This column might contain the names of different colleagues, stations, stores, student names, etc. For example, Sheetgo will group rows that contain the same name in the column selected and will export them to one destination (file or tab).

Split can send data to a new or an existing file. If you choose “New file” Sheetgo will automatically create the file for you upon saving and running the automations. You can then share each file with colleagues or clients to be managed independently.