Problem We Are Solving: Reducing API Calls & Optimizing Bulk Updates in Google Sheets
Issue with the Previous Approach
How the Previous Process Worked:
-
Fetch enriched contact data from the Anymail Finder API, which provides multiple contacts at once.
-
Search for each contact’s row individually in Google Sheets based on first name and last name.
-
Update each row separately, one by one.
Why Is This a Problem?
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.
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.
