Setup

​

Pre-requisites

1. Google Cloud Developer Console.
2. Required Settings for the App. You can find it in Overview.

​

Creating an app in Google Sheets

To create a Google Sheets app and aquire the above mentioned credentials, please follow the steps mentioned below:

1. Log in to your Google Cloud Console dashboard.
2. Click on the Create Project button in the top right.

3. Enter the Project Name for your application, select Organization and Location.
4. In the Google Cloud Console dashboard, navigate to APIs and services > Credentials in the left side menu.

5. Go to your Apps catalog in Cobalt > Search for Google Sheets > Settings > Use your credentials > Callback Url > Copy it.
6. Click on + Create Credentials button in the top in the Cloud Console app and select OAuth client ID.

7. Select Web application from the Application type dropdown > scroll to Authorized redirect URIs section > Click + Add URI button > Paste the Callback Url > Click Create button in the bottom.
8. Navigate to OAuth consent screen in the left menu under APIs and services > Click on the Edit App button > Scroll down > Click Save and Continue in the OAuth consent screen section > Click Add or Remove Scopes button in the Scopes section.
9. Enter the mandatory scopes under Manually add scopes > Click on Add To Table > Click on Update > Click on Save and Continue at the bottom of the page.

10. Go to Enabled APIs and services in the left menu under APIs and services > Click on + Enable APIs and Services > Search for Google Sheets API and Google Drive API > Click on Enable for both.

11. Navigate to Credentials in the left menu under APIs and services and select the Web Client under OAuth 2.0 Client IDs. Copy the Client ID and Client Secret under Additional information section.

​

Configuring credentials in Cobalt

App settings page lets you configure the authentication settings for an OAuth2 based application. For your customers to provide you authorization to access their data, they would first need to install your application. This page lets you set up your application credentials.

Cobalt lets you use pre-configured applications to play around. You can do so by selecting Use our credentials. However, if you wish to use your own application, select Use your own credentials. Provide the aquired Client Id and Client secret and save it.

​

Configuring Scopes

Cobalt lets you configure what permissions to ask from your users while they install your application. The scopes can be added or removed from the App settings page, under Permissions & Scopes section.

For some applications Cobalt sets mandatory scopes which cannot be removed. Additional scopes can be selected from the drop down. Cobalt also has the provision to add any custom scopes supported by the respective platform.

Once the scopes has been added to the project in Cobalt, go to your Google Cloud Console dashboard and update the scopes as added on Cobalt.

Navigate to Cloud Console dashboard > Select the Project created for Cobalt > Follow the steps 8 and 9 mentioned above for adding scopes.

​

App Review for Google Sheets

Projects configured with a publishing status of In production are available to any user with a Google Account. Projects configured with a publishing status of In production should complete the verification process, including defining scopes actively requested by your project’s OAuth clients, if it meets one or more of the OAuth verification criteria.

​

To submit app for review

• In the Project, go to OAuth consent screen in the left menu under APIs and services > Choose the App type as External and click on Publish App button.
• Click on Prepare for Verification and provide the required information.
• You will be required to submit justification for the scopes requested and a demo video on YouTube which shows the scopes being used.