AI Inventory Bot with SQL Lookup
A Zapier flow that classifies messages with ChatGPT, queries a MySQL database and writes the answer back to the contact in GoHighLevel.

How it works
Catch and classify the message
A webhook receives each incoming message and ChatGPT classifies it, splitting the flow into vehicle questions and everything else.
Decide how to answer
For vehicle questions, ChatGPT holds the conversation and a second classification decides the path: a database lookup, or a plain AI conversation.
Look up matching rows
On the lookup path a MySQL step runs a custom query to find multiple rows. The result splits into two branches, and each uses a ChatGPT conversation step to compose the reply.
Write the answer back to GoHighLevel
Every path ends by adding or updating the contact through the LeadConnector action, so the answer lands on the contact’s record in GoHighLevel.
What we delivered
- Message classification with ChatGPT
- A MySQL query step for inventory questions
- Separate AI paths for vehicle and non-vehicle questions
- Replies written back to the GoHighLevel contact




