BuildShip Logo
BuildShip Community

Chat with Google Sheets

Create an AI Assistant that can chat with your data on Google Sheets. This template is connected to a Furniture store's inventory data on Google Sheets and users can chat with the data to get meaningful recommendation for products.

660

Report this template

Select the reason for reporting

Describe the issue in detail

Share template

Link to template

https://templates.buildship.com/template/mZ_S4NDk9sjT/

Inputs

message

What price range are your Mediterranean sofas?

threadId

This is a static example using sample inputs. Remix the template to run it with your own values.

Output

Read me

🤖 Chat with Google Sheets

Create a simple AI Chatbot with BuildShip and OpenAI Assistant to give travel advisor and recommendations for a city. This template fetches the data from Google Sheets to answer any of the user questions.

In this example, the assistant acts as a home specialist, answering user inquiries about product materials, styles or pricing based on the product database on Google Sheets.

✅ Prerequisites

Google Sheets

No manual set up required! Just authenticate the Get Sheets node with your Google Account to get started. The node is pre-filled with a sample public database.

OpenAI

This template uses the OpenAI Assistant. Here's what you'll need to successfully test out the template:

  • [ ] Your OpenAI API Key

You can get your OpenAI API Key from the OpenAI Developer Dashboard.

  • [ ] OpenAI Assistant ID

Create an OpenAI Assistant on the OpenAI Developer Dashboard > Assistants, and copy the Assistant ID.

💡QUICK NOTE: When getting the Assistant ID it's best to select 'text' as the Response Format.

🧪 Testing

Test out the workflow via a message like What price range are your Mediterranean sofas?.

✍️ How to Use

Once the API Key and the Assistant ID is added, the workflow is ready to be used.

The template comes with a Chatbot Widget trigger which makes it super easy to test the functionality with a chat-like interface.

🌟BONUS: Here's how you can easily embed an AI chat widget on your website or app. Use the configuration script provided in the usage section to use your own AI Assistant Chatbot.

NOTE: You MUST Ship your workflow before testing out the functionality on the chat widget.

🎨 Customization

The default template uses the OpenAI Assistant node. To customize, click on the Additional settings to reveal additional customizable options, like the Thread ID and the Built-in Tools provided by OpenAI, like File Search and Code Interpreter.

Also, if OpenAI isn't what you're looking for 👀, the Node Explorer contains a variety of AI Assistant nodes with various models and providers, like Claude, Groq, and Azure 👇

Simply replace the existing OpenAI node with any of the Assistant option of your choice. Add in the API Key, Instruction, Prompt, and you'll be good to go.

🔗 Resources

  • Check out the dedicated documentation for the Assistant Variants: here
  • How to set up an OpenAI Assistant: here