Getting Started
Data Sources
In this section we'll explain how you can upload, import, and connect data sources to train AI to generate automated responses. Let's first explore the data sources you can use with Botsheets and the differences between them.
PDF Documents
PDFs are an ideal data source to give your chatbot a knowledge base to answer questions:
| Document Character Limit | 500,000 to Unlimited |
| File Size | Max 30 mb |
| Files Per Bot | Unlimited |
| Data Sync | None. Upload a PDF. Delete the file and upload another. |
| Data Retrieval | Semantic Search |
| Chat Credits | Each message processed with AI that triggers this data source as a response consumes 1 chat credit |
Web Documents
We scrape web pages, an ideal data source for an AI knowledge base. Unlike PDF documents though, connect a webpage once to Botsheets and we'll keep AI in sync with changes to your website content.
| Document Character Limit | 500,000 to Unlimited |
| File Size | Not applicable |
| Pages Per Bot | Unlimited |
| Data Sync | Once every 24 hr, 6 hr, or 1 hr depending on your Botsheets plan.. |
| Data Retrieval | Semantic Search |
| Chat Credits | Each message processed with AI that triggers this data source as a response consumes 1 chat credit |
Manual Data Input
While spreadsheets provide a more scalable approach to structured data, we provide form fields to capture some basic structure data in the form of name-value (or key-value) pairs. This data source is ideal for highlighting key data points about your business without requiring an extensive structured dataset. A business name, or hours of operation are examples of data you might provide. The structure is much easier for AI to understand than PDFs and Web Documents due to the simplicity of the structure.
| Document Character Limit | Not applicable |
| File Size | Not applicable |
| Name-Value Pairs Per Bot | 20 |
| Data Sync | Not applicable. Add, edit, or delete up to the maximum. |
| Data Retrieval | Semantic Search |
| Chat Credits | Each message processed with AI that triggers this data source as a response consumes 1 chat credit |
Google Sheets
Give your chatbot as database. We generate database queries from natural language that can produce precision results. If no result is found, it will search the data the same as PDFs and Web documents. Similar to web documents, you just need to connect a Google Sheet once and we'll keep AI in sync with changes to data in the sheet.
| Document Character Limit | Not applicable |
| File Size | 30 mb max |
| Sheets Per Bot | Unlimited |
| Data Sync | Once every 24 hr, 6 hr, or 1 hr depending on your Botsheets plan.. |
| Data Retrieval | SQL Queries + Semantic Search |
| Chat Credits | Each message processed with AI that triggers this data source as a response consumes 10 chat credits |
If you don't have a dataset, you can populate a Google Sheet manually, export data from apps in CSV format and import to a Sheet, or using a tool like Zapier, move data from hundreds of business apps into Google Sheets. The key to a high performing chatbot powered by Google Sheets is good data and a good data structure to train AI.