Google sheet external table creation error

When I tried to create a external table via google sheet, I end up with the following error?

Error: googleapi: Error 403: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials., accessDenied

Steps done:

  • Enabled drive api in the project

  • Given the service account in the google sheet