1. create new Google Cloud Project:

• https://developers.google.com/workspace/guides/enable-apis
• https://console.cloud.google.com/projectcreate

2. Enable the APIs you want to use in your Google Cloud project.

• https://developers.google.com/workspace/guides/enable-apis
• https://console.cloud.google.com/workspace-api/products?project=

Google Driver API: to access google driver Google Sheets API: for google Sheets

3. Learn how authentication and authorization works when developing for Google Workspace.

• https://developers.google.com/workspace/guides/auth-overview

4. Configure the OAuth consent screen and choose scopes

• https://developers.google.com/workspace/guides/configure-oauth-consent
• https://console.cloud.google.com/apis/credentials/consent https://console.cloud.google.com/apis/credentials/consent/edit?project=

click Add or Remove Scopes. We recommend the following best practices when selecting scopes

• Follow this: https://developers.google.com/workspace/guides/configure-oauth-consent
• But just accept non sensitive

5. Create access credentials to authenticate your app's end users or service accounts.

• https://developers.google.com/workspace/guides/create-credentials
• https://console.cloud.google.com/apis/credentials?project=

"+ CREATE CREDENTIALS"

6. Enable the API https://developers.google.com/sheets/api/quickstart/java-

• https://console.cloud.google.com/apis/enableflow?apiid=sheets.googleapis.com&project=