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
At a glance
Smart sales support chatbot with GPT-4o and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, OpenAI
- Modules
- 7
- Price
- Free
- Version
- v1.0

About this workflow
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 - ### 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| 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 n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Business lead generation with Apify web scraping and Google Sheets storage
Add Google Sheets rows for Layerise topics
Add leads to Odoo CRM from new Google Sheets spreadsheet rows
Save data from Lemlist unsubscribe events to Google Sheets
Create and validate Meta ad copy with GPT-4o, OriginalVoices, and Sheets
Send bulk updates with OpenPhone text messages using Google sheets
Track menstrual cycles and send Gmail phase reminders with GPT-4o and Google Sheets
Scrape Indeed job listings for hiring signals using Bright Data and LLMs
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you