Google API Integration for BotSailor Reseller Account

If you're a BotSailor reseller or admin looking to connect Google services like Google Sheets, Cloud Translation, or Maps, this tutorial will walk you through setting up your Google API integration properly.


🔍 What is Google API Integration in BotSailor?

Google API integration in BotSailor allows you to:

  • Store chatbot form responses in Google Sheets

  • Use Google Maps for dynamic location features

  • Enable Cloud Translation for multilingual bot responses

  • Offer Google login for your end-users

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-by-Step Setup Instructions

Go to BotSailor Settings

Login to your BotSailor reseller dashboard and navigate to:

Control Panel→ Settings & Integration → Google

You will see fields for:

  • Google API Key

  • Client ID

  • Client Secret

  • OAuth Redirect URIs

  • Toggle for enabling social login




Create a Project in Google Cloud Console

Enable Required APIs

Go to "APIs & Services → Library"




Search for Google Drive API:
Click on Google Drive API and then click Enable.


Search for Google Sheets API:
Click on Google Sheets API and then click Enable.


Search for Maps JavaScript API:
Click on Maps JavaScript API and then click Enable.

Search for Cloud Translation API:
Click on Cloud Translation API and then click Enable.

 



Configure OAuth Concent Screen

The OAuth consent screen is a crucial component of Google's identity and access management system. It acts as an intermediary between a user and an application requesting access to their data. When a user tries to use an application that integrates with Google services, this screen will pop up, displaying key information about the application and the specific permissions it's requesting.

The primary purpose of the consent screen is to ensure transparency and give users control over their data. By clearly stating what information the app will access, it helps users make informed decisions about granting permissions.

To set up your OAuth concent screen:

  • Go to "APIs & Services → Credentials"

  • A prompt will appear to set up the OAuth consent screen. Click on Configure consent screen.

 
1. Click Configure concent screen.
2. Provide the following details:
   - App Information & Support Email: Choose an appropriate name for your app and give your support email for the app.


   - AudienceThere are two main user types for an OAuth consent screen:

  • Internal: This is for applications that are only used by people within your Google Workspace organization.

  • External: This is for applications that will be available to any user with a Google account.

Choose User Type as External to make your app available for users outside your organization.


   - Contact Information: Enter your Email addresses to let users communicate with you, as you are developing the app.


   - Confirmation: Agree to Google API services user data policy and click continue.


   - Finish: Click Create to finish Concent Screen.

The publishing status of your consent screen can be either Testing or In production. While in testing, the app can only be used by a limited number of test users that you define. To make your app available to the public, you need to publish it to production, which may require a verification process by Google, especially if you are requesting access to sensitive user data, which will be discussed in the verification part.

Generate Oauth Client ID and Secret

Return to the Credentials page and click Create Credentials > OAuth Client ID.

  • Choose Web application


 

Add the following Authorized Redirect URIs (as shown in your BotSailor panel):

  • https://<your domain>/google/import/account/callback
  • https://<your domain>/login/google/callback
  • Click Create




âś… Copy your:

  • Client ID

  • Client Secret




  • Then, create an API Key for your BotSailor reseller panel.


Restricting the API Key

This guide will walk you through adding two types of restrictions to your API key:

  • Application restrictions: To ensure your key can only be used on specific websites or from specific IP addresses.

  • API restrictions: To limit the key to calling only the specific APIs you've authorized.

 

Step 1: Navigate to Your API Key Settings 

First, you need to find the API key you want to secure within your Google Cloud project.

  1. Go to the Google Cloud Console.

  2. From the main navigation menu on the left, select "APIs & Services" and then click on "Credentials".

  3. On the "Credentials" page, you will see a list of your API Keys. Find the key you want to restrict (e.g., "API key 1").

  4. Click the three-dot menu icon under the "Actions" column for that key, and select "Edit API key".

 

Step 2: Apply Application Restrictions & Apply API Restrictions

This step will lock your API key so it only works on websites you specify.

  1. On the "Edit API key" page, scroll down to the "Application restrictions" section.

  2. Select the "Websites" radio button. This will reveal the "Website restrictions" section below it.

  3. Click the "Add" button.

  4. A field will appear. Enter the specific URL of the website where you will use the key. You can use wildcards (*) to include all subdomains. For example:

    • To allow a specific domain and all its subdomains, use *.yourdomain.com/*

    • To allow only a specific page, you could use yourdomain.com/page

    • In your example, *.bloodtek.studio/* is used to allow all pages on all subdomains of bloodtek.studio.

This is the most important step for limiting which services the key can access.

  1. Scroll further down to the "API restrictions" section.

  2. Select the "Restrict key" radio button.

  3. A dropdown menu will appear. Click on it and select the specific APIs that this key is allowed to call. You can select multiple APIs.

  4. In your example, the key is being restricted to only call:

    • Google Drive API

    • Google Sheets API

    • Maps JavaScript API

    • Cloud Translation API

 

Step 3: Save Your Changes

Once you have configured both the application and API restrictions, click the "Save" button at the bottom of the page.

Note: Google mentions that it may take up to 5 minutes for the new settings to take effect.

By following these steps, you have successfully secured your API key, significantly reducing the risk of unauthorized use. It's a best practice to apply the most restrictive policies possible for all your API keys.

What is the purpose of API Key and OAuth Credentials?

API Key 

  • What it is: A simple code that identifies your application.

  • When to use: For accessing public data or services where no user is logged in.

  • Examples: Google Maps API, YouTube API (for public videos), Cloud Translation API.

OAuth 2.0 Credentials 

  • What it is: A secure way to get a user's permission to act on their behalf.

  • When to use: For accessing a user's private data.

  • Examples: Reading a user's Gmail, accessing their private Google Drive files, or viewing their Google Calendar events.

In short: If your app needs to access a specific user's private account data, use OAuth. For everything else, use an API Key.

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

    This scope grants your application access to the user's primary email address. It's commonly used for identifying and communicating with the user.

       - https://www.googleapis.com/auth/userinfo.profile

    This scope allows your application to see a user's basic, public profile information. This includes their name, profile photo, gender, and other details they have chosen to make public. It's often used to personalize the user experience within your app.

       - https://www.googleapis.com/auth/drive.file

    This is a specific, per-file access scope for Google Drive. It allows your application to:

    • Create new files and folders in the user's Google Drive.

    • Access and modify only the specific files and folders that your application has created.

    Crucially, this scope does not grant permission to see, access, or modify other files in the user's Drive that were created by the user or other applications. It's a more secure, limited scope for apps that only need to work with their own files.

       - https://www.googleapis.com/auth/spreadsheets

    This scope provides broad permission to view and manage all of the user's Google Sheets. An application with this scope can read, write, create, and delete any spreadsheet in the user's Google Drive. This is a powerful permission needed for applications that act as comprehensive spreadsheet editors or managers.   


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 when done.

Submitting Your App for Review

Go to the OAuth Consent Screen and select Audience section.

Click on Publish App to publish your app.

You will get a confirmation popup of "Push to production?"

Click Confirm. Your App will be published.

Go back to Branding Section and edit the app according to your details and app domains. Make sure to provide app logo, app domain fields, authorized domains and developer contact information.




 

Provide Privacy Policy and Terms of Service When Prompted

Before verification process, you will be asked to enter Homepage Link, Privacy Policy and Terms of Service URL.

  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.

 

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.

Paste Credentials into BotSailor Panel

Return to your BotSailor settings:

  • Paste the Google API Key

  • Paste the Client ID

  • Paste the Client Secret

  • “Force User To Use Own API Key” toggle is optional if you're setting up a custom environment for end users

  • Enable Social Login toggle (optional, for user login via Google)





  • Click the Save button to complete your integration.

 



đź’ˇ Tips & Best Practices

  • Always restrict your API Key usage under Google Cloud to only required domains for better security.

  • Regularly monitor your Google Cloud dashboard to track API usage.

  • If you're offering login with Google, ensure your OAuth Consent Screen is properly configured with your logo, support email, and scopes.




📌 Why Set Up Google API?

Connecting your Google API enables smooth automation and integrations like:

  • Auto-logging data into Google Sheets

  • Showing dynamic locations via Google Maps

  • Multi-language chatbot support with real-time translation

  • Allowing users to log in using their Google accounts




đź§© Conclusion

With just a few steps, your BotSailor reseller platform can be fully connected with Google’s powerful services. Whether you're managing leads, storing customer data, or offering a seamless login experience — Google API integration can significantly boost your automation game.




FAQs



What is the purpose of Google API integration in BotSailor?
Google API integration allows BotSailor resellers to connect services like Google Sheets, Maps, Cloud Translation, and Google Login to enhance chatbot functionality and user experience.

 


Which Google services can I integrate with BotSailor?

You can integrate:

  • Google Sheets to log form responses.

  • Google Maps for dynamic location-based features.

  • Cloud Translation API for multilingual chatbot responses.

  • Google OAuth Login for allowing users to sign in with their Google accounts.

 

Where do I find the Google integration settings in BotSailor?
Log in to your reseller dashboard and go to:

Settings → Google Integration
You’ll find fields to input API Key, Client ID, Client Secret, and OAuth redirect URIs.

 

Do I need a Google Cloud account for this integration?
Yes, you must create a project in the Google Cloud Console to generate the necessary API credentials.

 

Which APIs should I enable in my Google Cloud project?
Enable the following from APIs & Services → Library:

  • Google Sheets API

  • Google Maps JavaScript API

  • Cloud Translation API

  • OAuth 2.0 Client ID (for login)



What redirect URIs do I need to configure for OAuth?

Add these to your OAuth Client ID:

  • https://yourdomain.com/google/import/account/callback

  • https://yourdomain.com/login/google/callback

(Check your BotSailor panel for exact values.)


Where do I paste the API credentials in BotSailor?

Paste your:

  • API Key

  • Client ID

  • Client Secret
    in the Google Integration section under BotSailor settings.


Can I enable Google Login for users?
Yes, enable the Social Login toggle in your BotSailor settings after setting up OAuth credentials.


Is it mandatory to enable all Google APIs?
No. You only need to enable the APIs required for the features you want (e.g., enable only Google Sheets if you just need form logging).


How do I secure my Google API Key?
Restrict API key usage in your Google Cloud Console by:

  • Limiting it to specific domains

  • Enabling only required APIs
    This protects your quota from abuse.