This guide walks you through the process of creating a Google Cloud App, enabling required APIs, setting up credentials, and submitting your app for verification.
This is essential for Google Sheet in integration for your customers to BotSailor. All your customers will use your admin google app to connect their google sheet and integrate with BotSailor.
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
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
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.
Here is a demo video https://youtu.be/sMjlt0LlqCQ , You must need to screencast your own video with your own app, then provide it for Google review.
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
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.
Watch the Video Tutorial:
Categories :
Stay ahead of the curve with BotSailor`s latest articles. Dive into expert analyses, industry trends, and actionable tips to optimize your experience. Explore our articles now and unlock the full potential of your business.
BotSailor is a complete WhatsApp marketing automation; it has chatbot, live chat, broadcasting, Shopify & WooCommerc...
READ MOREYou can send Woocommerce Order Notifications to customers via WhatsApp by BotSailor in a very easy and straightforward w...
READ MOREWe're delighted to announce the opening of the BotSailor Affiliate Program today! We developed it as a way to thank the ...
READ MORE
(0) Comments