What is it about
The Google sheets connector extracts data directly from your Google spreadsheet and makes it available for use in your BigQuery environment.
To set up this connector, please watch the video guide or follow the step-by-step explanation below.
To start working with a connector, follow these steps:
Go to Home → Data and reporting → Connectors.
Click the button 'Create new connector'.
Give your connector a name.
Ensure proper Google Sheet formatting before setting up a connector.
To ensure a connector runs smoothly, there are specific formatting requirements for the original Google Sheet.
If you plan to work with a user-defined report (see Step 2 explanation below), where you decide how the report should be structured, please review the sheet formatting requirements here.
If you plan to work with pre-defined reports (see Step 2 explanation below), the sheet should adhere to the structure/schema for these reports. You can find more guidance here.
Step 1: Choose a data source type and account
Select the data source type 'Google sheets'.
Choose a Google sheet, connected to Alvie. If no Google sheet is yet connected to Alvie, you will be prompted to connect this data source to Alvie first. To do so, simply follow this guide.
Step 2. Choose a report type
You can select one of the pre-defined reports or create your own report by choosing the user-defined report option.
There are some specifics based on the report type you choose:
Step 3: Select a date range
Select the date range to be applied to the connector. For more details, check the guide here.
Step 4: Set up data targets
Set up data targets to ensure your data is placed correctly. Follow the guide here on how to do this properly.
Step 5: Check advanced settings and activate your connector
Once you are ready, you can activate the connector and start it immediately. It is also possible to save the connector without activating it and return to it later.
