Hi @erenozkan ,
May be because of updates, I am not sure but before when I export products as CSV I can directly import to Google Sheets however created CSV file is not able to import google sheets now.
I checked this and I was able to import the CSV file exported via product exports in Google Sheets (screenshot for reference: https://d.pr/i/7KCx5s )
CSV is a standard format, so if you can open it using a sheet editor like Excel or LibreOffice Calc, then it should work with Google Sheets as well.
If you’re not able to import CSV files in your Google Sheets, then I recommend getting in touch with Google Drive support so they can check if there are any CSV specific restrictions in your account. You can reach oout to Google Drive support at https://support.google.com/drive/?hl=en#topic=14940
I hope this helps!