Select the highest value and export


In the database in Notion (attachment: Table) I have a ranking of suppliers according to their scores. I need to export the data of the supplier with the highest rating to a google docs document. I have programmed a function in Notion that displays this data (attachment: Notion formula). Is it possible to do something similar in Make?

Best regards
blueprint.json (1.9 MB)

There is the possibility to sort an array in make. To do this, an array of all suppliers would have to be created and then the array sorted according to the score. Note the sorting function process the input as text, therefore the number must be explicitly formatted as a number when sorting numbers, otherwise the sorting will not be correct.

Here is a simple example:
blueprint (44).json (4.1 KB)