# HR professional builds task tool with ChatGPT and GAS, questions its value

Digest AI · Marketing & Small Business · published 2026-09-29T17:25:00Z

Canonical: https://digestai.news/story/hr-professional-builds-task-tool-with-chatgpt-and-gas-questions-its-va

## Summary

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 iterating on errors by sharing screenshots with ChatGPT.

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.

## 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

## Why it matters

Shows non-technical staff can now build automation with AI coding help, but highlights the gap between technical feasibility and organizational value, especially around maintenance and ROI.

## Sources

1. [HR x AI Challenge #1 I tried automating tasks by having ChatGPT write GAS. But then I wondered, "Is this really necessary?"](https://note.com/net648/n/nb59611591cb9?hl=en) (note.com, 2026-09-29)

## Cite

Digest AI, "HR professional builds task tool with ChatGPT and GAS, questions its value", 29 September 2026, https://digestai.news/story/hr-professional-builds-task-tool-with-chatgpt-and-gas-questions-its-va

---

Written by Digest AI's editorial model from the linked sources; the sources are the record. Headlines, digests and key points are written by Digest AI and may be quoted with a link to the story page. Linked articles belong to their publishers. Terms: https://digestai.news/terms#reuse
JSON: https://digestai.news/story/hr-professional-builds-task-tool-with-chatgpt-and-gas-questions-its-va.json