Thanks for writing in, I’m happy to help here!
It should be possible to upload a CSV from a publically accessible URL to Google Drive by using the "Upload File" action (Google Drive). You would select the URL from a previous step and use it as the value for the File field:
If you need to turn this CSV file into an editable Google Sheets file, you can select Yes for the "Convert to Document?" option:
Does that get you pointed in the right direction? If you have any other questions, please don't hesitate to ask!
All the best,
How would you rate my reply?
Great Okay Not Good
Customer Champion - Zapier