The latest articles on DEV Community by Emi Miyagawa (@emi-miyagawa). https://dev.to/emi-miyagawa https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3870748%2F59233fd3-4bc5-46d6-a980-a0340160de01.jpg https://dev.to/emi-miyagawa en Emi Miyagawa Fri, 10 Apr 2026 03:41:41 +0000 https://dev.to/emi-miyagawa/thinks-in-systems-and-trade-offs-mhg https://dev.to/emi-miyagawa/thinks-in-systems-and-trade-offs-mhg <p>Based on a real case: Email automation using Google Apps Script</p> <h2> Case Example: Email Automation </h2> <h3> Problem </h3> <p>Manual email creation (~2–3 min per email)</p> <h3> Solution </h3> <ul> <li>Draft-based generation via GAS</li> <li>Structured input using Google Sheets</li> </ul> <h3> Result </h3> <ul> <li>Reduced to &lt;30 sec per email</li> <li>Enabled batch processing (30–50 emails/session)</li> </ul> <h3> Trade-off </h3> <ul> <li>Not fully automated</li> <li>Chose flexibility and human validation over speed</li> </ul> <p>Code: <a href="https://github.com/emi-miyagawa/operations-automation-gas" rel="noopener noreferrer">https://github.com/emi-miyagawa/operations-automation-gas</a></p> Emi Miyagawa Fri, 10 Apr 2026 02:49:35 +0000 https://dev.to/emi-miyagawa/how-i-reduced-email-processing-time-by-80-using-google-apps-script-1ndc https://dev.to/emi-miyagawa/how-i-reduced-email-processing-time-by-80-using-google-apps-script-1ndc <h2> Context </h2> <p>Back-office operations required manual email creation for each case (~2–3 minutes per email).</p> <h2> Problem </h2> <ul> <li>Repetitive copy-paste</li> <li>Formatting inconsistencies</li> <li>No scalability for batch processing</li> </ul> <h2> Solution </h2> <ul> <li>Structured input via Google Sheets</li> <li>Automated draft generation using Google Apps Script</li> <li>Draft-based approach to allow human validation</li> </ul> <h2> Result </h2> <ul> <li>Reduced time to &lt;30 seconds per email</li> <li>Enabled batch processing (30–50 emails/session)</li> <li>Improved consistency</li> </ul> <h2> Trade-offs </h2> <ul> <li>Not fully automated (manual review required)</li> <li>Prioritized accuracy over full automation</li> </ul> <h2> Key Takeaways </h2> <ul> <li>Automation should balance control and efficiency</li> <li>Draft-based systems are effective in non-perfect data environments</li> </ul> automation google javascript productivity