PMax Ads Script is Blocked - "This app is blocked - This app tried to access sensitive info in your Google Account"

[Daniel Cook]

Hi. I seem to be getting blocked while trying to run a script for one of my ad accounts. This is a script I've run without any issues for a couple of others, but I've started receiving the following error message (I've also attached it).

"This app is blocked - This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access."

I'm not sure why I've started receiving now as I've put this script into a couple of accounts without issue already. Would someone be able to help me work out what I'm doing wrong?

Google Sheet is just a blank empty Google Sheet. Script is as follows...

function main() {
 
  // enter your sheet url & the campaign ID below
  let sheetUrl = 'https://docs.google.com/spreadsheets/d/1Rd9n5rrqs8o3nE8nN78AeHtjik71xKm-qQ5-d4nvauY/edit#gid=0'; // enter sheet URL between the quotes
 let campaignId = '20033272058'; // enter pmax campaign ID between quotes

// don't touch code below this line

   let ss = SpreadsheetApp.openByUrl(sheetUrl);

 let query = AdsApp.report(
  `
  SELECT
   campaign_search_term_insight.category_label,
   metrics.clicks,
   metrics.impressions,
   metrics.conversions,
   metrics.conversions_value
  FROM campaign_search_term_insight
  WHERE
   segments.date DURING LAST_30_DAYS
   AND campaign_search_term_insight.campaign_id = '${campaignId}'
  ORDER BY metrics.conversions
  `
 );

 query.exportToSheet(ss.getSheetByName('Sheet1'));

} // end main

Thanks

Dan

[Daniel Cook]

Hi guys.

Just coming back to this for visibility. Does anyone know how I might be able to solve this?

Thanks in advance

Dan

[Jan Hahlbrock]

Hey Dan,
this is normal when you try to run an apps script for the first time, as your code looks good you can try to look for the text underneath where it says in grey underscored letters "expand" or something like that. Click there and keep going.

Best,

Jan

[Google Ads Scripts Forum Advisor]

Hi,

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

By reviewing your query, I understand that you're unable to authorize the script. I would like to convey to you that authorize error  is out of our scope of the Google Ads Scripts. I suggest you reach out to the Google Ads Product support team as they are better equipped to assist you on this.
 

This message is in relation to case "ref:_00D1U1174p._5004Q2olDML:ref"

Thanks,
 

Google Ads Scripts Team

[Eric Torres]

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/d1543356-0415-4481-9086-9380f7260622n%40googlegroups.com.

[luke maggs]

I'm getting a very similar error to Daniel? Scripts that were working in account are still fine, but even when i create a default/blank script, I am getting a similar error

"this app is blocked this app tried to access sensitive info in your google account. to keep your account safe, google blocked this access."

I cannot get past this oauth pop up and progress any further (aware of the normal dance of authorisation of scripts and this is different) 

A few days ago this was all fine (running multiple complex scripts), and now all of a sudden it does not work for any account in my Google Ads Manager account, nor for another colleague (also admin of the same MCC) 

any advice please, it's driving me insane as I need to create new  some scripts urgently! :) 

[Mike Marshall]

I know this doesn't help to solve the problem but wanted to report that I'm also experiencing this issue - looks like a wider issue from reviewing this group and the multiple threads created about this recently. I've raised it with our Google rep but would be good to confirm this is a bug?

[Ronja]

Also experiencing this over all of our accounts - found the issue on monday

[Mike Rhodes]

Ginny Marvin has just confirmed on LinkedIn that this is NOT google blocking the scripts.
This is likely some local issue - either with Sheets permissions or something else (impossible for anyone to diagnose with so little info)
Sorry it's happening to you, but glad to hear it's def not google blocking scripts.

Have you used the same email/domain for the sheets & the account with the script?
Have you given the script permissions?
Is there an apps script running on that sheet?

sorry - there's just a lot of reasons why something might be blocked!

[Mike Marshall]

Thanks for the details Mike, I saw your post on LinkedIn - good news that it's not a tactical choice by Google at least :)

Here are some answers to the questions you highlighted:

Have you used the same email/domain for the sheets & the account with the script? - Yes, accessing Ads via an MCC account with the same email as the Google account where I've created the sheet (using the URL sheets.new to do so)
Have you given the script permissions? - The error occurs when I try to authorise the script, but the correct Shopping content advanced API access box has been checked.
Is there an apps script running on that sheet? - No app scripts in the sheet, it's a brand new blank document with updated sharing permissions.

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for getting back to us.

By reviewing your concern, I understand that you are getting the issue “This app is blocked” when trying to authorize a script.

I would like to inform you that our team is currently working on this issue. One of our teammates will get back to you once we have an update on this. Meanwhile, your patience is appreciated.
 

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

Thanks,
 

Google Ads Scripts Team

[Fabiano Lira]

Same problem here and with Google Apps Scripts too.

[Thomas Langguth]

same problem here since today.. i can´t authorize a new simple hello world script because the authorisation is blocked... i knew this problem from apps scripts in sheets when you need to have a  Google Cloud Platform project Number.

 But I have no idea what´s going on in google ads scripts...

Found out that i can (re)authorise older scripts,  but not new ones .. When to choose an account it says continue to unnamed script, but the script already has a name and is saved.. even when i click on the saved name of the script to open it and try to authorise.

Problem is with multiple google-accounts that have permission to the google ads accounts.

Hope that helps

[charlesb...@gmail.com]

Hi,

I'm seeing the same thing as Thomas, and from what I've read we're not alone.

The scripts won't authorise with or without sheets so I doubt that's the issue.

Google have said they aren't blocking scripts...I think they mean they aren't blocking scripts on purpose.

Thanks

[charlesb...@gmail.com]

Hi,

It appears there's a workaround:

1) Add a new Google Ads user

2) Authorize the script with the new user

3) Click "Advanced"

4) Click "Go to Test (unsafe)"

And Bob will hopefully be your uncle.

Same info with screenshots: https://shabba.io/blog/4

[Thomas Grübel]

I have the same problem with different users here. Any real solution?

[Google Ads Scripts Forum Advisor]

Hi,

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

[Roy Bellingan]

Same error for me,

[Aaron Bridgens]

Came here just to say that I have the same issue. I tested a script with just a single log command and still receiving the "app is blocked" error when I attempt to authorize the script.

[Haley T]

Having the same issue as well. Everything was fine yesterday, but now we can't authorize any new scripts. 

[Roy Bellingan]

What worked for me was just to use a new clean profile in the browser.

Same user, same all, just create a new profile, in firefox on linux start with

firefox  -profilemanager

No idea on windows, maybe you have to edit the link ?

[Kristin Bradford]

1) Add a new Google Ads user

2) Authorize the script with the new user

3) Click "Advanced"

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/29898fa2-da2e-4d95-8836-bb6ea46a574bn%40googlegroups.com.

[Maria Arnold]

-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---

On Wed, Oct 25, 2023 at 1:38 AM Thomas Grübel über Google Ads Scripts Forum <adwords...@googlegroups.com> wrote:

[Christian Mcqueen]

ok

On Wed, Oct 25, 2023 at 1:38 AM Thomas Grübel über Google Ads Scripts Forum <adwords...@googlegroups.com> wrote:

[Stella Mckenzie]

I have gone through the instructions in this group in detail but I am not seeing the any changes being made in the account when the script runs. 

I have only one modification in place, I want it to double the bids when it is raining. 

On Wed, Oct 25, 2023 at 1:38 AM Thomas Grübel über Google Ads Scripts Forum <adwords...@googlegroups.com> wrote:

[Ronja]

Hey all, is there any update yet? Can any of you authorise scripts again? (I can't)

[Raji Gill]

ok

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/c0f4dbeb-1815-4895-a411-afbe7c0feb96n%40googlegroups.com.

[Marilou]

Same issue here

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for getting back to us.

[Raji Gill]

thanks

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/ae170c61-8941-4e56-84a4-548061c6ad48n%40googlegroups.com.

[Visie Tubban]

Using your service for outreach, some of our clients have seen over 71% improvement in their conversions within a month of going live

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/1a4ceab5-f653-4c84-9ef7-63d93c89677en%40googlegroups.com.

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for getting back to us.

I would like to inform you that our team is currently working on this issue. One of our teammates will get back to you once we have an update on this. Meanwhile, your patience is appreciated.
 

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

Thanks,
 

Google Ads Scripts Team

[Nils Rooijmans]

Here are four ways to get around the issue in the meantime:

(If you don’t know how to install and run Google Ads Scripts yet, check out my guide on how to install Google Ads Scripts.)

SOLUTION 1:
Find the ‘Advanced’ link in the pop-up, click it, and then click “Go to Test (unsafe)”.
NB: It’s not unsafe unless you run scripts that are unsafe.

If you cannot find the link, or this isn’t working for you, move on to

SOLUTION 2:
Try authorizing the script with a different user account that has access to the Google Ads account (or create a new user for this purpose).

If this also isn’t working for you, move on to

SOLUTION 3:
Fix access restrictions in your Google Workspace:
Go into admin.google.com > API Controls > Google services > add ‘Apps Script Runtime’ (set to unrestricted)

If this also isn’t working for you, move on to

SOLUTION 4:
re-use an old script you’ve already authorized and don’t use anymore and replace the old code with your new code.

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/

[Khan Sab]

thanks

Vào Th 5, 16 thg 11, 2023 vào lúc 20:57 Nils Rooijmans via Google Ads Scripts Forum <adwords...@googlegroups.com> đã viết:

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/9b9ad84c-961b-49a4-9250-06a22a08b207n%40googlegroups.com.

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for getting back to us.

Please try the solution provided by @Nils. Meanwhile One of our teammates will get back to you once we have an update on this.

[Google Ads Scripts Forum Advisor]

Hi,

We have an update.

I would like to inform you that the issue has been resolved for the new scripts. So, I request you to duplicate the existing script, try the authorization flow again on a new script and confirm us.

If the issue still exists, kindly provide us with the below details to further investigate the issue.

• Google Ads account ID / CID
• The name of the new script

[Pascal Schumacher]

Hi,

unfortunately I still have the issue. 

I have tested it with a completely new script.

Thanks,

Pascal

[pmoe...@binaerpark.de]

Same here

[Ronja]

Same here, still not able to authorize scripts

[Mike Marshall]

I've duplicated a script that wasn't working and still having issues. CID is 855-722-5268 and the script is called "all time bestsellers 2".

[Robin]

This issue has been getting fixed for over a month now, and it's not clear what's causing it. We're also not sure if it can be successfully resolved in 2023. It's really frustrating for those who need to manage ads in bulk, and we really hope this problem can be resolved soon.

[Raji Gill]

thanks

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/daba7fac-6f2f-4014-a693-c1f93f6299d7n%40googlegroups.com.

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for getting back to us.

I would like to inform you that our team is currently working on this issue. One of our teammates will get back to you once we have an update on this. Meanwhile, your patience is appreciated.
 

[Roy Bellingan]

no one is working on this issue.
Please stop spamming you own forum with the same answer, this problem is going on since YEARS.

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for getting back to us.

Please be informed that our team is actively addressing this matter, and currently, there are no new updates to share. We value your patience in this regard. 

[Google Ads Scripts Forum Advisor]

Hi,

We have an update.

I would like to inform you that the issue has been resolved for the new scripts. So, I request you to duplicate the existing script and try the authorization flow again on a new script and confirm us?

If the issue still exists, kindly provide us with the below details to further investigate the issue.

• Google Ads account ID / CID

• Name of the new script