Page Comparison

...

1. In Sigma Studio, click Manage > Connectors.
   
   
   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: Image Added Click Cancel, if you do not want to exit the Connectors screen. Click Ok, if you want to exit the Connectors screen.

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

8. Click Ok.
9. Now, right-click the created connection and select the Create Data Source option.
   
   
   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: Image Added Click Cancel, if you do not want to exit the Data Source screen. Click Ok, if you want to exit the Data Source screen.

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

15. Click Ok.