Update each cell according to the query

How To
,
1

Hi,
How do I update each cell corresponding to the query?

image
image1355×352 43.4 KB

In the current scenario, the return is only in 1 cell and not in the corresponding cells.

image
image1268×516 82.4 KB

blueprint.json (38.0 KB)

Thanks

2

Welcome to the Make community!

If you want more columns in your trigger module,

You should expand the range values to cover the other columns, or,

Instead of the “Get Range Values” module, try using the Google Sheets “Search Rows” module:

Returns results matching the given criteria.

For more information, see https://www.make.com/en/integrations/google-sheets, and https://www.make.com/en/help/app/google-sheets in the help centre.

Example

Here is an example of how your scenario could look:

Screenshot_2025-02-27_110202
Screenshot_2025-02-27_110202447×358 15.2 KB

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

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.

3

If you want to update more than one cell, try using the Google Sheets “Update a Row” module:

Updates a row

For more information, see https://www.make.com/en/integrations/google-sheets, and https://www.make.com/en/help/app/google-sheets in the help centre.

Example

Here is an example of how your scenario could look:

Screenshot_2025-02-27_120228
Screenshot_2025-02-27_120228700×330 18.5 KB

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

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.

4

Hey,

Maybe I didn’t explain it correctly.

As an example, I need to perform a query on a range, I am using the “Get Range” method e.g.: (B2:B7), I store this range in a variable and send it to a REST API endpoint that performs the query whether the values ​​present in this range will return a status code 200 (registered sku) or 404 (unregistered sku). Until the end of the flow, everything works, but from the Update options in the sheets, I can’t find one that updates the status result in the 2nd interval (C2:C7) with the result of these statuses.