# Connect BigQuery to Row Zero

Row Zero makes it easy to connect BigQuery to your spreadsheets using OAuth. The BigQuery connector is available for [Enterprise](/pricing?ref=BQ) customers. If you're already a customer, please [contact us](/contact?ref=BQ) to set up BigQuery OAuth. If you're not yet a customer, [schedule a demo](/schedule-demo?ref=BQ) to learn more.

## Create your BigQuery connection

Row Zero supports connecting to BigQuery via BigQuery OAuth. If your organization has not yet set up BigQuery OAuth in Row Zero, please [contact us](/contact?ref=BQ) to get set up. If your organization is already connected, follow the instructions below to create your connection:

1. From any Row Zero workbook, click on the 'Data' icon in the upper right-hand corner and then click the button to '+ Add connection.' 

   ![connect spreadsheet to bigquery](https://cdn.sanity.io/images/2w8agf2t/production/70912f455379154ebfd5c42e6cbbacde051a0909-1905x534.png)

2. If your organization has set up BigQuery OAuth in Row Zero, you'll see it as an option under 'Connection type'. Click 'Connect to BigQuery' and you'll be prompted to sign in. 

   ![bigquery connector](https://cdn.sanity.io/images/2w8agf2t/production/57248c7d5bfdf1e1e7a195e544a0427be22ff200-837x818.png)

3. After signing in, you'll get a message 'Succeeded. You can close this window'. Your Username will automatically fill in under Connection details  
and you can click 'Create connection' to finish connecting. 

![Add BigQuery connection in Row Zero](https://cdn.sanity.io/images/2w8agf2t/production/7a62d9dfd9e8b69d392a51ea72b50e9f4a366eb1-842x819.png)

## Write a query to import BigQuery data

Now that BigQuery is connected to your spreadsheet, you can import data by writing queries directly from Row Zero.

1. From any workbook, click the "+" sign next to your BigQuery connection to insert a connected table. This adds a data table to your spreadsheet that is connected to BigQuery and opens a query editor. 

   ![add bigquery connected table to sheet](https://cdn.sanity.io/images/2w8agf2t/production/c74125a759e89d25f947850fcd4109795eea3ddc-635x360.png)

2. Write a SQL query and click 'Run' to execute the query and import the queried BigQuery data to your spreadsheet. 

   ![import BigQuery data to your spreadsheet](https://cdn.sanity.io/images/2w8agf2t/production/9a26014fa07ac97ef79fbe492fe3321cd3ee1995-1906x936.png)

3. The BigQuery data imports directly into a [connected table](/docs/data-tables#connected-tables), a dynamic, condensed view that makes  
it easy to refresh and analyze data. Double click on the connected table to re-run your query for the latest data.
4. Once you've imported your BigQuery data, you can build out your connected spreadsheet, adding [computed columns](/docs/data-tables#add-new-columns-or-computed-columns), [pivot tables](/docs/pivot-tables), [charts](/docs/charts), and more.