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