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.

  • Automotive
Zapier editor showing an inventory bot that classifies a message and splits it into vehicle and fallback paths

How it works

  1. Catch and classify the message

    A webhook receives each incoming message and ChatGPT classifies it, splitting the flow into vehicle questions and everything else.

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

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

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