Step 7. Test the final scenario
Now that you've added an aggregator to your scenario, it's time to test the complete scenario to make sure everything works as expected.
Go to your Prospects spreadsheet and add three or more new rows:
- At least two with Country = USA
- One with a different country
In the Scenario Builder toolbar, click the Run once button.
By default, the "Watch New Rows" module will only find the new rows added since you last ran your scenario. To process all rows again:
- Right-click the Google Sheets module
- Select Choose where to start
- Choose "All" and click Save
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 bubbles to view the details.
The Google Sheets module should show all new prospects you added, depending on the limit you set:
The Slack module should receive and process all prospects:
The filter should only let the USA prospects through:
The Text aggregator should combine the USA prospects into a single bundle:
The Apple iOS module should only process this single aggregated bundle:
Check your Slack channel to confirm all notifications arrived.
Check your mobile device to confirm you received only one notification that contains all the US prospects.
You've now created a scenario that:
- Monitors a Google Sheet for new prospects
- Sends all prospects to a Slack channel
- Sends only US-based prospects to the Sales Manager's mobile device
- Combines multiple US prospects into a single mobile notification
What's next?
Now that you've learned how to use routers to create multiple paths, filters to process data conditionally, and aggregators to combine related information, you can continue expanding your scenario by:
- Adding more filters for other countries or criteria
- Integrating additional apps like email or CRM systems
- Exploring other aggregator types for different data formats
- Learning about error handlers to make your scenarios more robust
To advance your Make knowledge, explore our free online courses at Make Academy.