Step 5. Test your scenario
Now that you've set up the filter, it's time to test your scenario with different types of prospects.
To test your scenario:
Go to your Prospects spreadsheet and add two new rows:
- One with country = USA
- Another with a different country
In the Scenario Builder toolbar, click the Run once button.
By default, the Google Sheets "Watch New Rows" module will only find the new rows added since you last ran your scenario.
If you want to process all rows again for testing, you can reset it: right-click the Google Sheets module and select Choose where to start. Select "All" and click Save. The next time you run the scenario, it will include all the rows again.
Check the operation bubbles above each module to see the results. The numbers shown in the bubbles indicate how many operations were used.
Click on the operation bubbles to view the details.
The Google Sheets module should show both prospects:
The Slack module should receive and process both prospects:
The filter should only let the USA prospect through:
The Apple iOS module should only process the USA prospect:
Check your Slack channel to confirm both notifications arrived.
Check your mobile device to confirm you only received a notification for the USA prospect.
This test shows that the scenario works properly:
- All prospects are sent as Slack notifications
- Only US prospects trigger mobile notifications
This targeted approach ensures the Sales Manager gets alerts only for US market prospects, while the Slack channel receives updates about all prospects.
However, if many US prospects are added at once, the Sales Manager would receive multiple separate notifications. In the next step, you'll add an aggregator to combine multiple US prospects into a single notification.