Save spreadsheet in a Specific Folder of GDrive

[Peter Cooper]

Hello,

I need help with this Google AdWords script: https://developers.google.com/adwords/scripts/docs/solutions/keyword-performance. 

Every time I run this script in Google AdWords account (for my PPC campaign), it creates report (spreadsheet) and save it on my google drive. 

I would like to save spreadsheet file to specific subfolder on my google drive. I found the article which describes how to save spreadsheet  to specific folder. But I don't know how edit this script and use it. Article describing this function is here: 

http://www.freeadwordsscripts.com/2014/07/save-file-or-spreadsheet-in-specific.html

Can you help me solve the problem?

[Anash Oommen]

Hi Peter,

You could do something like this:

var subFolder = DriveApp.getFoldersByName("subfolder").next();
var myFile = DriveApp.getFilesByName("my_report").next();
var oldParent = myFile.getParents().next();

oldParent.removeFile(newFile);
rootFolder.addFile(newFile);

Cheers,

Anash P. Oommen,
AdWords Scripts Team.