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”

2. Name your project

3. Click create

4. Click “APIs and auth”

5. Click “Credentials”

6. Click “Create new Client ID”

7. Click “Web Application”

8. Click “Configure consent screen”

9. Name your product and fill out other information.

10. Click “Save”

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.

13. Click “Create Client ID” - This will take you back to the “Credentials” Screen.

14. Copy the “Client ID”.

15. Copy the “Client Secret”.