Google Sheet connector not connecting

Casper Badenhorst shared this problem 3 months 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
1

Hi Neal,

Just wanted to ask if the necessary code change was included in the most recent release on March 16th?

-Andrew

photo
1

Hi Andrew,

This issue is still be resolved, but we are pushing to get a working solution available as soon as we can. I will let you know when something else comes through.

Cheers,

Neal

photo
1

Hi Neal,

Just chasing an update on this if available

Thanks!

photo
1

Hi Andrew,

There is testing underway of the new connector as well as the code change required for this to work, though there are still some issues to be resolved. I will keep checking in on this and let you know where it's at.

Cheers,

Neal

photo
1

Hi Neal, it has been some time since we have had an update on this. Could you please let us know where we are with this?


Casper

photo
1

Hi Casper,

Thank you for your patience on this. Both the new connector and the required code changes have been earmarked for the 8.0.10 and 9.6 releases which are due out mid-late June. Once the testing has been completed on this I will give you a final confirmation that it is going to be fixed as part of that release.

Cheers,

Neal

photo