Help: Error on Negative Keyword conflict script

67 views
Skip to first unread message

Wordsburg

unread,
Feb 13, 2017, 9:07:43 AM2/13/17
to AdWords Scripts Forum
I'm trying to use the Ad Words script named Negative Keyword Conflicts - Single Account at https://developers.google.com/adwords/scripts/docs/solutions/negative-keyword-conflicts#setup

I am continuously getting an Error: Please specify a valid Spreadsheet URL. You can find a link to a template in the associated guide for this script. (line 599) 

I've used the URL it provides that ends with .....jKY/edit?usp=sharing.

I have followed all instructions correctly. Made a copy of the template, copied URL in the sheet (https://docs.google.com/spreadsheets/d/1-sBRE5Ln-uRTrTlSYyZZJQ5jsyLuxX-LhXU2duT2qq8/edit#gid=0

Apart from the above error it also throws me email validation error 

Please either specify a valid email address or clear  the RECIPIENT_EMAILS field.













































Please help




Regards, 
Praveen

Anthony Madrigal

unread,
Feb 13, 2017, 9:36:33 AM2/13/17
to AdWords Scripts Forum
Hi Praveen,

The only areas where you need to modify the SPREADSHEET_URL and RECIPIENT_EMAILS are the ones from the var CONFIG at the top of the script. You can leave the functions validateAndGetSpreadsheet and validateEmailAddresses untouched.

Please let me know if you are still facing issues.

Cheers,
Anthony
AdWords Scripts Team
Reply all
Reply to author
Forward
0 new messages