The idea is to import the export order (.xls) from dropbox to google sheet daily.
I want to import this daily. Meaning, there will be new tabs created everyday for daily exported sheets.
It goes like this:
1. At 12:05 am, zapier will export the order sheets (from woocommerce) into dropbox in .xls format and will be kept in a folder for every month.
2.Then, zapier would import the order sheets from the file in dropbox to a google sheets spreadsheet
3.This process will repeated everyday for every order sheets in different worksheets (Exp:Today’s export orders will be imported in a worksheet(tab) and tomorrow’s export orders will be imported to different worksheet(tab) but in the same google sheet. Therefore, by the end of the month, i will have 1 tab for each day (1 tab for 1 order sheet daily)
So the problem here is, we cannot seem to find a way to import .xls file from dropbox to a specific google sheet file.
Do you know a way around this?
Best answer by Troy TessaloneView original
CSV files can be imported using the Formatter > Utilities > Import CSV File: https://zapier.com/help/create/format/import-csv-files-into-zaps
I tried doing it but could not make it.How will be the flowchart for the step above?
Thanks in advance
Please post screenshots of how your Zap steps are configured.
I tried doing it again and the automation is working. Thanks Troy. Now, I am facing a new problem. In the google sheets, there is a column for image and it will contain the images of the products but now I’m receiving it in url format. How can we change the image’s url to image. Is there any specific way?I even tried using the formula but nothing is working. Is it because of the .csv format?