Important: please ensure you've disabled Adblock to proceed to the Google Sheets connection setup.
Authorize your Google account via OAuth. Before authorization, please, make sure that you are signed in to the account that has at least the permission to view the spreadsheet with your data for extraction.
Grant Improvado permission to see and download your spreadsheets (including settings and metadata)
After the connection process is completed successfully, the Google Ads connection will appear in your Connected Sources list.
How to extract data from Google Sheet
Click on Extract to set up data extraction from your connected Google Spreadsheet.
{%docs-informer warning title="Important"%} The Google Sheet Integration allows only one Extraction per spreadsheet. If you create an Extraction for the same spreadsheet using a different Connection, it will update the existing Extraction in the origin Connection, and a new Extraction will not be generated. {%docs-informer-end%}
Step 1 - Import
Provide us with the required Google sheet URL and click the Import button to run the check (if the link is correct and the spreadsheet is available)
Select the tab. If your sheet consists of several tabs, then you need to select a tab with the required data.
The first line of the spreadsheet must be a column’s title. If additional information is provided before the column titles — it is necessary, use the Header rows to skip field to skip a certain number of rows to import data correctly.
Click on the Continue button.
Step 2 - Match
Set the Table name which will be used for loading data to your destination.
Configure thescheduling settingsthat are the same as for regular data extraction flow.
Select the columns you need to import. By default, all columns are selected.
Check the type. Each column in a data table can be assigned a text, number, or date type.
~The date column is a unique date-key in the database and should be singular. Also, you have the flexibility to choose from a wide range of date formats for this column.
~Note: The date format you select from the dropdown indicates the date format in that column of your spreadsheet and helps us correctly parse dates in that column. But it is not the date format that will be stored in Improvado.
~If you have column with numeric values that you don't want to include in your calculations, change the type from Number to Text.
The skip rule allows you to exclude empty rows and rows with specific values in a selected column
~Default to 'Do Not Skip': Ensures all data is initially included.
~Multi-Select Options: Combine 'Skip: empty' and 'Skip: value' for targeted exclusions. Selecting 'Do Not Skip' disables other skip options.
~Custom Rule addition: Add one custom rule; the form is disabled afterward to maintain focus
~Custom Rule deletion: Hover over and click on the red-highlighted basket icon next to the rule to exclude it.
Usage Note: the component is designed for straightforward value-based selections and does not support complex expressions like '<10'.
{%docs-informer info title="Note"%} System default account ID, account name, and date_yyyymmdd columns are automatically added by default. The 'id', 'metrics', 'account_id' reserved for internal usage. Please do not import columns with the same names to avoid data issues. {%docs-informer-end%}
Click on the Import N columns button to continue.
Step 3 - Preview
Check the structure of data that will be extracted.
Once you've reviewed the columns, click the Continue button to confirm settings and proceed with data extraction.
{%docs-informer info title="Note"%} Data discrepancy may occur if you edit data in the connected Google Sheet tab during or right after the scheduled extraction. {%docs-informer-end%}
How to edit the fields setup
{%docs-informer warning title="Important"%} We currently do not support updating fields in flat data. If you need to modify the field type or skip rule, delete the Extraction and create a new one. {%docs-informer-end%}
.png)
.png){kind=logo}
.png){kind=logo}
.png){kind=logo}
