Cover placeholder
09 / Automation
HR Tools — Automated Email Sender
Status change triggers branded candidate emails.
Solo developer2025Apps ScriptSheets
03 / Context
Problem
Tim HR mengirim email status kandidat secara manual; delay dan inkonsistensi template sering terjadi saat volume tinggi.
04 / Concept
Solution
Trigger Apps Script pada perubahan status di Sheets untuk mengirim email HTML branded secara otomatis.
01 / Outcome
Deliverable
- Trigger on status change
- HTML email templates
- Send log di sheet
02 / Process
Workflow
- 1Update status kandidat
- 2Detect change via trigger
- 3Render template HTML
- 4Kirim via GmailApp
- 5Catat timestamp
05 / System
Architecture
- Sheets HR board
- Apps Script trigger
- Gmail send layer
06 / Diagram
Flowchart
01Status edit
02Read template
03Send email
04Write log
07 / Data
Database Design
Candidates
| Column | Type | Notes |
|---|---|---|
candidate_id | STRING | — |
email | STRING | — |
status | STRING | — |
last_notified | DATETIME | — |