BotDistrikt Documentation
  • 🟢Introduction
    • 👋Hello World
    • 🚀Quick Start
    • 🛠️Setup your Account
      • Register for BotDistrikt
      • Forgot Password
      • Chatbots Dashboard
      • Edit Profile
  • 📱Channels
    • Channels Overview
    • Website Chat
      • Website Chat Quick Start
      • Guest Users
    • Facebook Messenger
      • Import Existing Users
      • Facebook Chat Plugin
      • Facebook Checkbox Plugin
      • Facebook Private Replies
      • Facebook Ads Manager
    • Instagram
      • Import Existing Users
      • Instagram Story Mentions
    • Twitter
    • Skype
    • WhatsApp
      • Twilio WhatsApp Integration
    • Telegram
      • Telegram Commands
      • Telegram Groups
      • Telegram Channels
    • SMS
    • Google Assistant
    • WeChat
    • Other Channels
  • 🏆Features
    • Personality
    • Dashboard
    • Forms
    • Rules
      • Conditions
        • Message
        • User Attribute
    • Stories
      • Update Greeting and Fallback from Personality
    • Responses
      • Text
      • Cards
      • Images
      • Videos
      • Audios
      • Documents
      • Webhooks
      • Javascript Functions
    • Sources
      • Websites
      • Documents
      • Google Docs
      • Google Sheets
    • Users
      • Edit Users
      • Delete Users
      • Dear User
    • Inbox
      • Console
      • Messages
      • Reactions
      • Ratings
      • Clicks
      • Broadcast Records
      • Wrong Responses
    • Broadcasts
    • Settings
      • Tags
      • Audit Logs
      • Account
  • ⚙️How BotDistrikt Works
    • Interaction
    • Flow
    • Context
    • Engagement
    • Optimization
    • Artificial Intelligence
  • 🧠Artificial Intelligence
    • OpenAI
    • Vertex AI
    • Wit.ai
    • Dialogflow
      • Connecting to Dialogflow
      • Small Talk Module
        • Importing Responses
      • Multilanguage Support
  • 🧰Business Tools Integrations
    • Webhook
    • Zendesk
    • Chatbase
    • Google Docs
    • Google Sheets
    • Salesforce
  • API Reference
Powered by GitBook
On this page
  • Use a User Account
  • Use a Service Account
  • Add Sources with a Service Account

Was this helpful?

  1. Business Tools Integrations

Google Sheets

PreviousGoogle DocsNextSalesforce

Last updated 9 months ago

Was this helpful?

You may connect your Google Sheets Account with BotDistrikt.

Navigate to Integrations and click on Sheets

You will be presented with two options to integrate Google Sheets with the BotDistrikt platform.

  • Use a User Account - allows you to connect to Google Sheets from your personal user account.

Use a User Account

  1. Click on the Sign in with Google button and allow BotDistrikt to access your Google Account.

  1. After successfully linking your Google account, you will be able to see all available spreadsheets in the dropdown selector.

Use a Service Account

  1. In the search bar on the API Library page, search for Google Sheets API.

  1. In the Google Sheets API product details, click on Enable.

  1. At the APIs & Services dashboard, click on Credentials at the left navigation panel. Once at the Credentials tab, click on Create Credentials and select Service Account from the dropdown menu.

  1. Once at the Create service account page, fill in the necessary information for the service account details and permissions, and click Done.

  1. At the service account dashboard, click on the hyperlinked email address of the service account that was just created to access the Service account details page.

  1. Click on the Keys tab to view all service account keys. Click on Add Key and from the dropdown menu, select Create new key.

  1. In the modal that appears, select the JSON key type option and click on Create. You will be prompted to download the JSON file.

  1. Before uploading the JSON file on BotDistrikt’s platform, please ensure that the Google Drive API is enabled. This can be done by searching for Google Drive API in the search bar on the API Library page and clicking on the Enable button.

  1. At the Google Sheets integration page on BotDistrikt’s platform, upload the JSON file containing the private key to link the service account.

Add Sources with a Service Account

  1. To add a sheet as a source on the BotDistrikt platform via a Service Account, share the file with the service account email address.

  1. Once shared, the file should show up as an available document to be used as a source on the BotDistrikt platform.

Use a Service Account - allows you to connect to Google Sheets from a .

To generate your Google Sheets private key JSON file, you must first open the .

You can now head on to Sources to

🧰
service account
API Library
train your LLM to learn from your Google Sheets
Google Sheets Integration Options
Use a User Account
Successfully Integrated a User Account
Adding a Google Sheet as a Source
Use a Service Account
API Library
Search for Google Sheets API
Google Sheets API
Create Credentials
Create Service Account
Service Accounts for a Project
Select a Key Type
Private Key Successfully Saved
Search for Google Drive API
Google Drive API
Upload JSON Containing Private Key
Sharing File with Service Account Email
Shared File Showing as Available