Page Comparison

...

1. Go to the following URL link:
   https://console.developers.google.com
   
    
2. Click Enable APIS and Services.
   
   
3. Search for Google Sheets API in the search box and select it.
   
   
4. Click Manage.
   
   
5. Click Credentials option from the menu on the left-hand side of the page.
   
   
   
6. Click Create Credentials and select OAuth Client ID from the drop-down list.
   
   
7. Click the Application Type drop-down and select Web Application.
   
   
8. Enter the web application name in Name field. Here, Web client is provided as the name.
   
   
9. Click ADD URI in Authorized JavaScript origins field and provide https://console.developers.google.com as the URI.
   
   
10. Click ADD URI in Authorized redirect URIs field and provide https://developers.google.com/oauthplayground as the URI.
    
    
11. Click Create.
    
    
12. Make note of the Client ID and the Client Secret information from the pop up that appears once the OAuth client is created.

...

1. In Sigma Studio, click Manage > ConnectorsConnection.
   Image Removed
   Image Added
   The Create New Connection page appears as shown in the following screenshot:
   
   
2. Click OTHERS and select the Google Sheets.
   
   
3. Enter a unique name for the connection in the Connection Name field.
4. Provide the obtained client ID in Client ID field.
5. Enter the obtained client secret in Client Secret field.
6. Similarly, provide the access and the refresh tokens in the Access Token and Refresh Token fields respectively.
   
   

7. Click Submit to save the connection.
   

   Warning
   When you try to exit the Connectors screen, before saving the configured Google Sheets connection, a warning pop-up message appears, as shown in the following screen shot: Click Cancel, if you do not want to exit the Connectors screen. Click Ok, if you want to exit the Connectors screen.

   
   
   
   A success message for creating a connection appears as shown in the following screenshot:
   
   

8. Click Ok.
9. Now, right-click the created connection and select the Create Data Source option.
   Image RemovedClick the Data Source Image Added icon on the existing Google Sheets connection.
   
   Image Added
   The Create Request page appears.
   
   
10. In the Create Request page, enter a unique data source name in the Data Source Name field.
    
    

11. Provide the Google spread sheet ID in Spreadsheet ID field.
    
    

    Note
    You can identify the spread sheet ID from your Google sheet URL.

    
    

12. Provide the spread sheet range in Range field.
    
    

13. Enter the column name and its ID on the Column Name and Column ID field. Here, Name and Task are provided as the Column Name and Column ID.
    
    

    Note
    Click plus (  ) icon to add column(s) and minus (  ) icon to delete the column(s).

    
    

14.  Click Save.
    

    Warning
    When you try to exit the Data Source screen, before saving the configured Google Sheets data source, a warning pop-up message appears, as shown in the following screen shot: Click Cancel, if you do not want to exit the Data Source screen. Click Ok, if you want to exit the Data Source screen.

    
    
    
    A success message for creating a datasource appears as shown in the following screenshot:
    
    

15. Click Ok.