Smart Sales Support Chatbot with GPT-4o and Google Sheets

Who is this tempate for?

This workflow powers a simple yet effective customer and sales support chatbot for your webshop. It's perfect for solopreneurs who want to automate customer interactions without relying on expensive or complex support tools .

How does it work?

The chatbot listens to user requests—such as checking product availability—and automatically handles the following

• Fetches product information from a Google Sheet
• Answers customer queries
• Places in order
• Updates the stock after a successful purchase

Everything runs through a single Google Sheet used for both stock tracking and order management.

Setup Instructions

Before you begin, connect your Google Sheets credentials by following this guide: This will be used to connect all the tools to Google Sheets
👉 Setup Google sheets credentials

• Get Stock

  • Open "Get Stock" tool node and select the Google sheet credentials you created.
  • Choose the correct google sheet document and sheet name and you are done.

• Place order

  • Go to your "Place Order" tool node and select the Google sheet credentials you have created.
  • Choose the correct google sheet document and sheet name.

• Stock Update

  • • Open your "Update Stock" tool node and select the Google sheet credentials you have created.
  • Choose the correct google sheet document and sheet name.
  • In "Mapping Column Mode" section select map each column manually.
  • In "Column to match on" select the column with a unique identifier (eg, Product ID) to match stock items.
  • In values ​​to update section, add only the column(s) that need to be updated—usually the stock count.

• AI Agent node

  • Adjust the prompt according to your use case and customize what you need.

Google Sheet Template

Stock sheet

Order sheet