Hello all, I am new to Meltano extractors/loaders and am working on a project for a data science course along with a couple buddies. We are running into the following error (see images) when running 'meltano run tap-google-sheets target-bigquery': We verified that the google sheets extractor was not the problem with the built in 'test' command (https://hub.meltano.com/extractors/tap-google-sheets/#settings). Additionally, the only parameter we set for the bigquery target was 'project-id' and all others were set to default. We are running python 3.9.16 and meltano 2.17.0

Can you check your client_secrets.JSON file? What keys are present? Dont share the whole contents obviously! There's an example of the typical file contents halfway down the page here: https://practicaldatascience.co.uk/data-engineering/how-to-create-a-google-service-account-client-secrets-json-key