SAP Open Connectors

Google Sheets API Provider Setup

API Provider Setup

Follow these steps to set up a Google Sheets Application with the endpoint. Further details on this process are documented at https://developers.google.com/drive/web/enable-sdk.

Via a web browser, go to https://console.developers.google.com.

  1. Click “Create Project” Google Sheets Connected App step 1

  2. Name your project

  3. Click create Google Sheets Connected App step 2

  4. Click “APIs and auth” Google Sheets Connected App step 3

  5. Click “Credentials”

  6. Click “Create new Client ID” Google Sheets Connected App step 4

  7. Click “Web Application”

  8. Click “Configure consent screen” Google Sheets Connected App step 5

  9. Name your product and fill out other information.

  10. Click “Save” Google Sheets Connected App step 6

  11. Enter your product’s website.

  12. Copy the OAuth2 callback URL

This URL will be in your application’s address space. You will be required to retrieve some information returned on this URL by the endpoint.

For our example, we’ll use a callback URL of https://www.mycompanyapp.com/oauth2callback.

  1. Click “Create Client ID” - This will take you back to the “Credentials” Screen. Google Sheets Connected App step 7

  2. Copy the “Client ID”.

  3. Copy the “Client Secret”. Google Sheets Connected App step 8