You can't use this until you register with us!

Description

Load data from a Google Sheet to a BigQuery database.

Purchasing Options

Google Sheets to BigQuery Loader - $99.99 / month

Available Actions

Load Data

Read data from a range of cells in a Google Sheet and use it to create rows in a table in a BigQuery database.

Variables

Source Parameters
google_connection required

Credentials to use to access the Sheet.

sheet_link required

Specify the shareable URL link of the Sheet with the data that you want to load.

range required

Specify the range of cells with the data that you want to load.


Destination Parameters
big_query_connection required

Credentials to use to access BigQuery.

project_id required

Specify the unique identifier of the Google Cloud project that contains the dataset where the data will be loaded.

dataset required

Specify the name of the dataset that contains the table where the data will be loaded.

bigquery_table required

Specify the name of the table where the data will be loaded.

region

Optionally specify the region where the dataset is located.

to_columns required

Specify the name of each column, in matching order, that map to the columns in the Cell Range.

flag_append required

If enabled, the rows of data from the Sheet will be appended to the rows in the table. If disabled, the existing content in the table will be deleted.