Configure Google Cloud App and Submitting for Review for Google Sheet

This guide provides step-by-step instructions for creating a Google Cloud App, enabling the necessary APIs, setting up credentials, and submitting your app for verification. This setup is crucial for integrating Google Sheets with BotSailor, allowing your customers to connect their Google Sheets to BotSailor through your admin Google app.

Step 1: Create a New Project

1. Navigate to the Google Cloud Console: https://console.cloud.google.com
2. Log in and click the Select a Project dropdown at the top of the page.
3. Click on New Project.
4. Give your project a meaningful name (e.g., "Bizzfair Sync App").
5. Select your Billing Account (if applicable) and organization (if required).
6. Click Create.

Your project is now created and ready for configuration.

Step 2: Enable Required APIs

1. In the Google Cloud Console, go to API & Services from the left-hand menu.
2. Click on Library to search and enable the required APIs.
3. Search for Google Drive API:
   - Click on Google Drive API and then click Enable.
4. Search for Google Sheets API:
   - Click on Google Sheets API and then click Enable.

Both APIs are now activated for your project.

Step 3: Create Credentials

1. Navigate to API & Services > Credentials from the left-hand menu.
   2. Click on Create Credentials and select OAuth 2.0 Client IDs.
   3. A prompt will appear to set up the OAuth consent screen. Click on Configure consent screen.

Step 3.1: Configure OAuth Consent Screen

1. Choose User Type: Select External if your app is for users outside your organization.
2. Click Create.
3. Provide the following details:
   - App Name: Choose an appropriate name for your app.
   - User Support Email: Enter your support email address.
   - App Logo: Upload your app's logo.
   - App Domain: Add your app's homepage.
   - Authorized Domains: Specify the authorized domain(s) where your app will be hosted.
   - Developer Contact Information: Enter your contact details.

Once completed, click **Save and Continue**.

Step 3.2: Generate Client ID and Secret

1. Return to the Credentials page and click Create Credentials > OAuth Client ID.
2. Choose Application Type:
   - For web apps, select Web Application.
3. Fill in the required fields, including Authorized Redirect URIs:
   - You can find this in your system under Settings > Google Options.
4. Click Create.

Your Client ID and Client Secret will be generated. Copy these and input them into your system in the appropriate fields, then save.

Step 4: Submitting Your App for Review

1. Go to the OAuth Consent Screen and scroll down to the Publishing Status section.
   2. Click on Publish App to publish your app.
   3. Click Edit App, review the provided information, scroll down, and click Save and Continue.

Step 4.1: Add and Justify API Scopes

1. Under Scopes, click Add Scope. Add the relevant permissions your app requires, including:
   - https://www.googleapis.com/auth/userinfo.email
   - https://www.googleapis.com/auth/userinfo.profile
   - https://www.googleapis.com/auth/drive.file
   - https://www.googleapis.com/auth/spreadsheets
   
2. Under How will the scopes be used?, describe how your app will use each requested Google API.
3. Create a demo video showing how the scopes will be used. Upload the video to YouTube and provide the link.

Click Save and Continue when done.

<

Review the summary and click on Prepare for Verification

Step 4.2: Provide Privacy Policy and Terms of Service

1. Ensure you have valid URLs for your app's Privacy Policy.
2. Enter these URLs in the corresponding fields and click Save and Continue.

Step 4.3: Submit for Verification

1. Once the verification details are complete, click Submit for Verification.

Step 5: Verification Process

Google will now review your app to ensure it complies with their policies. The review process may take several days to a week. You will receive email notifications if additional information is needed or when your app is approved.

Once your app is verified, you can start using it with the Google Drive and Google Sheets APIs for data synchronization or other functionalities.