We have BigQuery external tables that pull from google sheets, that are used upstream of views we'd like to materialize/replicate with Fivetran. Currently, when trying to pull these, we get the following error message: "error getting Drive credentials".

That is despite sharing the Google sheets with the service account used by Fivetran or providing account-wide delegation.