Skip to main content
Hello, I am currently running an Action Flow which is delivering and modificating a Gsheet and i would like to sort the sheet in ascending order on 1 column.
Can i do it on the query who's generating the gsheet ?
Thanks for your help 🙂

Hi Antoine,

 

thank you for reaching out to us. I am Levente and would like to get to know more of your use case.

 

Could you please let us know which modules and actions are you using in Action Flows?

 

Best regards


Hi Antoine,

 

thank you for reaching out to us. I am Levente and would like to get to know more of your use case.

 

Could you please let us know which modules and actions are you using in Action Flows?

 

Best regards

Hi Levente,

 

thank you for reply.

 

In Action Flows, i am using Google sheets module with the tools and Celonis to do the query.

In fact i would like to exactly the same thing than a "Order by".

 

Best regards

Antoine


Hi Antoine,

 

Thank you for the additional description of your use case.

 

Unfortunately this is not possible directly with the modules involved, but you can use a script on google sheets to get this work automatically.

 

Please find the script, which you can add to your Google Sheets, by clicking on Extensions - App Script.

 

https://gist.github.com/mikebranski/285b60aa5ec3da8638e5#file-keep-column-sorted-in-google-sheets-gs

 

 

Kindly let me know if you have any further questions on this matter.

 

Best regards

 

 

 


Thanks Levente for your answer, i'll try with google script yes


Reply