HR professional builds task tool with ChatGPT and GAS, questions its value
An HR practitioner experimented with using ChatGPT to write Google Apps Script (GAS) code for a task management tool in Google Sheets. Without programming experience, they created a system that auto-categorizes deadlines, color-codes cells, and sends daily email alerts for upcoming due dates. The build process involved describing requirements in Japanese, pasting AI-generated code into GAS, and…
Key points
- Built HR task tool in Google Sheets using ChatGPT to write GAS code with no coding experience
- Tool auto-categorizes deadlines, color-codes cells, and sends daily email alerts for upcoming tasks
- Author questions ROI: tool may not significantly streamline work and raises maintenance concerns for team use
After completing the tool, the author questioned its practical value. While it functions as a personal reminder, they found it does not significantly streamline work and may only slightly improve scheduling accuracy. Maintenance concerns emerged: if errors occur when the creator is absent, or if workflows change, other team members may not be able to fix the AI-generated code. The author concludes that "can be done with AI" and "worth using AI for" are different, and plans to test a payroll anomaly detection tool next using fictional data.
[HR x AI Challenge #1] I tried automating tasks by having ChatGPT write GAS. But then I wondered, "Is this really necessary?"
note.com · 29 September 2026
Loading the full article…
This text was published by note.com and written by 管理ちゃん. It is reproduced here with attribution so you can read it in full; the rights remain with the publisher. Read it at the source ↗
The headline, key points and digest above were generated by Digest AI's editorial model from the linked sources. Automated summaries can contain errors: the sources are the record. Spotted a mistake? Tell us. Published by Martin K., who runs Digest AI and handles corrections.
More in Marketing & Small Business
All →- ChatGPT’s ‘not X but Y’ phrasing frustrates users and researchers · 1 src
- Claude Opus 5.5 costs 60% less than Fable 5.1 for writing tasks · 3 src
- Google pays 100 publishers for AI overview content in tests · 1 src
- ChatGPT users can create one rule to fix repeated failures · 1 src
- Author advises standardizing CRM definitions before adding sales AI, citing Microsoft case studies · 1 src
Comments
via GitHub Discussions