1

I am trying to modify the following script, which saves a selected range to a new CSV file on Google drive.

https://developers.google.com/apps-script/articles/docslist_tutorial?hl=en

Please see: Section 3: Saving a selected Range to a CSV file

I would like to however append an existing CSV file with defined (named) range that I already created on Google Drive - I don't want to be prompted for its name. If and only if the CSV file not exist, then I want to create the new file.

This script should run via time-drive trigger (so that it runs automatically every minute and saves required range into csv file)

I would greatly appreciate your help how to modify this code.

user1419533
  • 11
  • 2
  • So, the file name of the csv should be read from a named range in the spreadsheet? Or is it a preset name you'll be setting in your script? – Rivero Aug 31 '15 at 17:56

0 Answers0