Link Checker error: Please specify a valid Spreadsheet URL. You can find a link to a template in the

[melisa.r...@catalyst.ca]

Hello,

I'm trying to upload the Link Checker script to my Adwords account, but keep getting :

"Error: Please specify a valid Spreadsheet URL. You can find a link to a template in the associated guide for this script. (file Code.gs, line 967)"

I have tried to add the regular spreadsheet URL with edit access and I also tried to add goo.gl link. Both of them did not work, what I can do to resolve this?

The script: https://developers.google.com/adwords/scripts/docs/solutions/link-checker

Thanks!

[Anthony Madrigal]

Hello,

Please only edit the CONFIG object (shown below) that is on the first line. 

var CONFIG = {
  // URL of the spreadsheet template.
  // This should be a copy of https://goo.gl/Ysrg9s.
  SPREADSHEET_URL: 'YOUR_SPREADSHEET_URL',

  // Array of addresses to be alerted via email if issues are found.
  RECIPIENT_EMAILS: [
    'YOUR_EMAIL_HERE'
  ],

If you edited, validateAndGetSpreadsheet function at the bottom as well, this will throw the error you mentioned in your post.

Regards,

Anthony

AdWords Scripts Team

[Zablon Mukuba]

did this work?

[Anthony Madrigal]

HI Zabion,

Yes, this should work. Let me know if you face any issues.

Cheers,

Anthony

AdWords Scripts Team

[Roberta Stabilini]

This worked for me!

Thanks very much