How to connect BigQuery module to Google Workspace with client ID and secret

Anyone have instructions on how to connect the BigQuery module to a Google Workspace account? I want to run scenarios asynchronously via webhooks but the default connection requires login every day.

On the Google Workspace side, is it best to use an Oauth client ID or service account?