Load data from a Google Sheet to a BigQuery database.
Read data from a range of cells in a Google Sheet and use it to create rows in a table in a BigQuery database.
Credentials to use to access the Sheet.
Specify the shareable URL link of the Sheet with the data that you want to load.
Specify the range of cells with the data that you want to load.
Credentials to use to access BigQuery.
Specify the unique identifier of the Google Cloud project that contains the dataset where the data will be loaded.
Specify the name of the dataset that contains the table where the data will be loaded.
Specify the name of the table where the data will be loaded.
Optionally specify the region where the dataset is located.
Specify the name of each column, in matching order, that map to the columns in the Cell Range.
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.