How to reduce the number of operation for Google Spreadsheet -> Search Row?

I have a simple flow, but it uses way too many operations and I’m pretty sure it can be done in another way.

The goal of this flow is simple, get the webhook data and update a few rows in a Google spreadsheet based on the data

The modules that I have now are like this:

  1. Get Webhook data
  2. Get range values
  3. Search row (based on a phone number)
  4. Update row

I’m curious how can I reduce the number of operation or maybe change the entire flow for a better one.

Welcome to the Make community!

You need to aggregate bundles. Please do the Make Academy.

Example

Here is an example of how your scenario could look:
Screenshot_2025-04-12_190452

This is just an example. Your final solution may or may not look like this depending on your requirements and actual input data.

Combining Bundles Using Aggregators

Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, 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. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.

You can find out more about the other types of aggregator modules here:

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Thank you very much for the guidance! I’ll go through what you sent and come back!