Google Sheets Integration

Google Sheets Integration

Our chatbot and API allow you to integrate your Google Sheets data by pre-authorizing your Google Sheets account, and then allowing you to select the Google Sheets that you want to use for your knowledge base.

Authorizing Access

To get started, you'll need to pre-authorize Locusive's system to access your Google Sheets account. You can do this by going to your Integrations page and connecting your Google Sheets account, which will require you to sign in to your Google account and grant access to Locusive's system.

Adding A New Sheet

Once you've authorized our system, you can select the Google Sheets that you'd like to add to your knowledge base directly from the Google Sheets integration details page on the Locusive website. When you select a new sheet, you'll need to select the tab from the Sheet that you'd like to use as part of your knowledge base. Our system will also ask you a few optional questions to help us understand the contents of your sheet for more accurate retrieval later. You don't need to fill out those fields, but if you leave them blank, our system may be less accurate in retrieving answers from the contents of your sheet.

Refreshing Data

Our system will automatically check for updates on a nightly basis, and if your sheet has been updated, it will re-read the entire contents of the sheet and add them back to our system. Please note that this will incur a paid call to OpenAI's embeddings model. Learn more about how we use your OpenAI API keys here.

Limitations

  1. At the moment, our system only supports adding a single tab from a Google Sheet, and you can only add a Google Sheet once, which means you cannot add multiple tabs from the same sheet. We're aware of the issue and are looking into a fix. One potential workaround is to create a new Google Sheet file and add your data to that file. We know this is a hassle and apologize for the issue.
  2. Due to technical constraints, you can't add Google Sheets from the Slackbot via the /add command, you can only add new sheets from the website.

    • Related Articles

    • Salesforce Integration

      Our chatbot and API allow you to integrate your Salesforce account via the Salesforce API. This article covers the basics of how it works and what you can expect. Integrating With Salesforce Locusive allows you to connect to your Salesforce account ...

    • Google Drive Integration

      Locusive's system allows you to select the Google Drive folders you'd like to add to your knowledge base. By connecting your Google Drive integration, you'll be able to select the folders from your Drive account that you'd like our system to monitor ...

    • Database Integration

      Our chatbot and API allow you to integrate your relational databases by providing connection information that we can use to run read-only queries on your system. Introduction When you send a request to the system, it will figure out where to get the ...

    • Reference Guides

      Introduction Locusive uses an AI-powered autonomous agent to answer your users' questions, analyze data, and perform actions within your product. For this, Locusive may need access to your various tools and data sources, such as databases or ...

    • Example Queries

      What are Example Queries? Example queries in Locusive serve as predefined questions and SQL queries that help guide the system to access and interact with your database efficiently. They are one of the most powerful tools you can use to ensure that ...