Google Sheet connector not connecting

Casper Badenhorst shared this problem 19 days ago
Defect Logged

We have an issue connecting the google sheets connector.

Everything goes to plan up until the PIN needs to be validated. At which point it simply states that the connection could not be established.

/1e941ea027b5956fd41784eeda73bcbd

This is rather frustrating. To say that I have tried 30 times is probably an understatement.

This is the error from AWS showing OAUTH2 failure which is weird...

/3dc3b7fd19841dd7fe544b0a2b6d10dd

Any help will be much appreciated

Comments (2)

photo
1

Hi Casper,

We currently have two Google Sheets connectors on the marketplace but only the V4 version will work, due to changes in Google's authentication method. The new method now requires a ClientID and Client Secret in addition to the PIN. Also please note that it's in beta testing so may have some issues.

Are you using the V4 Google Sheets connector?

There's some guidance on creating the Client ID and Client Secret here: OAuth2 Authentication | AdWords API | Google Developers

You'll also need to enable the Google Drive and Google Sheets API Enable and disable APIs - API Console Help (google.com)

Kind regards,

Chris

photo
1

Hi Chris, yes I can confirm that we are using V4 of the connector. I will also look into the link you have sent through and will revert back ASAP.


Casper

photo
1

Hey Casper,


Just letting you know a new connector has been created to solve the authentication issue (which I think you may now have), though we're still running into some issues returning the sheets. This is being investigated and we will get back to you with updates soon.


Thanks for your patience on this!


Regards,

David

photo
1

I am not sure we have the new connector yet. We only downloaded from the Marketplace a few days ago. Mind emailing me a link to download it?

I don't mind waiting for the issues to be resolved...

photo
1

Hi Casper,

There are definitely issues with the new Connecters so once it is resolved and a new-new Connector is uploaded to the Marketplace I will let you know.

Cheers,

Neal

photo
1

Thanks @Neal.

We have used the connector and it connects. The issue is that no data is being returned as indicated in a previous post by David. Here is the results:

b614f8535542d6e8bc87489cb15913a6

photo
1

Thanks Casper,

Yeah, that's that's what we're seeing too. I'm keeping an eye on this one and hopefully we'll have it sorted soon.

Cheers,

Neal

photo
1

HI Neal,

Just following up - any ETA on a revised connector release? Happy to help test if needed.

-Andrew

photo
1

Hi Andrew,

The connector is in code review at the moment (which will also need testing), but there is progress being made. I will keep you updated as I get more.

Cheers,

Neal

photo
1

Thanks for the update.

photo
1

Hi Neal,

I just thought that I would check in. Do we have any progress on the testing or an ETA on the release?

Thanks,

Casper

photo
1

Hi Casper,

Not at this stage unfortunately, but there looks like there is a Yellowfin code change that needs to happen as well, which would mean an upgrade of Yellowfin, not just a new connector. This is not the sort of news we wanted to have, but I will keep you up to date on this as much as I can. This change needs review, so I am unsure of the timeline at this stage.

Cheers,

Neal

photo