HR & RECRUITING
Certification Expiry 30/60/90 Renewal Scheduler
Runs daily against an Airtable certifications register, finds credentials hitting 90, 60, and 30 days to expiry.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule fires each morning
- ActionRead certification register from AirtableAirtable
- LogicCompute days-to-expiry, pick 90/60/30 day rows not yet reminded
- ActionEmail employee a milestone renewal reminderGmail
- OutputStamp reminder tier + timestamp on the Airtable rowAirtable
What it does
Scans your employee certification register every morning and sends tiered renewal nudges at 90, 60, and 30 days before each credential lapses. Each employee gets exactly one email per milestone, and the register records when each reminder went out so nobody is pinged twice.
When to use it
Use this when your workforce holds renewable credentials (CPR, OSHA, forklift, security clearances, professional licenses) and you want gentle, escalating self-service reminders before HR has to chase anyone. Best when employees can renew on their own and just need a timely heads-up.
How it works
- 1A daily schedule fires the workflow each morning.
- 2The flow reads all active certification rows from Airtable, including expiry date and the last-reminder-sent field.
- 3A logic step computes days-to-expiry and selects rows crossing the 90, 60, or 30 day thresholds that have not already been reminded at that tier.
- 4For each matched row it sends the employee a milestone-specific email via Gmail with renewal instructions and the deadline.
- 5The matching Airtable row is updated with the reminder tier and timestamp so the same milestone never re-sends.
Set it up
What you configure once, before turning it on.
- 1Connect AirtableBases, tables, views, automations.
- 2Connect GmailRead, draft, send, label.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More HR & Recruiting workflows
Day-one readiness orchestrator across all onboarding owners
An agent-driven coordinator that, when a hire is launched, plans the full provisioning program across IT, Facilities, and Finance, opens the work in your tracker.
Escalate Compliance-Blocking Credential Lapses to Managers
Each day it finds credentials that have already expired or expire within 48 hours and are flagged compliance-blocking.
Assemble and send the debrief packet after the final interview
Triggered when a candidate's final interview ends on the calendar, it waits a short window for scorecards, compiles the aggregated packet to Google Drive.
Credential Renewal Evidence Verification Agent
When an employee replies with a renewed credential document, an agent reads the attachment, extracts the new expiry date and credential number.
New-Hire Credential Intake to Renewal Calendar Holds
When a new credential is added to the tracker, it validates the record, files the document.
New-hire equipment order email to IT and vendor
On a scheduled lead-time before each start date, drafts and sends an equipment order email (laptop, monitor.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.