Uploading from Dropbox to Google Sheets

Status: Closed · Asked by mikec29526 on Feb 1, 2023 · 0 views

mikec29526 — Question · Feb 1, 2023

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 — Reply · Feb 2, 2023

Hey @mikec29526

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

mikec29526 — Reply · Feb 2, 2023

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

Pabblymember11 — Reply · Feb 3, 2023

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 — Reply · Feb 3, 2023

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 — Reply · Feb 4, 2023

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

Back to all forum threads · Log in to reply