Zapier Automation: Incident Notification and Follow-Up Workflow

What This Builds

An automated workflow that: (1) captures incident/near-miss reports from workers via a simple Google Form, (2) automatically sends a formatted notification email to management and EHS within 5 minutes, (3) creates a tracking row in your incident log spreadsheet, and (4) optionally generates an AI-drafted initial investigation narrative and emails it to you. Workers report in under 2 minutes; you get an organized, formatted notification without manual data entry.

Prerequisites

• A free Zapier account at zapier.com (free plan covers this workflow)
• A Google account with access to Google Forms and Google Sheets
• Optional: Zapier paid plan or OpenAI API key for the AI summary step
• Management email addresses for incident notifications
• Time to build: 2 hours
• Cost: Free with Zapier free plan (basic version); ~$20/mo Zapier Starter for AI step

The Concept

Right now, workers report incidents verbally or through a paper form that lands on your desk hours later. Management finds out when you remember to tell them. The incident log is updated when you get around to it. This workflow closes all three gaps automatically: worker reports → instant notification → automatic log entry → optional AI draft.

Think of it as a pipeline: Google Form (input) → Zapier (connector) → Email + Sheets (output). The AI step adds a bonus layer: it turns the raw form responses into a formatted notification narrative automatically.

Build It Step by Step

Part 1: Create the incident report Google Form

1. Go to forms.google.com and click + Blank

2. Title: "[Your Company] Incident/Near-Miss Report"

3. Add these fields (mark required with asterisk):

   • Your Name (Short answer, required)
   • Date and Time of Incident (Date/time, required)
   • Location (Short answer, required — e.g., "Warehouse Bay 3, near Loading Dock")
   • Type of Event (Multiple choice: Near-Miss / First Aid / Recordable Injury / Property Damage / Environmental)
   • What Happened? (Paragraph, required — instructions: "Describe what happened in plain language. Include: what you were doing, what went wrong, who was involved.")
   • Immediate Actions Taken (Paragraph)
   • Your Phone Number (Short answer — for EHS follow-up)

4. In Form Settings, check "Collect email addresses" (so submissions are traceable)

5. Click the Settings gear → Responses tab → toggle on "Send email notifications to" and add your email

6. Share the form link with workers via QR code posted in break rooms and work areas

Part 2: Connect the form to Google Sheets

1. In your Google Form, click the Responses tab at the top
2. Click the Google Sheets icon (green spreadsheet icon)
3. Select Create a new spreadsheet and name it "Incident Log [Year]"
4. Click Create — Google Sheets now automatically records every form submission in a new row

Your incident log is now built automatically. Every submission adds a row with timestamp, all form fields, and the submitter's email.

Part 3: Set up Zapier for instant notifications

1. Go to zapier.com and create a free account
2. Click + Create Zap
3. Trigger: Search for "Google Forms" → Select "New Response in Spreadsheet" → Connect your Google account → Select your incident log spreadsheet → Select the form responses sheet → Click Continue
4. Test the trigger: Submit a test form response. Zapier should detect it.

Part 4: Add the email notification action

1. Click + Add Step → Action
2. Search for "Gmail" (or "Email by Zapier" if you don't use Gmail)
3. Select "Send Email"
4. Configure:

   • To: your EHS email + your manager's email (separate with comma)
   • Subject: 🚨 New Incident Report — [Type of Event] at [Location] (use Zapier's field variables to pull from the form)
   • Body: Build the body using form field variables:

     Copy and paste this

     NEW INCIDENT REPORT SUBMITTED
     
     Submitted by: {{Name}}
     Date/Time: {{Date and Time of Incident}}
     Location: {{Location}}
     Type: {{Type of Event}}
     
     WHAT HAPPENED:
     {{What Happened?}}
     
     IMMEDIATE ACTIONS TAKEN:
     {{Immediate Actions Taken}}
     
     Reporter phone: {{Your Phone Number}}
     
     -- This notification was generated automatically. Log in to the Incident Log spreadsheet to view all submissions and update investigation status.
     

5. Click Continue → Test → Verify the email arrives

Part 5: Add a status tracking column to your Sheet

1. Open your Incident Log spreadsheet
2. In the last column header, type Investigation Status
3. Add a second column: Assigned To
4. Add a third: Due Date
5. These are manual columns — you'll fill them in as you triage each report

Your incident log is now a live tracker: new reports appear automatically, you update status as you investigate.

Part 6 (Optional): Add AI-generated investigation narrative

This step requires a Zapier paid plan or direct OpenAI API integration.

1. In your Zap, after the notification step, add + Action → OpenAI → Send Prompt
2. Configure:

   • Model: gpt-4o
   • Prompt: Write a brief professional incident investigation summary for an EHS specialist based on this initial report. Include: what happened, the immediate hazard, and 3 initial investigation questions to follow up on. Report data: [paste all field variables]
3. Add one more action: Gmail → Send Email to your own email
4. Body: The AI-generated summary
5. Subject: AI Draft: [Type of Event] at [Location] — Review Required

Now when a new incident comes in, within 5 minutes you receive: (1) the raw notification, (2) an AI-drafted investigation starting point.

Real Example: A Warehouse Near-Miss

Setup: You've built the form and Zapier workflow. QR codes are posted at all facility entrances and break rooms.

Input: A forklift operator submits a near-miss report on their phone in 90 seconds.

What you receive 4 minutes later — Email 1 (raw notification):

What you receive 5 minutes later — Email 2 (AI draft):

Time saved: Zero manual data entry. Incident log updated automatically. Management notified in under 5 minutes.

What to Do When It Breaks

• Form submissions don't trigger the Zap → Check Zapier's task history. If the trigger is running but not firing, re-test the Google Sheets connection — sometimes permissions need to be refreshed.
• Email arrives but fields are blank → In Zapier, re-map the form fields to the email body. Sometimes the field variable names change when the form is edited.
• AI step generates poor summaries → Improve the prompt: add more context about the facility type and what an EHS specialist needs. Provide an example of a good summary in the prompt.

Variations

• Simpler version: Skip Zapier entirely — just use Google Forms with email notifications and manually manage the Sheets log.
• Extended version: Add a Zapier step that creates a card in Trello or Asana with the incident details, assigned to you, with a 5-day due date for investigation completion.

What to Do Next

• This week: Build the form and test with a fake submission
• This month: Add the Zapier email notification and share the form QR code with one department as a pilot
• Advanced: Connect your Google Sheet to Looker Studio (free) to create an auto-updating safety dashboard that visualizes incident types, locations, and trends over time

Advanced guide for EHS Specialist professionals. Some steps require paid subscriptions.