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 it works? 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 an 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](https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/finish-your-n8n-credential)

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