Account Anomaly Detector - Manager Account - Spreadsheets Error

[Claire Bories-Perez]

Hi, 

I tried to run this script Account Anomaly Detector - Manager Account, I copy the script and my own spreadsheet url, look like the same at the template they give us here : URL of the default spreadsheet template. This should be a copy of

  // https://docs.google.com/spreadsheets/d/1Tj-UPGaTONtUbTAGCuJ2j_8hEABCBRr7bUH7b2aFh88/copy

But when I run the script I have this : Error: Please specify a valid Spreadsheet URL. You can find a link to a template in the associated guide for this script.

at validateAndGetSpreadsheet (Code:465:11) at main (Code:82:23) at Object.<anonymous> (adsapp_compiled:20648:54)

or this

SyntaxError: Identifier 'SPREADSHEET_URL' has already been declared (line 1)  

If someone know how to fix this error

Thank u

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads Scripts support team.

I see that you have already raised this concern on another thread with the subject 'Account Anomaly Detector - Manager Account "Spreadsheet_url" Error', and we have already responded there for this issue. To avoid multiple threads on the same issue, please take a look at that thread and continue the discussion on the same for further updates on the issue.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02qWSiE:ref"

Thanks,
 

Google Ads Scripts Team

[Nils Rooijmans]

It looks like you have added the URL of your spreadsheet twice to the script.

Copy paste this script,  https://developers.google.com/google-ads/scripts/docs/solutions/manager-account-anomaly-detector 

the spreadsheet url should only be added here (yellow):

CONFIG = {
  // URL of the default spreadsheet template. This should be a copy of
  // https://docs.google.com/spreadsheets/d/1Tj-UPGaTONtUbTAGCuJ2j_8hEABCBRr7bUH7b2aFh88/copy
  // Make sure the sheet is owned by or shared with same Google user executing the script
  'spreadsheet_url': 'YOUR_SPREADSHEET_URL',

Hope this helps,

Nils Rooijmans
https://nilsrooijmans.com
See my Google Ads Scripts FAQ to avoid the same mistakes I made: https://nilsrooijmans.com/google-ads-scripts-faq/

[Gorini Roberto]

Hello Nils Rooijmans,

First, open the copy of https://docs.google.com/spreadsheets/d/1Tj-UPGaTONtUbTAGCuJ2j_8hEABCBRr7bUH7b2aFh88/copy

You will then receive a copy in your Drive. Use the link that has been generated. Then, it will no longer be a copy.

Insert the sharing link into the script of your Ads account 'spreadsheet_url': 'YOUR_SPREADSHEET_URL',

You need to have an admin account to share it at that point.

Feel free to reach out if you continue to encounter issues.

Best regards,

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for getting back to us.