KLKaruna Labsinkarunalabs.hashnode.dev·14h ago · 7 min readHow to Find Unanswered Emails in Gmail (Both Directions) With a Free Apps ScriptHow to Find Unanswered Emails in Gmail (Both Directions) With a Free Apps Script Gmail search can't tell who sent the last message. This script can. It labels threads waiting on them and threads waiti00
HKHayrullah Karinmagesheet-team.hashnode.dev·3d ago · 10 min readThe Sheet Outlives AppSheet. Check That Its References Do.The usual argument for AppSheet over Power Apps is about where the data lives. AppSheet keeps its records in a Google Sheet you own, so if you cancel the subscription the app disappears and the spread00
NANithin Ainnithin-a.hashnode.dev·4d ago · 7 min readSo… Who Thought This Form Was a Good Idea?Well, it was in 2023 during my first year as Webmaster. Well, I had made a script to automate the generation of HTML code to get posts from LinkedIn to our website. I didn't even need to copy, paste, 00
HKHayrullah Karinmagesheet-team.hashnode.dev·Sep 27 · 8 min readAn Empty Reminder Inbox Is Not an Empty PipelineA daily follow-up digest is the first automation worth adding to a spreadsheet CRM. A trigger fires at eight, a script reads the deals tab, and anything due or overdue lands in your inbox. Mine ran fo00
HKHayrullah Karinmagesheet-team.hashnode.dev·Sep 25 · 7 min readThe 24-Hour Window Decides Whether Your WhatsApp Reply Sends or Gets RejectedThere are exactly three ways to automate WhatsApp: rent a SaaS platform, wire up Meta's Cloud API yourself, or build on Google Sheets and Apps Script. I have built the third one, and what surprised me00
HKHayrullah Karinmagesheet-team.hashnode.dev·Sep 22 · 11 min readTwo Invoices, One Number: Allocate Invoice Numbers From the Log, Not a CellA Google Sheets invoice template does one job well: it prints. The header, the line items, the four formulas at the bottom. The automation people bolt on afterwards reads the invoice number out of cel00
HKHayrullah Karinmagesheet-team.hashnode.dev·Sep 7 · 8 min readYour Chatbot Verified the Price, Then Pasted It Into a Sentence It WroteA grounded chatbot retrieves the right catalog rows, asks the model which price it used, looks that price up, and compares. Mine did all of that and still quoted a stale price to a customer. The retri00
HKHayrullah Karinmagesheet-team.hashnode.dev·Sep 6 · 9 min readOps Per Run, Not Message Volume, Decides Rent or BuildA WhatsApp order bot at 2,000 messages a month looks like an obvious candidate to own rather than rent. I priced one that way and the arithmetic said the opposite: at that volume the rented plan never00
HKHayrullah Karinmagesheet-team.hashnode.dev·Sep 1 · 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
