I was assuming that Google spreadsheet exports UTF-8 encoded CSVs. However, this does not seem to be the case — my german Umlauts, etc. (äüöß, etc.) are not recognized, i.e. when opening the file in ...
I understand how to upload and convert CSV files to Google Sheets -- but how can I set up an automatic upload of all new data from a CSV file into an existing sheet? I have a CSV file that lives on ...