Here’s the translated message: Good morning everyone, how are you? I hope you’re doing well! I’m creating an automation and have encountered some difficulties. If you could help me, I would be very grateful! If I need my OpenAI assistant to perform a conditional check in a spreadsheet, how should I do it? Some examples: I have a Google spreadsheet containing names, ages, salaries, and positions. I want my assistant to list the 10 highest salaries, but I understand that OpenAI assistants have difficulty listing numbers. Therefore, I need to handle this order in the make module function to deliver in the correct order and have it just list. How could I do this?
Hey @Pedro_Vaz
For this purpose, you need to aggregate the bundles from google sheet and then apply sort() function and then iterate. It will give you in order you will pass, ascending or descending.
Regards,
Msquare Automation - Gold Partner of Make
Book a Free Consultation | Connect Live
Explore our YouTube Channel for valuable insights and updates!
Is there a video showing how to do this?
Hey @Pedro_Vaz
Please check out this loom explanation.
Regards,
Msquare Automation - Gold Partner of Make
Book a Free Consultation | Connect Live
Explore our YouTube Channel for valuable insights and updates!
1 Like