Korean indie dev, 3–4 years in. I turn messy Google Sheets into Apps Script automations and ship small AI web apps and PWAs. English or Korean.
- Tweets 389
- Following 0
- Followers 13
- Likes 33
Pinned Tweet
Fixing one annoying Google Sheet for free for the first 3 people. A broken formula or a Form that dumps chaos into a tab, that size of thing. Reply or DM me your messiest one. If you're happy, an honest review is all I want back. No upsell, promise 🙌
1
231
Showing an error the second someone types invalid data is usually worth the extra setup. Much easier to fix on the spot than untangling it after save.
Friendly Apps Script reminder: installable triggers run as the user who set them up, not the person currently clicking around the sheet.
2
Spreadsheet quiz: sorting can move an order to a different row, but its ID stays with it. If you import that same order again, new row or update the old one?
1
7
Same order ID, same fields? Skip. Changed fields? Review. Preview catches the mismatch, but it doesn't make the import a transaction: dev.haeminway.com/devlog/goo…
5
Fun Apps Script gotcha: installable triggers execute under whoever created the trigger, not the sheet owner or whoever edited the cell.
14
CSV quotes don't make Sheets keep IDs as text. Import the ID column as text. dev.haeminway.com/devlog/app…
7
Built my own academy LMS (student PWA, parent view, staff app) for attendance and homework. Keeping the views separate and simple is half the battle. If you run a small academy or tutoring setup and have workflow questions, shoot me a DM!
8
If you're still building quotes by hand from Sheets, you can set up a small Apps Script to turn row data into clean PDFs with one click. Taking on a couple small automation setups if you want yours sorted!
10
A small Google Sheets and Apps Script gotcha: getValues() returns Date objects for date cells, even when the cell looks like a simple value. I normalize dates before sending rows to an API so the payload stays predictable.
11
I built and run my academy LMS with three apps: student PWA, parent viewer, and staff. It tracks attendance, homework, lesson progress, vocab, and listening tests.
12
Classic Apps Script gotcha: installable triggers run as whoever created them, not whoever edited the sheet. If a teammate shares a sheet and the automation goes silent, check whose account owns the trigger.
8
If you have a Google Sheet where you're manually copy-pasting the same stuff every week, I can probably automate that with Apps Script.
Shoot me a DM with what goes in and what should come out 🙌
12
Daily Quote Card is live! Rebuilt with 103 bilingual quotes, on-device notes/calendar, and no login.
DM me if you run a small business and need a clean phone tool for one specific job: dev.haeminway.com/portfolio/…
9
Stock sheets shouldn't make you play hide and seek with the empty shelf. Tell me your reorder level and I'll make the low rows go red by themselves. Which item always runs out right when you need it?
11
Yuzu #8. The five stages of grief, but for a router. Acceptance shows up as one blinking light 🙃
(AI-generated animation, made with Google Flow)
Made with AI
15
This checkmark takes its job very seriously. Want one like it in your sheet? Check a box, the time gets logged. I can build it for you, DMs open 👀 (AI-made art)
1
19
If your sheet has a column begging for timestamps, DM me what it tracks and we'll scope it out. More of what I build at dev.haeminway.com/
1
1
6
One Eraser with Qty 0 and AND() flagged all six rows. AND doesn't go row by row inside ARRAYFORMULA, it just eats the whole range. Multiply instead: (B2:B11>0)*(C2:C11>0). Five ok, one check. If yours does this, DM me a few fake rows
1
18
The Eraser with Qty 0 deserved better. The full formulas and the other ARRAYFORMULA traps are here: dev.haeminway.com/devlog/arr…
8
One Eraser with Qty 0. Five perfectly normal rows. This formula runs on all six:
=ARRAYFORMULA(IF(A2:A11="",,IF(AND(B2:B11>0,C2:C11>0),"ok","check")))
How many say "check"? Drop your guess, answer in replies 👀
1
8
All six say check 😅 AND eats the whole column and spits out one answer. Multiply instead, (B2:B11>0)*(C2:C11>0), and add them for OR. 5 ARRAYFORMULA one-liners and their traps here dev.haeminway.com/devlog/arr…
4