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:

   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.

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