Google Workspace addon with BigQuery for usage recording

Question

I'm developing an addon of Google Workspace (Google Slides) and having an issue of BigQuery API calling by any of addon user.
An addon will be published to public not for domain only and everyone across the globe may use.
On addon, I'd like to call BigQuery job to run a query and insert a row to record a usage.
However I'm faced an issue of "Access Denied: Project XXX: User does not have bigquery.jobs.create permission in project XXX." even I can run this for developer user.
I assume that this is because lacking an access permission to BigQuery API by OAuth.
Should I grant an access to every addon user for BigQuery? Or any standard way to implement this , such as calling BigQuery API by API_KEY, service account etc?
Thank you for your help in advance!

Answer 1

等待大神答复