Sheets

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 Service Account - allows you to connect to Google Sheets from a service account.

Google Sheets Integration Options

Use a User Account

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

Use a User Account

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

Successfully Integrated a User Account

Adding a Google Sheet as a Source

Use a Service Account

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

Use a Service Account

API Library

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

Search for Google Sheets API

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

Google Sheets API

4. 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.

Create Credentials

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

Create Service Account

6. 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.

Service Accounts for a Project

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

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

Select a Key Type

Private Key Successfully Saved

9. 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.

Search for Google Drive API

Google Drive API

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

Upload JSON Containing Private Key

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.

Sharing File with Service Account Email

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

Shared File Showing as Available