I have an XLSX file in Google Drive. I need to convert the data in this XLSX file to CSV. There are several threads that address this topic, but none actually show the complete scenario. I have tried all the solutions in these threads. The main problem is that I cannot find a connector that will do anything with the XLSX file that is stored in Google Drive.
The Google Drive Copy File module does just that. It copies the XLSX file to another XLSX file. But you still can’t do anything with that data.
The Google Drive Download a file module refuses to download XLSX files. The error is that the operation is not supported for that file type.
The Google Drive Upload File module does have an option to convert to Google Sheets format, but you can’t actually download the file, so that isn’t an option.
Excel has several modules that would work, but the file has to be in their cloud.
Cloudconvert is not an option because the XLSX URL requires authentication, which I don’t know how to do in Cloudconvert’s module. And since I don’t own the file, I can’t create a public URL.
Since Google is so hostile to XLSX format, not even allowing me to download the file, I’m at a loss.