I understand how to upload and convert CSV files to Google Sheets -- but how can I set up an automatic upload of all new data from a CSV file into an existing sheet?
I have a CSV file that lives on my hard drive. Anytime a new order for our company comes through, the new order data is dumped into that CSV file. Then, we have a tracking database that lives in Google Sheets, which I would love to automatically add rows with the new data every time the CSV file changes. Or, at the least, update automatically with new info once a day or something.
Is this possible?