[Bug]: intermittent 500 error on selecting gsheets

[rohan-arthur]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

I've not seen this on prod(app.appsmith.com), but this happened during a user test when the tester attempted to add a gsheets datasource.

Watch this user test from 01:17

Steps To Reproduce

not consistently reproducible, but here's what the tester tried to do:

1. click + to add a new datasource
2. select Google sheets
3. leave the scope option as it is and click Save and authorize
4. on the google popup for giving access, click ok --> 500 error

Public Sample App

No response

Environment

Production

Severity

Medium (Frustrating UX)

Issue video log

No response

Version

Cloud

[ganeshapp]

I get the same error while running appsmith-ee on localhost in a docker on a mac. I am able to connect to other datasources like mysql db, postgres etc. as well as Rest APIs, but I get the same error when I try to add google sheets. It goes to this URL https://cs.appsmith.com/api/v1/integrations/oauth/authorize?appsmithToken=undefined

And have the following error: {"responseMeta":{"status":500,"success":false,"error":{"code":5000,"message":"Internal server error while processing request"}}}