Hi there,
I am an expert in Google App Script with more than two years of experience. I can develop a script that can connect your sheets workbook to an external API to fetch remote data and display them in the sheet after sorting. To get started, share the following:
1. The API to connect to and any relevant details
2. If the API requires key and token for API connection, please share them
3. Share how the data should be structured
4. Specify the criteria for sorting the fetched data
Let me know what you think of my offer. Thanks for your time and consideration.