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