IP Whitelist

[Peter Valenta]

Hello,

I am planing to connect to an external mysql database with urlfetchapp. What ip address(es) should I whitelist in the database. Ie what ip addresses will urlfetchapp in ads script use?

I found this list which I am guessing might be the one ads scripts services use as well. Please can you confirm? https://www.gstatic.com/ipranges/goog.txt

It is referenced from a article regarding google private cloud:  https://cloud.google.com/vpc/docs/configure-private-google-access#ip-addr-defaults

Cheers,

[Google Ads Scripts Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-scripts/c/bpbsQMoRPbY) from the forum as it wasn't routed to our support queue. 

Cheers, 

James

Google Ads Scripts Team

[Google Ads Scripts Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-scripts/c/bpbsQMoRPbY) from the forum as it wasn't routed to our support queue. 

Cheers, 

James

Google Ads Scripts Team

[Google Ads Scripts Forum]

Hello Peter,

Thank you for reaching out to us. James here, I’ll be assisting you with your concern.

I believe that it is no longer need to use Urlfetchapp or to be allowlisted in order to connect your script to an external database. Instead, you just need to implement the JDBC service within your script. The said service allows you to connect to external databases such as Google Cloud SQL MySQL, MySQL, Microsoft SQL Server, and Oracle databases.

However, for any concerns related to the said service, I believe that it’s best if you consult this with Google Apps Scripts support team as they are more knowledgeable with the implementation and behavior of the said service. You may contact their support team by following the given instructions on this guide as they are the primary support of this service.

Please be informed that the implementation of JDBC service is already outside of our expertise. Even though it can be used in Google Ads scripts, the said service has additional functionality that we are not familiar with.

Regards,

James

Google Ads Scripts Team

[Peter Valenta]

Hi James,

excellent news, JDBC is a much better solution. 

Who would be best to contact about the ip addresses that it uses?

[Peter Valenta]

Hello again James. I fount the answer in the JDBC documentation that does confirm that it is the  https://www.gstatic.com/ipranges/goog.txt whitelist that should be used for allowing jdbc wrapper to connect to your database. You can close this case.

https://developers.google.com/apps-script/guides/jdbc