How do I only process N items from google search module

How To
1

I am using google sheets search module to get the contents of a 1000 item file. Filtered on the football team name. However I only want to process 15 of the items I find. I followed it with an n increment module and then but on a filter on the connection going into the next module to test if the increment is <15 but its doesnt work. ie it doesnt stop it just keeps processing them all

Google search module sends ALL the items(bundles) that match the football name all at once so that increment is only performed once. Useless
Can anyone help on how to solve this or what other module might work

There doesn seem to be a way of looping through google sheet bundles one at a time at all as far as I can see - really frustrating

3

Set the “Limit” of the search module to 15, and search for column “Used” not equal to “yes”.

After using those items, update the column “Used” for those rows to “yes”.

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.