How do I convert a CSV file on Google Drive to a Google Sheet?

This topic was automatically generated from Slack. You can find the original thread here.

MathiasS : Quick question: Is there currently a way to convert a csv file on google drive to a google sheet using pipedream?

Dylan Sather (Pipedream) : I didn’t see an API endpoint in the Google Drive API docs that allows you to convert a CSV that you’ve already uploaded to Google Drive.

However, take a look at the two actions in the screenshot below (just add a step to your workflow and search for Google Drive actions). You should be able to modify the code in those to pass a mimeType of application/vnd.google-apps.spreadsheet . Google says:

> If a file is created with a Google Doc MIME type, the uploaded content will be imported if possible. The supported import formats are published in the About resource.
So I believe that should upload the CSV as a Google Spreadsheet.

MathiasS : :+1:thanks!