Upload txt file data (in CSV form) to Google Sheet

[rc76]

Is there anyway we can upload a txt file's data (which already in CSV format) on your local C:\ to your google sheet on the cloud?

Any example of how I can get started will be super awesome!

[boiler]

You mean you want a script to do it rather than manually going to File > Import in Google Sheets?

[rc76]

Yes, because it will be on a frequent basis of importing (on an hourly basis).

So prefer to automate the process.

[rc76]

Basically i wish:
(1) From every hour's txt's line items (in CVS format), to append each line item to a google sheet's particular tab.
(2) Only append onto google sheet, not replacing it.