```Greetings I m having problems connecting to Google Ads wh Meltano #random

```Greetings! I'm having problems connecting to Go...

Felipe Solera Bosso

05/21/2025, 3:09 PM

Copy code

Greetings! I'm having problems connecting to Google Ads, where there is "Failed OAuth login", I believe I filled in the data correctly and used the format:
{
"client_id": "",
"client_secret": "",
"refresh_token": ""
}
, I wanted to know if anyone has experienced the same error and can help me, please

Edgar Ramírez (Arch.dev)

05/21/2025, 7:26 PM

Hi @Felipe Solera Bosso 👋 • How did you configure the extractor in

meltano.yml

? • What command did you run?

Felipe Solera Bosso

05/21/2025, 7:34 PM

Here's what I did: meltano.yml configuration:

Copy code

yaml
plugins:
  extractors:
    - name: tap-googleads
      variant: matatika
      pip_url: git+<https://github.com/Matatika/tap-googleads.git@v0.9.0>
      config:
        customer_ids:
          - "YOUR_CUSTOMER_ID"
        oauth_credentials: '{"client_id": "YOUR_CLIENT_ID", "client_secret": "YOUR_CLIENT_SECRET", "refresh_token": "YOUR_REFRESH_TOKEN"}'
        start_date: "2025-05-20"

Command I ran:

Copy code

bash
meltano config tap-googleads test

But I get this error:

Copy code

Failed OAuth login, response was '{'error': 'invalid_grant', 'error_description': 'Bad Request'}'

Any idea what might be wrong with the OAuth setup or configuration? Thanks!

Edgar Ramírez (Arch.dev)

05/21/2025, 7:48 PM

@Reuben (Matatika) might know better

Reuben (Matatika)

05/21/2025, 11:22 PM

@Felipe Solera Bosso You need to provide `oauth_credentials`config as

Copy code

config:
      oauth_credentials:
        client_id:
        client_secret:
        refresh_token:

Copy code

config:
      oauth_credentials.client_id:
      oauth_credentials.client_secret:
      oauth_credentials.refresh_token:

, although I'm not sure how you are not running in config validation errors currently - I tried with the same structure as yours and got an error about not providing

developer_token

(unless you have this set elsewhere) and then

oauth_credentials

not valid (as a string value).

Reuben (Matatika)

05/22/2025, 1:29 AM

Opened https://github.com/meltano/hub/pull/2023, which would (in theory) permit the

oauth_credentials

config as you have defined it (JSON string).

Reuben (Matatika)

05/22/2025, 10:27 AM

Above PR got merged, so you may have some luck trying again after running

Copy code

meltano lock --update tap-googleads

➕ 1

3 Views

Open in Slack

Previous Next