NERDY HACKS · CUSTOMER SERVICE & REVIEWS

Consultant turns a store's shipping spreadsheet into chatbot FAQs with ChatGPT

Building a support agent for an ecommerce client, a consultant had ChatGPT turn a per-country shipping spreadsheet into question-and-answer pages the chatbot could learn from.

TOOL USED

Chatbase, ChatGPT, Shopify

SPOTTED ON

Joren Wouters · Sep 10, 2026

FILED UNDER

Customer Service & Reviews hacks

TL;DR

What did Joren Wouters use Chatbase for?

Building a support agent for an ecommerce client, a consultant had ChatGPT turn a per-country shipping spreadsheet into question-and-answer pages the chatbot could learn from. They say that in the first month the agent "automatically answered 80% of their customer questions."

What they did

The client shipped across Europe with costs, delivery times and carriers that differed by country, kept in a spreadsheet the chatbot tool couldn't read. They asked ChatGPT to rewrite it as a document with three questions per country (delivery time, cost, carrier), then loaded it with the store's FAQ into Chatbase, connected Shopify for order lookups, and set it to raise a support request when it didn't know an answer.

How it went

They say that in the first month the agent "automatically answered 80% of their customer questions."

Worth knowing

  • The video is sponsored by Chatbase, and the walkthrough uses an anonymized FAQ and a demo store rather than the client's live shop. They also told the bot to answer only from the documents it was trained on.
  • Price check: Chatbase: no free plan; Hobby: US$40/month, or US$32/month on a yearly plan (US$384/year) (checked Oct 26, 2026); ChatGPT: free plan; Go: US$8/month (checked Nov 1, 2026); Shopify: no free plan; Basic: US$39/month, or US$29/month on a yearly plan (US$348/year) (checked Oct 28, 2026).

Paying for ChatGPT? See cheaper ChatGPT alternatives.

Try it yourself

Paste this into a chatbot, then add your own details underneath.

Turn this shipping spreadsheet into a document where each heading is a question and each answer is a short paragraph. For every country, write three questions: how long shipping takes, what it costs, and which carrier we use. Keep the numbers exactly as in the sheet.

Original post

See Joren Wouters's original post on YouTube → (Sep 10, 2026)

Sources

  1. Joren Wouters on YouTube, Sep 10, 2026 — the original post
  2. Chatbase pricing — checked Oct 26, 2026
  3. ChatGPT pricing — checked Nov 1, 2026
  4. Shopify pricing — checked Oct 28, 2026

THE NERD SIGNAL

Rocky digs through the AI noise. You get the good bits.