Limiting the number of rows I add to a Google sheet

Hello everyone,

I would love your help in working on one automation.

Basically what I’m trying to do is this: I am using Apify, to get some reviews from Google My Business. Using a router, I am divinding the ones that have 5 stars, from the ones that have less than five stars.

Then, I add them all to a Google sheet.

Thing is I would like to limit the number of reviews that have 5 stars that I add to the Google sheet to 10, as not to have a lot of results in my final worksheet.

I have tried a lot of solutions but none of them work.

I sense it’s fairly easy to do, but since I am a novice in this field I’m having a lot of difficulties.

How would you go about it?

Thanks for your kind help

2 Likes

Hi @Elio1,

Here’s a high level approach. Create a variable titled “5-Star Review Count” every time the router for 5 Star reviews is utilized append +1 to the count. Create a conditional that checks if the “5-Star Review Count” is less than 11 to continue running.

Please let me know if you’d like more detail but I hope this approach helps guide your development!

-@Trainward_Consulting

Hi @Elio1 Welcome to the community.

If you want to just limit max rows going inside google sheet, before create a row module, create a filter with “Bundle order Position” - “Less than or Equal to” - “10”. This way you will only get first 10 results in the sheet and rest of them will be skipped.

I hope this helps! Let me know if you need more help!

Best,
@Prem_Patel

Hi Guys,

thanks a lot for your answer!

@ Prem_Patel I already tried that and it didn’t work, because, with the configuration I have now, I get several different bundles and each one of them is in position 1, so the filter allows them all

@ Trainward_Consulting Thanks for your solution. I tried several ways and I brought in Chatgpt and Gemini (which didn’t help at all) but couldn’t get it to work. Could you please elaborate more? I am not very experienced using Make so I don’t know how to do what you are proposing.

Thanks again for your help

Elio

1 Like

@Elio1 Please share your full scenario configuration, output from module and mappings you have done using screenshots. This will help us in sharing more helpful solution for you.