Automation: Auto-Send Case Shipping Notifications

What This Builds

Instead of manually sending a shipping confirmation email every time a case ships, this automation does it for you. When you mark a case as "shipped" in your lab management spreadsheet, Zapier automatically sends a personalized email to the right dental office with the case details — no typing, no forgetting. Labs that ship 10-20 cases per day eliminate 15-30 minutes of daily confirmation emails.

Prerequisites

• Comfortable using Gmail for regular lab emails (Level 2)
• A Google Sheet where you track case shipping (or willing to create one)
• A Zapier account (free tier works for basic automations)
• Gmail account for sending
• Time needed: 1-2 hours to build; runs automatically after that
• Cost: Free (Zapier free tier); Google Sheets and Gmail are free

The Concept

Think of Zapier as a behind-the-scenes assistant watching your spreadsheet. The moment you type "Shipped" in a specific column, it wakes up, reads the case details in that row, formats an email, and sends it to the dental office. You don't touch the email — it happens automatically.

It's like having a front desk person whose only job is to send shipping confirmations — except they never forget, never misspell, and work instantly.

Build It Step by Step

Part 1: Set Up Your Shipping Tracking Sheet

You need a Google Sheet that tracks case shipments. If you already have one, skip ahead. If not, create one with these columns:

The critical column is H: Status — when you type "Shipped" here, the automation triggers.

Add a few test rows with your regular dental office emails to test with.

Part 2: Create a Zapier Account

1. Go to zapier.com and create a free account.
2. Click "Create Zap" or "+ New Zap."

What you should see: The Zap editor — a visual workflow builder.

Part 3: Set the Trigger (Google Sheets — New/Updated Row)

1. In the Zap editor, click "Trigger."
2. Search for and select "Google Sheets."
3. Choose trigger event: "Updated Spreadsheet Row."
4. Connect your Google account.
5. Select your spreadsheet and the sheet tab (e.g., "Shipping Tracker").
6. Test the trigger — Zapier will fetch a recent row to confirm the connection.

What you should see: Zapier shows you the column headers and sample data from your sheet.

Part 4: Add a Filter (Only trigger when Status = "Shipped")

1. Click the "+" button after the trigger to add a step.
2. Search for "Filter by Zapier" and add it.
3. Set the condition: Column H (Status) Contains the text Shipped
4. This ensures the automation only fires when you specifically mark something as Shipped — not every time any cell changes.

Part 5: Set the Action (Gmail — Send Email)

1. Add another step — search for "Gmail."

2. Choose action: "Send Email."

3. Connect your Gmail account.

4. Fill in the email fields using data from your sheet:

   To: Map to Column C (Dentist Email)

   Subject: Your case has shipped — [Case Type] for [Dentist Name] Map: Case Type = Column D, Dentist Name = Column B

   Body:

   Copy and paste this

   Hi [Dentist Name],
   
   Your case is on its way.
   
   Case: [Case Type], Tooth #[Tooth #]
   Shipped: [Ship Date]
   Carrier: FedEx
   Tracking: [Tracking #]
   
   Expected delivery: tomorrow (if shipped before 3pm today).
   
   Let us know if you have any questions.
   
   [Your Lab Name]
   [Your Phone Number]
   

   Map all bracketed items to their corresponding columns.

5. Test the action — Zapier will send a test email to the dentist email in your test row.

What you should see: A real email lands in your test inbox (or the dental office's inbox if you used a real email) with all fields correctly filled in.

Part 6: Turn On and Test Live

1. Click "Publish" or "Turn On" to activate the Zap.
2. In your Google Sheet, add a real case row and type "Shipped" in column H.
3. Wait 1-2 minutes (Zapier checks for changes periodically on the free tier; upgrade to faster polling if needed).
4. Check that the email was sent correctly.

Real Example: Full Workflow in Action

Setup: You maintain a Google Sheet called "Daily Shipping Log." Column H is "Status."

What triggers it: You finish packing a crown for Dr. Kim's office and type "Shipped" in H14.

What happens automatically:

• Zapier detects the status change

• It reads the row: Crown, Tooth #3, Dr. Kim, kim@drkim.com, FedEx, tracking 123456789

• It sends this email in 60 seconds:

  Subject: Your case has shipped — Crown for Kim Dental

  Hi Kim Dental, Your case is on its way. Case: Crown, Tooth #3. Shipped: today. Carrier: FedEx. Tracking: 123456789. Expected delivery: tomorrow. Let us know if you have any questions. — Metro Dental Lab

What you do: Nothing. Move on to the next case.

Time saved: 2-3 minutes × 15 shipments/day = 30-45 minutes saved daily.

What to Do When It Breaks

• Zapier says "no rows found" → Make sure your Google Sheet is shared with your Google account properly, and that the Trigger column matches exactly (capital "S" in "Shipped" matters if you set it up case-sensitively).

• Email is sent but with blank fields → Go back to the Gmail action step and remap the columns. Column references can break if you add or remove columns from your sheet.

• Email sent to wrong person → Verify Column C has the correct email for each row. Consider adding a "verify before send" step: put the dentist email in a separate "Shipping Email" column that you fill in intentionally.

• Automation ran twice for same row → Add a second filter: only trigger if Column H was previously blank (not already "Shipped"). Zapier's "Updated Row" trigger can fire multiple times if a row is edited.

Variations

• Simpler version: Skip Zapier entirely. Use a Gmail Template (Level 2 guide) to send the email manually — takes 30 seconds instead of automatic, but requires no setup.

• Extended version: After the shipping confirmation, add a second Zapier step that sends a follow-up email 3 days later asking if the case arrived and the dentist is happy with it. Proactive quality check with zero effort.

What to Do Next

• This week: Build the basic automation and run it for 3-5 real shipments to verify it works correctly.
• This month: Expand to include case intake acknowledgments (when a case is received, send "We got it" email automatically).
• Advanced: Connect to your actual lab management software via Zapier's API integrations if your software supports it — then you don't need the manual Google Sheet entry at all.

Advanced guide for dental lab technician professionals. Zapier free tier supports up to 100 tasks/month; paid plans start at $20/month for higher volumes.