DEV Community

Emi Miyagawa
Emi Miyagawa

Posted on

Thinks in systems and trade-offs

Based on a real case: Email automation using Google Apps Script

Case Example: Email Automation

Problem

Manual email creation (~2–3 min per email)

Solution

  • Draft-based generation via GAS
  • Structured input using Google Sheets

Result

  • Reduced to <30 sec per email
  • Enabled batch processing (30–50 emails/session)

Trade-off

  • Not fully automated
  • Chose flexibility and human validation over speed

Code: https://github.com/emi-miyagawa/operations-automation-gas

Top comments (0)