Google Sheets - Search Rows consume 2 operations producing the same output

What are you trying to achieve?

I’m really new to Make so maybe everything is fine and what I’m looking for is not achievable.

The aim is to move files to specific subfolders mapped in a google sheet on the basis of the filename cointaning a specific word mapped in the same google sheet.

The google sheet has 2 columns, Tag and Folder ID, and 3 rows (1 for the header and 2 for each Tag-ID pair).

The problem here is that the Google Sheets - Search Rows runs twice, with the second time (uselessly) producing the same 2 bundles as the first time thus consuming operations in vain.

Can someone help me?

Steps taken so far

I tried to insert and array aggregator before the Google Sheets - Search Rows module and iterator after the Google Sheets - Search Rows module but the cost in terms of operations is 9 vs 7 so it’s even worse.

Screenshots: scenario setup, module configuration, errors


Hey @Frost , from the screenshot you shared, I see you added an iterator immediately after the google search rows module. The Google search rows works like an iterator so you do not need to put an iterator in front of it.

2 Likes