Issue and workaround:
In the built-in functions for Google Spreadsheet, it appears that there is currently no way to directly retrieve the data from the XLSX data of the URL. I'd like to suggest using Google Apps Script to accomplish your goal in this response. Your objective can be accomplished when Google Apps Script is deployed.
The flow of the sample script is as follows.
- Retrieve XLSX data.
- Convert XLSX data to Google Spreadsheet as the temporal Spreadsheet.
- Retrieve values from the converted Spreadsheet.
- Put the values from the converted Spreadsheet to the active sheet.
- Remove the temporal Spreadsheet.