Is there a way to bulk search rows using in google sheet then updating them but this task in bulk

How To
, , , ,
1

Problem We Are Solving: Reducing API Calls & Optimizing Bulk Updates in Google Sheets

:red_circle: Issue with the Previous Approach

How the Previous Process Worked:

  1. Fetch enriched contact data from the Anymail Finder API, which provides multiple contacts at once.

  2. Search for each contact’s row individually in Google Sheets based on first name and last name.

  3. Update each row separately, one by one.

Why Is This a Problem?

:police_car_light: High API Calls & Increased Make.com Operations

  • Searching for each row one at a time leads to multiple API requests to Google Sheets.

  • Updating rows individually increases Make.com operations, consuming more credits.

:police_car_light: Slower Execution

  • Processing 50 contacts?

  • We would send 50 search requests and 50 update requests (100 operations!).

  • This slows down the automation significantly and increases costs.

Is there any way that we can do it in a single search or reduce the operations in Make.com? Instead of making multiple API calls for search and update, we can process everything in bulk using an optimized workflow or even reduce the operations.

What I mean is to get about 50 emails, then search all in Google Sheets since all of them are unique, and retrieve the desired row (separate row for each email by matching the name or something else, e.g., A for A, B for B, but in one module call). Then update separate rows with unique values so the emails are added at the right place in the sheet. Can anyone provide a solution? I want a way that can reduce the cost of operations while maintaining the same efficiency as searching for rows and then updating them.

2 Likes
2

I’m also wondering if anyone knows a solution for this :slight_smile:

3

hey did you find a fix to this?

4

Welcome to the Make community!

To allow others to assist you to improve your scenario, please provide the following:

1. Relevant Screenshots

Could you please share screenshots of your full scenario? Also include screenshots of any error messages, module settings (fields), relevant filter settings (conditions), and module output bundles. We need to see what you’re working with to give you the best advice.

You can upload images here using the Upload icon in the text editor:

We would appreciate it if you could upload screenshots here instead of linking to them outside of the forum. This allows us to zoom in on the image when clicked, and prevent tracking cookies from third-party websites.

2. Scenario Blueprint

Please export the scenario blueprint. Providing your scenario blueprint file will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return - this would greatly benefit you in implementing our suggestions as you can simply paste module exports back into your scenario editor!

To export your scenario blueprint, click the three dots at the bottom of the editor then choose ‘Export Blueprint’.

217×162 5.36 KB

You can upload the file here by clicking on this button:

3. Output Bundles of Modules

Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

490×338 23.5 KB

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved, and help you with mapping the raw property names from collections.

Sharing these details will make it easier for others to assist you.