Automation Recipe: Auto-Send Compliance Training Reminders

What This Builds

Instead of manually exporting LMS completion lists, filtering non-completers, and copying names into reminder emails every week during compliance training season, this automation does it for you. Once set up, it checks a Google Sheet of learner completion data each Monday, finds everyone who hasn't completed the course before the deadline, and sends each of them a personalized reminder email automatically.

You go from spending 1–2 hours per week on this task during compliance season to spending 15 minutes once to verify the automation ran correctly.

Prerequisites

• Google account (Gmail + Google Sheets)
• Zapier account (free tier handles this automation) at zapier.com
• Your LMS can export a CSV of learner completion status (most can; check your LMS reports)
• Deadline for compliance training established
• Comfortable with Google Sheets basics (formulas, filtering)

The Concept

Think of this automation as a mail merge that runs itself on a schedule. You maintain one Google Sheet as the "source of truth" for who has and hasn't completed. Zapier watches that sheet, finds the non-completers before the deadline, and sends each one a personalized email with their name and course link included. You update the sheet (by re-exporting from your LMS), and the automation handles the rest.

The key insight: you don't need a fancy LMS integration. A weekly CSV export + Google Sheet + Zapier is enough to automate the most time-consuming part of compliance training administration.

Build It Step by Step

Part 1: Set up your Google Sheet

Create a new Google Sheet with these exact column headers in Row 1:

• Employee Name: Full name for personalized email
• Email: Where reminder goes
• Course Name: Which compliance course (for the email subject)
• Completion Status: Type exactly "Complete" or "Incomplete" (capital C and I; this is what Zapier will filter on)
• Deadline: Date in MM/DD/YYYY format (e.g., 04/15/2026)
• Manager Email: Optional, for sending a manager CC

Your weekly process: Export completion data from your LMS as CSV → copy/paste into this sheet → update the Completion Status column. The automation runs from this sheet.

Test your sheet first: Add 3 test rows: 2 with "Incomplete" and 1 with "Complete." You'll use these to test the automation before going live.

Part 2: Write your reminder email template

Before building in Zapier, write the reminder email you want to send. You'll enter this text into Zapier later.

Subject: Reminder: [Course Name] Due [Deadline]

Hi [First Name],

Just a quick reminder that your [Course Name] training is due by [Deadline].

Here's your direct link to complete it:
[LMS LINK — you'll add this as a static URL]

The course takes approximately [X] minutes to complete. If you run into any technical issues, reply to this email or contact [SUPPORT EMAIL].

Thank you for completing this on time.

[Your Name]
Training & Development Team

Note: In Zapier, the bracketed items become dynamic fields that pull from your Google Sheet columns.

Part 3: Create the Zapier automation

Go to zapier.com → sign in → click "Create Zap" → "Start from scratch."

Step 1 — Trigger: New or Updated Row in Google Sheets

1. Search for "Google Sheets" → select "New or Updated Spreadsheet Row"
2. Connect your Google account if not already connected
3. Select your spreadsheet and the sheet tab
4. Click "Continue"
5. Test the trigger. Zapier reads your test rows.

Step 2 — Filter: Only continue if status is "Incomplete" AND deadline hasn't passed

1. Click the "+" between trigger and action → "Filter by Zapier"
2. Set up Filter Rule 1: Completion Status → Text exactly matches → Incomplete
3. Click "Add AND filter"
4. Set up Filter Rule 2: Deadline → Date is after → today

This means the automation only runs for rows where status = Incomplete AND the deadline hasn't already passed (so you don't spam people after the deadline).

Step 3 — Action: Send email via Gmail

1. Click "+" → search "Gmail" → select "Send Email"

2. Connect your Gmail account

3. Fill in the email fields:

   • To: Select the Email column from your Google Sheet
   • Subject: Type "Reminder: " then insert the Course Name field, then " Due " then the Deadline field
   • Body: Paste your email template, replacing each bracketed placeholder with the corresponding Google Sheet column field
   • From Name: Your name or "Training Team"

4. Click "Continue" → "Test action"

Zapier sends a test email to the address in your first test row. Check that the fields populated correctly.

Step 4 — Schedule the Zap

By default, Zapier checks for new/updated rows every few minutes (free tier: every 15 minutes).

For compliance reminders, you want this to run weekly, not continuously. To schedule:

1. Go to your Zap settings
2. Change the trigger from "Instant" to "Scheduled" (if your trigger supports it)
3. OR: Update your Google Sheet every Monday morning after your LMS export. The Zap will trigger on the updated rows.

The simplest approach for free-tier Zapier: update the sheet on Monday mornings after your LMS export. The Zap detects the updated rows and sends reminders automatically within 15 minutes.

Step 5 — Turn on your Zap

Click the toggle (top right of your Zap) to turn it ON.

Part 3: Test with real data before going live

Before enabling for your full learner population:

1. Set up 5 real test rows with your own email address and 4 colleagues who've agreed to test
2. Set them all to "Incomplete"
3. Run the Zap manually (click "Run" in the Zapier dashboard)
4. Confirm emails arrive, fields are correct, and links work
5. Set test rows to "Complete" to confirm those rows are filtered out

Key test to run: Confirm that employees who completed the course (status = "Complete") do NOT receive reminder emails. Check 3–4 complete rows are properly filtered.

Real Example: Q1 Cybersecurity Awareness Campaign

Setup: 450 employees must complete the annual cybersecurity training by March 31. Your LMS exports a weekly completion CSV.

Monday morning routine (15 minutes total):

1. Export completion report from Cornerstone LMS as CSV (3 minutes)
2. Paste into your Google Sheet. The Completion Status, Email, and Employee Name columns update (5 minutes).
3. Glance at the Zapier activity log to confirm the automation ran (2 minutes)
4. Review any emails that bounced or failed (5 minutes)

What the automation does: Sends personalized reminder emails to everyone with "Incomplete" status whose deadline hasn't passed. Monday, Week 3: 180 reminders sent automatically. Monday, Week 4 (1 week before deadline): 85 remaining non-completers receive escalating reminder.

Setup: 90 minutes (one time) Input: Weekly 5-minute LMS export + sheet update Output: 180 personalized emails sent automatically, with zero additional effort Time saved per week: 90 minutes of manual filtering and email sending → 5 minutes of oversight

What to Do When It Breaks

• Emails send to completed learners → Check your Filter step. Confirm the "Text exactly matches Incomplete" rule is case-sensitive and your sheet uses consistent capitalization ("Incomplete" not "incomplete").
• Fields show as blank in emails → In the Zapier email action, re-map the fields from your Google Sheet. The field mapping sometimes needs a re-connection after sheet changes.
• Zapier doesn't detect sheet updates → Make sure the trigger is set to "New or Updated Spreadsheet Row" not just "New Row." Updates to existing rows need the "or Updated" version.
• Automation runs but sends no emails → The Filter may be too restrictive. Check that at least one test row passes all filter conditions and the deadline column date is formatted consistently with what you entered in Zapier.

Variations

• Simpler version: Skip the deadline filter and just run manually once a week. Open the Zap, click "Run," it sends to all Incomplete rows. Less elegant but zero filter debugging.
• Extended version: Add a second Zap that sends a manager CC when their direct report is within 3 days of the deadline and still incomplete. Add the manager email column and a second email action triggered by a "Days until deadline < 3" filter.

What to Do Next

• This week: Set up the Google Sheet structure and write your email template. Don't build in Zapier yet. Get the foundation right first.
• This month: Run the automation for your next compliance course launch. Compare time spent vs. previous campaigns.
• Advanced: Connect directly to your LMS API (if supported) to eliminate the weekly export step entirely. Some LMS platforms have native Zapier integrations.

Advanced guide for corporate trainer professionals. Zapier free tier (100 tasks/month) may be sufficient for small teams; Starter plan ($20/mo) handles larger populations. Gmail or Outlook required.