- I have a csv file which is saved to my hard drive on a regular basis.
- The folder where it is saved is linked to my google drive.
- When a new file is added to this folder, ZAP triggers for the file.
- My next zap takes that file and replaces an existing GoogleSheet.
My problem is that when it replaces the google sheet, some data is irreversibly changed into dates. For example 3-0011 is changed to display 3-2011 and is recorded in the field as 3/1/2011.
I have tried both true/false for the option to turn it into a google document and neither changes the outcome.
The file has 30K+ lines so making formatting changes per line would probably be cost prohibitive.
Any ideas on how this can be achieved utilizing only zap, google sheets, and google drive would be appreciated.
Best answer by Matthew is working
View original