Database Reference
In-Depth Information
Figure 12.1
Enabling Apps Script in Google Drive
You may be asked to authorize Google Apps Script. In the process of getting
BigQuery enabled, you may see the authorization page again; if so, you
should click allow each time. The authorization that you'll be prompted for
doesn't do anything particularly scary; it just allows Google Apps Script to
access your data in BigQuery. This makes sense because if you want to run
a BigQuery query in your spreadsheet, that spreadsheet needs to see your
BigQuery data.
Creating an Apps Script in Your Spreadsheet
The hard part is over, right? Unfortunately, there are 37(-ish) other steps
needed to start using BigQuery in your Google Spreadsheet. Fortunately,
none of the steps are difficult.
Although you can create a standalone Apps Script directly from Google
Drive, these scripts cannot be used from within a spreadsheet. It is an easy
mistake to start out with a standalone script and then try to connect it to
your spreadsheet; however, as we found out the hard way, this doesn't work.
