Google Sheets :
Google Sheet application is used to segment a field by using a particular parameter and store the particular data in a new Google Sheet or an existing Sheet.
- Select the application as Google Sheets.
- In Google Sheet Configuration select the sheet for which the segmentation needs to be done.
- Select Full Sheet or Range.
- In the segment by field section select the field by which segmentation needs to be done.
- Select a spreadsheet or create a new spreadsheet so that the segmented data will be stored in the spreadsheet.
- Switch on Auto create New Segments so that if any segment is not configured , it will create a new spreadsheet and configure automatically with the field name.
- Click on execute button to Execute the services .