Issue connecting Google Ads OAUTH

Matillion ETL
1

I've been attempting to add a Google Ads Data connector in my Matillion instance and I have followed all the steps in our Google Cloud instance for setting up the OAuth in OAuth consent screen and OAuth credentials and made sure the Google Ads API is turned on but any time I input the client secret and client id and then click the authorization link I am getting this message "Access blocked: Authorization error - device_id and device_name are required for private IP".

 

What steps I have taken to resolve:

  • This Google Ads API is setup as web application and I made sure the google account we are using is setup as a test user
  • I made sure the URL we have set up that our callback URL re directs to is setup as an approved URI in the credentials.
  • I have reset the client secret multiple times and then tried to connect and I still get the same error message.

 

Does anyone have any other tips or ideas on what I can try to get this connected?

2

Hi @JoeBarkley​ and thanks so much for joining us on the forums.

If you're still having issues getting this sorted, could I suggest you take a look at the following documents if you haven't already? Google Ads Query and Google Query Authentication Guide. Let us know how you get on.

Many thanks,

Claire

3

Hello, 

Google doesn't accept a private IP address when doing Oauth calls. 

I added an entry in my Windows hosts file for the local IP on my local machine:

 

For windows, please go to the following directory: \Windows\System32\drivers\etc

Add the following entry:

192.168.1.99  fakedomain123.com

 

(With 192.168.1.99 as your Matillion IP)

 

In Google Cloud / credentials you have to add the following

- Under Authorized Javascript origins: https://fakedomain123.com

- Under Authorized Redirect URIs: https://fakedomain123.com/oauth_redirect.html

 

 

Now log into your Matillion instance with the fake url: fakedomain123.com

You should go thru the steps again in setting up your OAuth using the Client Id and Secret key from Google. 

After the status of your OAuth is "Configured" , you should be able to use it in your Google Component

 

You can log off Matillion and log on back with your private IP address and the OAuth should work.

 

I am not sure regarding how long the OAuth lasts or when it needs to be redone.

 

I hope this helps