--- title: "Notes on referencing BigQuery tables generated from SpreadSheets" slug: "referencing-bigquery-tables-generated-from-google-spreadsheets" updated: 2024-10-07T05:28:38Z published: 2024-10-07T05:28:38Z canonical: "documents.trocco.io/referencing-bigquery-tables-generated-from-google-spreadsheets" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Notes on referencing BigQuery tables generated from SpreadSheets ## summary Google BigQuery tables generated from Google Sheets must be referenced with Connection Configuration using a service account with the appropriate permissions. The BigQuery tables generated from Google Sheets cannot be referenced with OAuth-authenticated Connection Configuration information. It must be referenced by Connection Configuration using a service account with appropriate authorization. 1. Create a BigQuery service account. *Please refer [here for](/docs/connection-configuration-bigquery) necessary authorization information. 2. Add the email address of the service account to the target SpreadSheet's share settings. 3. From TROCCO, go to the BigQuery Connection Configuration screen and click **here to create a service account (JSON key)**. ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/referencing-bigquery-tables-generated-from-google-spreadsheets-2024-08-29-6-0-0.png) 1. Follow the prompts to enter the required information and click **Save**. ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/referencing-bigquery-tables-generated-from-google-spreadsheets-2024-08-29-6-0-1.png) If you have any other questions or concerns regarding the use of this service, please contact a TROCCOCS representative.