Google Sheet Credentials setup

1

Hello Everyone, I am currently trying connect to a google sheet where i will be pulling and pushing data to. However i am getting an issue setting up the credentials for these jobs.

I am running running the lightning v2.10.5 via docker.

I followed this link as well HTTP to GoogleSheets Workflow | OpenFn/docs

While setting up the credentials after selecting sign in with google sheet i get the following error.

Screenshot 2024-12-06 155906
Screenshot 2024-12-06 155906681Ă—867 36.1 KB

Screenshot 2024-12-06 155700
Screenshot 2024-12-06 1557001100Ă—613 31.1 KB

Any ideas as to what the issue could be?

2

Looks like the Oauth client you’ve built in Google Cloud Platform isn’t using the same redirect URL as you’ve configured in your Oauth Client on Lightning!

Can you check to make sure that your client on lightning has all the same deets as whatever you’ve built in GCP?

1 Like
3

Thank you that solved the issue.

1 Like
4

Awesome! So glad to hear it :heart: