When a new payment comes, search in a sheet, if it exists in the sheet, update it

I created a payment automation in Make. when a new payment comes in it has to search in a sheet, if it exists in the sheet, it should update the row and also notify slack that a payment has been made. In the process of updates, it populated over 2000+. What may likely be the cause of this?

I want to know why that contact populated more than a thousand times in the sheet and also in Slack.


Welcome to the Make community!

Every result (item/record) from a search module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module.

If you don’t use an aggregator, you can potentially run into thousands of result bundles, causing all the subsequent modules to run that many times each, unless you set up additional filters to only allow the bundles you want through.


If you need more help with your scenario,

1.

Please share screenshots of the module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2.

Please export the scenario blueprint file to allow others to replicate the issue. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826

Uploading it here will look like this:

blueprint.json (12.3 KB)

3.

Please provide the input/output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the contents as a bundle.json file, and upload it here into this discussion thread:

Screenshot_2023-10-06_141025

Following these steps will allow others to assist you here. Thanks!

2 Likes

@samliew thank you for this update, a quick question do you know the reason why this is happening?