I have found a script that works for my purpose of merging CSV's into one file, however I want to run this from a shared drive.
Is it possible to modify this script to use a shared drive instead?
The script: https://developers.google.com/apps-script/samples/automations/import-csv-sheets
I've read through the documentation here and enabled the Advanced Drive Service but sadly I think this is a bit beyond me.
Any help appreciated.
Thanks