Download Google Sheets as xlsx file using Google Drive node

Questions
,
1

I’m trying to export a Google Sheets file as xlsx file using Google Drive node. The file is correct, i’ve set the file conversion to MS Excel and included a file name with extension. But, when I download the output, is very different from the file download clicking on the Google Sheets UI. The file seems corrupted. Am I doing something wrong?

My main goal is to send this file to a slack channel.

Please share your workflow

Information on your n8n setup

  • n8n version:0.216.2
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via: desktop app
  • Operating system: Windowa
2

Hi Bruno,

I had a look at the Google Drive node, it appears that when we use the Google File Conversion Google Sheet to MS Excel we actually download the file in the mimetype application/x-vnd.oasis.opendocument.spreadsheet that matches the OpenDocument format.

The extension of the file should therefore be .ODS and you should be able to open it with Excel.

In any case I will see with our node team if we can implement a direct download in .XLSX (mimetype application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)

1 Like