Settings for Google Sheets/Google Analytics

This page helps you set up the Google Sheets and Google Analytics connections.

1. In your Web browser, go to https://console.developers.google.com/.
2. In the Email or Phone field, enter your email address or phone number and click on Next.
   
3. Enter your password and click on Next.
4. In order to use Google API, you must have at least one Project created. If you already have a Project, go directly to step 5. Otherwise do as follows:
   1. In the Dashboard tab, click on Create project.
      
   2. Enter a name for your project, select the Location where you want the project to be created and click on Create.
      
5. Once your project is selected, in the upper bar, click on Enable APIs and Services.
   
6. In the API Library, use the Search Bar to select the API you want to enable:
   1. Enter Google Sheets or Google Analytics depending on the one you want to activate and click on it.
      
   2. Click on Enable.

7. Use the Search Bar to find Google Drive, then click on it.
8. Click on Enable.

9. In the upper-left hand corner click on the Navigation Menu, mouse over API &Services and select OAuth consent screen.
   
10. Under the User Type section, select External and click on Create.
11. On the OAuth consent screen:
    1. In the Application name field, enter a name for the application to better identify it in the list.
    2. Click on Add scopes to define the Permission Level you want to grant to this application.
    3. In the Authorized Domains field, enter the Data Sync server and your company domain.
       
    4. At the bottom of the page, click on Save to finish.
       
12. In the left menu, click on Credentials.
    
13. In the upper bar, click on + Credentials and select OAuth Client ID.
    
14. In the Application Type section, select Web Application.
15. Enter a name for the application to better identify it in the list.
16. Define the Restrictions section according to your preferences and click on Create.
    

17. Click on OK to close this window.
18. Under the OAuth 2.0 Client IDs section, click on the Client you have created.
19. In another browser tab, go to Data Sync and create a new Source Connection.
20. In the list, select Google Sheets or Google Analytics.
21. Copy the Callback URL address from the field in Data Sync.
    
    
22. Back to the Google API tab, under the Authorized redirect URI section, click on Add URI, and paste the Callback URL address into this field.
    
23. In the right section, copy the content in the Client ID and Client Secret fields and paste it into their respective fields in Data Sync.
24. Come back to the Google API tab and click on Save to finish the setting of this Client.
25. Come back to the Data Sync tab, and in the Description field, enter a name for this Source connection. Change the other settings (Tracking type etc.) according to your preferences.
    
26. Click on Save.

27. Click on Allow to finish.

Extraction with Google Analytics

Once you have also created a Destination connection (refer to Add a Source and Destination Connection for Google Analytics, you will need to Add an Extraction and Setup the Extraction Panel to retrieve data.

After clicking on Create, a pop-up window appears so that you can choose the Tables and Views you want to retrieve data from.

• Select the Tables and Views you want to use and click on Save.
  

When adding a View, all Columns are selected by default. In order to comply with the limitations imposed byGoogle, you need to make sure that a maximum of 10 Metrics (Measures) and seven Dimensions are selected.

1. In the Tables list, click on the number under the Fields column to make your selection.
   
2. Tick the Sync checkboxes of the Fields you want to use.
3. Once you're done, go back to the Tables list.

For View type tables, a Filter specifying a date range needs to be set.

• In the Tables list, under the Filter column, click on the pencil icon on the row of a View type table.
  
• Enter the following Query as follows by replacing the mention 'DATE_VALUE' with values of a date range:
  

  StartDate='DATE_VALUE' AND EndDate='DATE_VALUE'

  
  
• Click on Save to finish.