When using a spreadsheet in any of the applicable Enhanced Scripts, you'll need to enable access to it so the script can retrieve the required information.

Whenever a script's settings shows the option for a Spreadsheet URL (as image below), you have two options; using an existing spreadsheet, or creating a new one. 

If you want to copy the results in an existing spreadsheet, put in the address of the spreadsheet and make sure the sharing settings are set correctly, as mentioned above.

If you leave 'NEW' in the spreadsheet setting, the script will create a new spreadsheet in the Google Drive folder associated with your Google Ads account email.