Hey everyone, I know it might seem simple but I've been trying to figure out how to do this for a few days.
- Watch a folder in Google Drive for any CSV files that get uploaded
- Convert those to Google sheets files
- Delete the CSV file after operation
I've done some more complex automation's than this but for some reason this one is being a challenge!
My flow --> Watch files in drive --> Filter for CSV --> Download file --> Upload file (putting in new mime type).
It works but its saving it as a binary file still not a google sheet.
I want to set this up because I'm manually converting then at the moment which takes time!
Thanks all :)