Uploading from Dropbox to Google Sheets

[mikec29526]

I was able to connect Dropbox and upload successfully a csv file to Google Drive. Unfortunately, the file is a google doc, not worksheet. I am wanting to get the rows of data into pabbly from the csv in dropbox. Is there a way to get this accomplished?

 

[Pabblymember11]

Hey @mikec29526

Can you name the workflow once, so that we can look into it and can guide you accordingly?

 

[mikec29526]

This is the name of the workflow: Upload CSV from Dropbox to Drive as a Google Sheet

 

[Pabblymember11]

Can you please tell us from where you are getting the CSV file? If you are getting the file apart from MS Excel or Google Sheets then it is not possible to convert the CSV data into JSON array format to pass the complete data to the Google Sheets.

 

[mikec29526]

It's a csv file in Dropbox. If I save it as an excel instead of csv do you think that would work? Or do you know of any other way to get thus functionality working?

 

[Pabblymember11]

I do not think that will work if the saving CSV file as excel will work.