This guide will walk you through creating a Google Auth client for Google Sheets in a structured manner, and use the credentials created on Keragon dashboard.
Go to console.cloud.google.com
1. Go to console.cloud.google.com
First, visit the console.cloud.google.com page.
2. Click "Create project"
Go to Google developer console, cloud resource manager, and start by creating a new project.
3. Fill in the "Project name" field
Enter your desired project name, for example, "Keragon Google Sheets Project".
4. Click "Create"
Proceed by clicking the Create button.
5. Click "Select Project"
Select the newly created project.
6. Click the menu icon
Click the menu icon at the top right.
7. Click "Enabled APIs & services"
Access the "Enabled APIs & services" section.
8. Click "Search" field
Look for resources, docs, and products.
9. Search "Google Sheets API" and select it from the dropdown
Enter "Google Sheets API" in the search bar and select it from the search results.
10. Click "Enable"
Enable the Google Sheets API.
11. Click here
Go back to the "Enabled APIs" dashboard.
12. Click "OAuth consent screen"
Access the "OAuth consent screen" section.
13. Click "internal"
Select the Internal option under User Type.
14. Click "Create"
Click CREATE.
15. Set the "App name"
Proceed by selecting and filling the app name field. For example "Keragon Google Sheets App".
16. Set the User support email field
Select the email address from the dropdown.
17. Add an email address under Developer contact information
Sent an email address under Developer contact information.
18. Click "Save and continue"
Save and proceed to the next step.
19. Click "Add or remove scopes"
Access the option to add or remove scopes.
20. Fill "https://www.googleapis.com/auth/spreadsheets" and "https://www.googleapis.com/auth/drive"
Select the Manually add scopes field and add the appropriate scopes. Please add them one at a time.
21. Click "Add to table"
Include the scope in the table.
22. You should these two checked here then click "Update"
Update the changes made.
23. Click "Save and continue"
Save and move on to the next step.
24. Click "Back to dashboard"
Return to the dashboard.
25. Click "Credentials"
Access the Credentials section.
26. Click "Create credentials"
Create new credentials.
27. Click "OAuth client ID"
Select the option for OAuth client ID.
28. Click "Application type"
Click the Application type field.
29. Click "Web application"
Choose the Web application option.
30. Click "Add URI"
Add new URIs under Authorized redirect URIs.
31. Fill "https://api.us-east-1.keragon.com/rest/auth/callback"
Enter the URI here.
32. Click "Add URI"
Add the URI to the list and add another one.
33. Fill "https://api.us-1.keragon.com/rest/auth/callback"
Enter the second URI here.
34. Click "Create"
Create the credentials.
35. Copy your Client ID and Client Secret
Copy the Client ID and secret and paste them in your Keragon dashboard Google Sheets authentication.
You are now set up to authenticate Google Sheets on Keragon dashboard and start building your HIPAA-compliant workflow.