I have a scenario that adds some data to a google sheet, but I want to add a step where it does a sort on the google sheet afterwards. Akin to doing this inside Google sheets:
@Forrest
Make does not provide sorting as a module, so you would need to create an API Request using the following API.
Got it - thanks for the feedback. Seems like a really great feature for Make to add as an action for google sheets
The problem is that the user (or any user the Sheet is shared with) can sort the sheet again by whatever criteria they choose.
If you’re looking to provide a static report, a spreadsheet might not be the best tool to use.
I’m okay with someone sorting it later and I want them to be able to use the data in the spreadsheet in other ways, add comments, etc…
I see your point. As we don’t have a module specifically to do that, you’d have to use the Google Sheets Make an API Call
module to use the Sort a range API endpoint identified by @momomomonmon