Skip to main content

​
Overview

Connect your AI assistant to Google Sheets via Buildship to create a real-time knowledge base. Your AI can fetch property listings, pricing data, inventory, or any structured data directly from a spreadsheet during conversations.

​
Requirements

  • Google Sheets with structured data
  • Buildship account (no-code backend builder)
  • Assistable assistant for integration

​
Setup

1

Prepare Your Spreadsheet

Create a Google Sheet with structured data. Example columns: Date Listed, Price, Address, Zip Code, Square Footage, Bedrooms, Bathrooms.Note the sheet tab name (bottom left corner) — you’ll need it in Buildship.
2

Configure Buildship

  1. Log in to Buildship
  2. Create a new workflow
  3. Add the pre-built Sheets node → choose Get Sheets
  4. Click Auth to connect your Google account
  5. Configure the sheet ID and tab name
  6. Deploy the workflow and copy the endpoint URL
3

Create a Custom Tool in Assistable

  1. In your assistant, create a new custom tool
  2. Set the endpoint to your Buildship URL
  3. Add parameters for any query filters (optional)
  4. Save and add to your assistant
4

Update Your Prompt

Instruct the AI when to query the spreadsheet and how to present the data to users.
For frequently changing data (pricing, availability), Google Sheets + Buildship is faster to update than rebuilding your knowledge base.

Custom Tools Overview

Custom tool fundamentals

Knowledge Base Optimization

Optimize your AI’s knowledge

Scrape Website

Fetch data from websites