To correctly parse the Google sheet and avoid any connector failures, it is mandatory to ensure the initial formatting of the Google sheet is correct.
You can learn more about how the file structure is connected with the required dimensions and metrics here.
The tab in the Google sheet should be formatted as 'standard tabular data'. This means:
The first row of the selected tab must include the headers.
Any subsequent rows must contain the values corresponding to those headers.
Here is an example of such a structure in a Google sheet:
The names as you see them in the first row or column headers will be parsed and made ‘BigQuery friendly', so they might not have the exact same name when you see them in the output table. For example, we replace non-alphanumeric characters with '_' and make everything lowercase.
Using the example above, the results in a BigQuery table will look like this:
As you can see, the original column from the Google sheet 'Target ROAS' will be named as 'target_roas' to meet the BigQuerry formatting requirements.