Google sheet source not detecting changed sheet name

[yoelferd]

Connector Name

source-googlesheets

Connector Version

0.9.4

What step the error happened?

Updating the connector

Relevant information

1. I created a google sheet source and authenticated and successfully tested it
2. I created a connection to our internal Google Big Query destination, successfully synced it
3. I then changed the name of the sheet from "Sheet1" to a real name.
4. I clicked "Refresh Source Schema" and kept getting "An unexpected error occurred. Please report this if the issue persists. (HTTP 500)" and the sync fails.
5. I'm going to delete my connection and start over but this capability to refresh is really basic and important.

cc @natikgadzhi

Relevant log output

Contribute

• Yes, I want to contribute