I've got a file (/Users/myname/Destination/winenot.txt) full of data created in Google Sheets. Ideally an apps script would convert the data in sheet Export to .txt and overwrite my local winenot.txt file onEdit. To specify, I mean only when the specific sheet Export is edited, not any other sheet within the spreadsheet Script-question.
Is this something Apps script would be able to do? Or is this more suitable for the Sheets API? Could some kind soul help push me in the right direction?
PS: this is how the data is set up: https://docs.google.com/spreadsheets/d/1ca_f5RmpVxEfbCYMZM1P-j5VKfwV3JwvgiVp62E61mg/edit?usp=sharing
