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.
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!
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.
@ 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.
@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.
I actually went on with this scenario creation and (kind of) found a workaround for this issue (which is not a workaround at all because I just get less reviews, and for the moment I left it at that).
I tried again setting up the scenario where I could get the bundle order position but at the moment I don’t really know how to replicate the error.
So, for now, I will leave it at that and I will reopen this thread in case I will add more questions.
Regardless, I really appreciate you guys helping me with this I really appreciate it😊
