BigQuery Permission Issue: Unable to Access Drive Credentials for Google Sheets

I am using the BigQuery node without issues until I connect the table to a Google Sheet.

I receive the error message:

BigQuery: Permission denied while getting Drive credentials.

Here’s my setup:

• I use a Google Service Account API and have enabled the HTTP Request node setup.
• My scope includes https://www.googleapis.com/auth/drive
• I have shared the Google Sheet with my service account's email.

Despite these configurations, the error persists. Any ideas on what might be causing this?