Documentation

How to connect Google Sheets

1. Select the Google Sheets tile

Important: please ensure you've disabled Adblock to proceed to the Google Sheets connection setup.

2. 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.
3. Grant Improvado permission to see and download your spreadsheets (including settings and metadata)
4. 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.

Step 1 - Import

1. 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)

{%docs-informer info title="Note"%} You can check out the Data format requirements. Follow the Storylane guide with helpful hints and get access to the Improvado Spreadsheet Template. {%docs-informer-end%}

2. Select the tab. If your sheet consists of several tabs, then you need to select a tab with the required data.
3. 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.
4. Click on the Continue button.

Step 2 - Match

1. Set the Table name which will be used for loading data to your destination.
2. Configure the scheduling settings that are the same as for regular data extraction flow.

3. Select the columns you need to import. By default, all columns are selected.
4. Check the type. Each column in a data table can be assigned a text, number, or date type.
5. ~The date column is a unique date-key in the database and should be singular.
6. ~If you have column with numeric values that you don't want to include in your calculations, change the type from Number to Text.

5. The skip rule allows you to exclude rows with specific values in a selected column.
6. ~For example, you can use it to keep certain campaigns in the spreadsheet but skip them during extraction based on their campaign name. ~You can also use it to exclude rows with total values.
7. ~Please note that regular expressions or rules such as '<10' are not supported."

{%docs-informer info title="Note"%} 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%}

6. Click on the Import N columns button to continue.

Step 3 - Preview

1. Check the data structure by the first row of data that will be extracted.
2. 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%}