⚙️Operations & Admin · Step-by-step guide

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

When a big retailer sends a long PDF of delivery rules, Gemini reads it and turns it into a simple checklist so you don't get fined for getting something wrong. Then it builds the spreadsheet for your shipping labels, one row per carton with its number and the warehouse it's going to, ready to load into a label-printing tool.

Created byJamie Kim · Jamie's Farm (interviewed by Google)
📰 Read the original: How a granola brand uses Gemini to tackle administrative tasks (Google Public Policy, interview with Jamie Kim) ↗
⏱️ About 1 hour for the first order; minutes after that🎯 Easy💵 Free on the Gemini free plan📋 7 steps
✨ Gemini🏅 Official case study
🎯 What you'll have at the endYou'll turn a retailer's delivery rules into a one-page checklist, and turn your order into a label file you can print from, in about an hour.

👀 What you'll get

Example

Here's the kind of thing you'll have at the end:

🧮 SpreadsheetCarton labels · PO 88213 · 14 cartons
CartonPOProductQtyWarehouse
1 of 888213Honey Oat Granola 400g12Shah Alam DC
2 of 888213Honey Oat Granola 400g12Shah Alam DC
...............
1 of 688213Cacao Crunch 400g12Johor Bahru DC

Totals: Shah Alam DC 8 cartons, Johor Bahru DC 6 cartons (matches the order)

Checklist reminder: label on the short side, 10 cm from the top (page 14) !

🧪 Made-up sample to show the kind of result. Your output will vary.

💸 What will this really cost me?

Prices checked 21 Oct 2026
🧪 To try it once
Free: the Gemini app's free plan can read the PDF and build the table.
🔁 To keep it running
Free for occasional orders. Google AI Plus is USD 4.99 (MYR 20) a month and Google AI Pro USD 19.99 (MYR 82) a month for heavier use; Gemini is also in many Google Workspace plans.
⚠️ Watch out for
Label-making software and label stock cost extra, depending on the tool: check the provider's pricing page.

🔗 Official pricing: Google AI & Gemini plans

Prices change often, so check the links before you pay. Amounts exclude tax. MYR at USD 1 = MYR 4.08 (Bank Negara Malaysia, 19 Oct 2026).

🧾 Which plan do I need?

✅ Free for you

The free Gemini app can read the PDF and build the table.

🪙 Small = up to MYR 250 a month more · 💎 Big = over MYR 250 a month more · prices from each provider's pricing page, checked 21 Oct 2026.
ℹ️ How we work this outPrices come from each provider's own pricing page (checked 21 Oct 2026; amounts exclude tax; USD 1 = MYR 4.08, Bank Negara Malaysia 19 Oct 2026). Small upgrade = up to MYR 250 a month more than you pay now. Big upgrade = more than MYR 250 a month more. Check pricing = the provider doesn't publish a price we could confirm. Each guide's needs come from its own "What will this really cost me?" box. Your ticks stay in this browser only (no account, nothing sent to us).
Tick all your plans on the home page →

⚡ One-click install

Checked install pages (app stores, official sites and template pages): tap to get it straight away.

⬇️ Get Gemini on AndroidGoogle Play⬇️ Get Gemini on iPhoneApp Store

🧰 Before you start

⏱️ Time neededAbout 1 hour for the first order; minutes after that
💵 Rough costFree on the Gemini free plan

🪜 Step by step

🐣 Beginner mode: showing the 7 essential steps only. Extra steps are hidden; tap 🚀 Advanced at the top to see all 7.
✅ 0 of 7 steps done 📄 Printable page
  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.

💬 Copy-paste prompts

Tap Copy prompt, paste it into your AI (Grok, ChatGPT, Claude or Gemini), then replace the [yellow bits] with your own details.

💬 Delivery rules checklist
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'.
💬 Carton label file
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.

⚠️ Tips & common mistakes

🌟 Why it's worth it

💡 Why it mattersLarge retailers charge suppliers penalties (chargebacks) for mislabelled or late deliveries, and small brands lose margin on them. A clear checklist plus labels made from a spreadsheet avoids both the penalties and a day of typing.
🏷️ Real exampleJamie Kim, owner of New York granola brand Jamie's Farm, told Google that she runs retailers' dense delivery-rule PDFs through Gemini to make sure she follows every guideline. When a retailer required every shipping carton to be labelled with its number and destination warehouse, she had Gemini build a CSV file for her label template and point her to label-making software, turning a full day's work into one hour.
🔌 Connects to:Gemini (or Gemini in Google Workspace)Google Sheets or ExcelAny label-making software that imports a CSV file
🏅 Proof level: Official case studyPublished by the company that makes the AI tool (or the vendor that set it up) about a real customer or its own team. The results are real reports, but written to promote the tool.
📰 Found via Official · Google Public Policy stories: How a granola brand uses Gemini to tackle administrative tasks (Google Public Policy, interview with Jamie Kim) ↗

🔗 Helpful links

🔗 Google Public Policy: how Jamie's Farm uses Gemini (source) ↗🔗 Google AI and Gemini plans ↗

📬 Every Monday: new things AI can do for you, with the exact prompt to copy

Sign up free and get our PDF of 20 copy-paste AI prompts straight away. One short email a week, unsubscribe in one click.

← Back to all use cases