P
AI for Utilization Review Nurse

Automation: Case Status Notification Workflow with Zapier

Tools:Zapier, Google Sheets, Gmail/Outlook
Time to build:1-2 hours
Difficulty:Intermediate-Advanced
Prerequisites:Comfortable with Google Sheets and email; basic understanding of how forms work. No coding required
Zapier

What This Builds

You'll create an automated workflow that sends case status notification emails to providers or care managers whenever a case decision is logged in a shared Google Sheet, without you composing and sending each email manually. When you update a case row in the spreadsheet (marking it "Approved" or "Denied"), Zapier automatically sends a pre-written notification email to the relevant recipient with the case details filled in. This eliminates 20–30 minutes of daily repetitive email composition.

Prerequisites

  • Free Zapier account at zapier.com (free plan supports this workflow)
  • Google account with Google Sheets access
  • Gmail or work email account connected to Zapier
  • Comfortable using Google Sheets. Know how to add rows and enter data
  • Understand that this workflow handles non-PHI status notifications. Do not include clinical details in automated emails

The Concept

Think of Zapier as a workflow assistant that watches your spreadsheet. When it sees a specific change (like a row being updated to "Approved"), it automatically sends an email using a template you wrote once. It's the same as if you had an admin sitting next to you who, every time you marked a case status in a spreadsheet, immediately sent the notification email for you. You set it up once, and it runs on its own.

Build It Step by Step

Part 1: Set up your Google Sheet as the data source

  1. Create a new Google Sheet called "UR Case Status Tracker"
  2. Create these column headers in Row 1:
    • Column A: Case_ID
    • Column B: Auth_Number
    • Column C: Provider_Name
    • Column D: Provider_Email
    • Column E: Service_Type
    • Column F: Decision
    • Column G: Decision_Date
    • Column H: Notification_Sent
  3. Add a test row with dummy data: a fake case ID, a test email address (your own), a fake service type, and set Decision to "Approved"

What you should see: A clean spreadsheet with labeled columns and one test row.

Important: This spreadsheet contains authorization workflow data only: no clinical notes, diagnoses, or patient demographics. Keep it limited to case IDs, decisions, and provider contact information.

Part 2: Create a Zapier account and start a new Zap

  1. Go to zapier.com and create a free account
  2. Click Create Zap (or + Create → Zaps)
  3. You'll see the Zap Editor: a visual flow builder with "Trigger" and "Action" steps

What you should see: A blank Zap editor with "1. Trigger" waiting to be configured.

Part 3: Configure the trigger

The trigger is what starts the automation: a new or updated row in your spreadsheet.

  1. Click the Trigger step
  2. Search for and select Google Sheets
  3. Choose the trigger event: New or Updated Spreadsheet Row
  4. Connect your Google account when prompted
  5. Select your "UR Case Status Tracker" spreadsheet and the correct sheet tab
  6. In Trigger Column, select column F (Decision). This tells Zapier to only trigger when the Decision column is filled in
  7. Click Test trigger. Zapier should find your test row

What you should see: Zapier shows your test row data with all columns labeled.

Part 4: Add a filter (only trigger on specific decisions)

Add a Filter step to prevent the automation from sending emails for blank or incomplete rows.

  1. Click the + button below the Trigger step
  2. Select Filter
  3. Set the condition: Decision (Column F) Contains Approved OR Decision Contains Denied

This ensures the automation only runs when a real decision has been entered.

Part 5: Configure the email action

  1. Click the + button below the Filter

  2. Search for and select Gmail (or Outlook / Email by Zapier for any address)

  3. Connect your email account

  4. Choose action event: Send Email

  5. Fill in the email fields using your spreadsheet data (click the + button in each field to insert data from the trigger):

    To: {Provider_Email} (from your spreadsheet)

    Subject: Authorization Update: Case {Case_ID}

    Body:

    Copy and paste this
    Dear {Provider_Name},

This is an automated update regarding authorization case {Auth_Number}.

Service: {Service_Type}
Decision: {Decision}
Decision Date: {Decision_Date}

If you have questions about this determination or need to request a peer-to-peer review, please contact our Utilization Review department at [YOUR PHONE NUMBER] or [YOUR EMAIL].

This is an automated notification. Please do not reply to this email.

[Your Department Name]
[Organization Name]

  6. Test the action. Send to your own email address first

What you should see: An email in your inbox with the test row data filled in correctly.

Part 6: Add the confirmation column update

Add one more action to mark the notification as sent in your spreadsheet.

  1. Click + below the email action
  2. Select Google Sheets → Update Spreadsheet Row
  3. Configure it to update the Notification_Sent column (H) of the triggered row to Yes and the current date/time

This creates an audit trail showing when notifications were sent.

Part 7: Turn the Zap on

Click the toggle in the top-right corner to turn the Zap from Off to On. From now on, whenever you enter a decision in column F of your spreadsheet, the notification email sends automatically.

Real Example

Setup: UR nurse logs 30–40 case decisions per day in the tracker. Each decision previously required composing and sending a notification email (30–45 seconds each), adding up to 20–25 minutes per day.

Workflow now:

  1. UR nurse marks Decision = "Approved" in the Google Sheet
  2. Zapier detects the change (usually within 1-5 minutes)
  3. Notification email sends automatically to the provider with the case details
  4. Notification_Sent column updates to Yes + timestamp

Time saved: 20–25 minutes of daily email composition eliminated. Notifications go out faster and more consistently than manual sending.

What to Do When It Breaks

  • Zap triggers but email doesn't send → Check the Zap history (click History in Zapier). It shows exactly which step failed and the error message. Usually this is an email permission issue; reconnect your email account.
  • Zap doesn't trigger when I update a row → Google Sheets trigger can have a 5-15 minute delay on the free plan. This is normal. Upgrade to Zapier paid if real-time triggering is required.
  • Wrong row data in the email → Check that your column headers match exactly what Zapier expects. A mismatch in column naming between the sheet and the Zap causes wrong data to fill in.
  • I need to pause the automation → Click the Zap toggle to turn it Off. No emails will send while it's off, but your history is preserved.

Variations

  • Simpler version: Use Google Sheets built-in notifications (Sheets → Tools → Notification settings) to alert you when the sheet changes. Less automation, but zero setup
  • Extended version: Add a Zapier delay so notifications send in batches at the end of the day rather than immediately, reducing recipient confusion about multiple emails per day

What to Do Next

  • This week: Run the workflow for 5 days and monitor for any errors in the Zap History
  • This month: Add a second Zap for denied cases with a slightly different email body that includes the appeal rights reminder
  • Advanced: If your organization's UM platform has a data export or API, explore whether Zapier can trigger directly from platform status changes rather than manual spreadsheet entry

Advanced guide for Utilization Review Nurse professionals. These techniques use more sophisticated AI features that may require paid subscriptions.