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 w...
🔌 Nodes & Integrations Used (5)
📖 Implementation & Setup Guide
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
- ### 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.
- ### Update Stock
- - - 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 (e.g., 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**
|Case ID|Phone Model|Case Name|Case Type|Image URL|Quantity Avaialble|Initital Inventory|Sold| |-|-|-|-|-|-|-|-| |1023|Iphone 14 pro|Black Leather|Magsafe|https://example.com/url|90|100|10
**Order sheet**
|Case ID|Phone Model|Case Name|Name|Phone Number|Address| |-|-|-|-|-|-| |1023|Black Leather |Iphone 14 pro|Fernando Torres|9998898888|Paris, France
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Smart sales support chatbot with GPT-4o and Google Sheets.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....