Open in app
Jasper Duizendstra
111 Followers
About

Sign in

111 Followers
About
Open in app
Jasper Duizendstra

Jasper Duizendstra

Sep 23, 2019·1 min read

Hi Hoang, there is no need for a service account. This is the great thing with Apps Script, you can use the BigQuery Service: https://developers.google.com/apps-script/advanced/bigquery. This will handle the authentication for you. Do make sure the current user has write access on the dataset.

Jasper Duizendstra

Freelance Google Cloud Platform Architect, Google Workspace GDE

Thanks for the article.
1

Hoang Trinh

More from Jasper Duizendstra

Freelance Google Cloud Platform Architect, Google Workspace GDE

More From Medium

Structure and simplify your Google Apps Script (with) V8

Jasper Duizendstra in The Startup

Create JavaScript objects in Google Apps Script

Jasper Duizendstra in JavaScript in Plain English

Create BigQuery tables with Google Sheets and Apps Script

Jasper Duizendstra in Google Cloud - Community

How to get the most out of the new Google Apps Script debugger & logging

Jasper Duizendstra in Google Developers Experts

NYTimes Peru N-Word, Part Three: What Happened in the 2019 Investigation?

Donald G. McNeil Jr.

NYTimes Peru N-Word, Part Two: What Happened January 28?

Donald G. McNeil Jr.

9 Painful Signs That Your Partner Is No Longer In Love With You

Elizabeth Kasujja in Hello, Love

NYTimes Peru N-Word, Part Four: What Happened in Peru?

Donald G. McNeil Jr.

About

Help

Legal

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store