Check a big shop's delivery rules and make every carton label in an hour

🧰 Before you start

• The Gemini app or Gemini in Google Workspace (the free plan is fine)
• The retailer's supplier or routing guide (usually a PDF)
• The purchase order: how many cartons go to which warehouse
• Label-making software or a label website that can import a CSV file (many label printers come with one)

🪜 Steps (tick as you go)

1. ☐
   1. Upload the delivery rules

   Open Gemini and upload the retailer's PDF. Use the 'Delivery rules checklist' prompt below.

2. ☐
   2. Check the checklist against the PDF

   Ask Gemini to give the page number for each rule, then spot-check the important ones (label size, where it goes on the carton, delivery windows) yourself.

3. ☐
   3. Share your order

   Paste or upload the purchase order: product, number of cartons and destination warehouse for each line.

4. ☐
   4. Build the label file

   Use the 'Carton label file' prompt. Gemini gives you a table with one row per carton. Ask it to put it in Google Sheets, or copy it into a spreadsheet, and save it as CSV.

5. ☐
   5. Load it into your label tool

   In your label software, open your label template and import the CSV (often called mail merge, data merge or 'import data'). Match each column to a field on the label. If you don't have a label tool, ask Gemini which ones work with your printer.

6. ☐
   6. Print a test page

   Print one sheet on plain paper first and check it against the checklist before printing the full run.

7. ☐
   7. Save the checklist

   Keep the checklist and label file for that retailer. Next order, you only need the new purchase order.

💬 Prompts to copy

This PDF is [retailer name]'s supplier delivery guide. Turn it into a one-page checklist for a small supplier.
Group it under: booking the delivery, carton labels (size, position, what must be printed, barcode type), pallets, paperwork, delivery windows, and penalties (chargebacks).
For every rule give the page number. Put the rules that carry penalties first and mark them with !
If anything is unclear or contradicts itself, list it at the end under 'Ask the retailer'.

Here is my purchase order: [paste or upload].
Make a table with one row per carton, with these columns: carton number (1 of N, 2 of N…), PO number, product name, product code, quantity in carton, destination warehouse name, warehouse address, and [any other field from my checklist].
Number the cartons separately for each warehouse if the checklist says so.
At the end, show the total cartons per warehouse so I can check it against the order. Give it to me as CSV I can copy.

🔗 Links

• Google Public Policy: how Jamie's Farm uses Gemini (source): https://publicpolicy.google/stories/jamies-farm-new-york/
• Google AI and Gemini plans: https://gemini.google/subscriptions/

From https://usecasy.com/use-case/gemini-retailer-carton-labels/ · Guide checked 21 October 2026 · Prices are rough and shown in USD unless stated (MYR where relevant).