The direct export URL might not be accessible to the public, and may fail silently as it may display a webpage instead. You might need to make the document public first.
To do this, you can try using the Google Drive “Get a Share Link” module —
Gets a share link for file or folder.
This allows you to set the file to be publicly exportable.
Alternatively, you can simply use the Google Drive “Download a File” module —
Downloads a file.
For more information about the “Get a Share Link”/“Download a File” modules and Google Drive app, see the corresponding Integrations page and the Help Centre documentation.
Hope this helps! If you are still having trouble, please provide more details.
— @samliew