
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 theGoogle Cloud Console: https://console.cloud.google.com
2. Log in and click theSelect a Projectdropdown at the top of the page.
3. Click onNew Project.
4. Give your project a meaningful name (e.g., "Bizzfair Sync App").
5. Select yourBilling Account(if applicable) and organization (if required).
6. ClickCreate.
Your project is now created and ready for configuration.
Step 2: Enable Required APIs
1. In the Google Cloud Console, go toAPI & Servicesfrom the left-hand menu.
2. Click onLibraryto search and enable the required APIs.
3. Search forGoogle Drive API:
- Click onGoogle Drive APIand then clickEnable.
4. Search forGoogle Sheets API:
- Click onGoogle Sheets APIand then clickEnable.
5. Search forGoogle People API:
- Click onGoogle People APIand then clickEnable.
6. Search forGoogle Contacts API:
- Click onGoogle Contacts APIand then clickEnable.
Both APIs are now activated for your project.
Step 3: Create Credentials
Step 3.1: Configure OAuth Consent Screen
1. ChooseUser Type: SelectExternalif your app is for users outside your organization.
2. ClickCreate.
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 theCredentialspage and clickCreate Credentials > OAuth Client ID.
2. ChooseApplication Type:
- For web apps, selectWeb Application.
3. Fill in the required fields, includingAuthorized Redirect URIs:
- You can find this in your system underSettings > Google Options.
4. ClickCreate.
YourClient IDandClient Secretwill 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. UnderScopes, clickAdd 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. UnderHow 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 videohttps://youtu.be/sMjlt0LlqCQ, You must need to screencast your own video with your own app, then provide it for Google review.
ClickSave and Continuewhen done.
Review the summary and click onPrepare 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, clickSubmit 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.
Train AI Assistant for Chatbot With FAQ, URL & FileBotSailor's just launched its AI Assistant chatbot feature giving...
READ MOREUnlock a Profitable Business with BotSailor's White Label Reseller Program Are you looking for an effortless way to ...
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