HKHayrullah Karinmagesheet-team.hashnode.dev·3d ago · 10 min readOne callModel() for Gemini, OpenAI and Claude in Apps ScriptA lead-classification job I built ran every inbound row through the flagship model because that was the model already wired up. 60,000 calls a month, about 800 input and 60 output tokens each. On clau00
HKHayrullah Karinmagesheet-team.hashnode.dev·Aug 22 · 11 min readWhen a Commission Rate Changes, Last Quarter's Payouts Shouldn'tA rep opened her March statement in August and the total had moved by $312. Nobody had edited the ledger. Finance had raised her rate in the Rules tab in July, the nightly recompute walked the full tr11R
HKHayrullah Karinmagesheet-team.hashnode.dev·Aug 18 · 15 min readApps Script Session Auth: Your Cache Expires Before Your Session DoesA user signs in at 09:05, works through the morning, and at 14:40 a click comes back with "your session has expired". They sign in again and the app behaves perfectly. The next day it happens at 11:2000
HKHayrullah Karinmagesheet-team.hashnode.dev·Aug 12 · 14 min readApps Script Handover Audit: Verify You Actually Own the Delivered CodeOwning the source code and owning the running system are two different things in Apps Script, and from inside the editor they look identical. You can hold every line, in a file in your own Drive, with00
HKHayrullah Karinmagesheet-team.hashnode.dev·Aug 11 · 9 min readMagento Order Sync in Apps Script: Page-Based Pagination Drops OrdersPoint a searchCriteria[currentPage] loop at a Magento store that is still taking orders, and the Sheet ends up disagreeing with the store. Some orders land twice, some never land at all. Nothing throw00