Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Hayrullah Kar
Outgrown Google Sheets? Count the Slow Formulas Before You Decide
Our guide to outgrowing Google Sheets lists six signs that a business needs a real system. Sign 3 is the one people reach for first: the file is slow, scripts time out, a filter takes eight seconds. It is also the easiest one to get wrong, because "the sheet feels slow" is an opinion, and an opinion is a weak reason to start a custom software project. The guide's own advice is to fix the sheet first, because the soft limits arrive long before the hard ones.
Our build-vs-buy guide gives one formula for deciding whether to replace a subscription with your own automation: break-even months = B / (S − R − M). B is the one-time build cost, S the subscription per month, R what the build costs to run, M monthly maintenance. In a sheet it is one cell: =B2/(B1-B3-B4). Run it with a small tool's numbers: 10 seats at $12, a $12,000 build quote, and maintenance at the guide's fallback of 15% of the build a year. The cell comes out at -400.
Which Sheet Automations Get a Human Approval Step, and Which Just Run?
Every Apps Script job we build for a small team ends with the same argument: should this run straight through, or should it stop and wait for a person? Our current line is roughly this: Runs straight through: reads, summaries, formatting, and anything that only writes inside the same spreadsheet and can be redone by running it again. Writes a plan first, then waits: anything that deletes, sends something outside the company, or changes money.
Your Mailgun Webhook Checks the Signature. Does Your Inbound Route?
A common way to wire Mailgun into a Google Sheet is one Apps Script web app with two jobs. Event webhooks report on mail you sent: delivered, opened, failed. An inbound Route forwards email that arrives at your domain, so each message becomes a row. The first version of that handler in my Mailgun guide on the MageSheet blog verified the signature on event webhooks and wrote inbound mail straight to the sheet. The inbound post looks different, so the signature seemed to belong to the other path.
A common setup: a customer list lives in a Google Sheet, and a nightly Apps Script job mirrors it into a Mailjet contact list so campaigns go to whoever is in the sheet. The simplest version of that job sends every row to Mailjet with the action addforce. It runs cleanly for weeks, and it re-subscribes anyone who clicked unsubscribe since the last run, because that is exactly what addforce is documented to do. The fix is not one setting.
The 24-Hour Window Decides Whether Your WhatsApp Reply Sends or Gets Rejected
There 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 me is how little that choice changes about the part that actually breaks. All three send through the same official Cloud API, and that API applies the same rule to all three. You may send a free-form message only within 24 hours of the customer's most recent message to you.
Two Kits, One Shared Part: The Stock Your Sheet Counts Twice
A Google Sheets inventory template gives every SKU one row and one number: quantity on hand. That holds for as long as every SKU is a thing sitting on a shelf. Then you list two bundles. Desk Set A is a body and a black cap. Desk Set B is the same body and a grey cap. You have five bodies, five black caps, five grey caps, so the sheet gets two more rows, and both of them say five. Both numbers are correct. Their sum is not. The storefront offers ten desk sets and there are five bodies in the building.
Two Invoices, One Number: Allocate Invoice Numbers From the Log, Not a Cell
A 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 cell B4, exports the sheet as a PDF, emails it, and appends a row to a Log tab: const invoiceNo = sheet.getRange('B4').getValue(); // ... export, email ...
Your Chatbot Verified the Price, Then Pasted It Into a Sentence It Wrote
A 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 retrieval was fine. The verification was fine. The line that broke it was the one that came after: answer = answer.replace(String(out.priceUsed), String(livePrice)); The model had reported priceUsed: 1299 and written $1,299.00 in its sentence.
The ledger asks the model to show its work before it counts the money
This is a submission for Weekend Challenge: Generosity Edition What I Built A donation ledger for a group too small to buy software. It is a Google Sheet, some Apps Script, and one public page a donor can open. The group I had in mind is the kind that exists on every street: a neighbourhood fund, a school parents' group, a committee that collects for winter coats. Money arrives over WhatsApp and leaves in cash, and somebody keeps it in a notebook. The arithmetic is not the hard part.
AppSheet vs Apps Script vs PowerApps (2026): When to Use Each
"Should we use AppSheet or Apps Script?" is the wrong question — and I've watched teams waste weeks arguing it. They're not competitors. AppSheet delivers a UI; Apps Script runs logic. Most production setups I build end up using both. This post is how to decide which does what, what it actually costs per user, and the hybrid pattern you'll probably land on. What each one actually is AppSheet is a no-code app builder.
UrlFetchApp Quotas & Retries in Apps Script: Backoff, Rate Limits & a Dead-Letter Queue
A nightly product-enrichment job I built quietly dropped ~300 rows one night. No error, no alert. An upstream API had rate-limited us with a 429, UrlFetchApp.fetch threw, the loop died halfway, and the next run started fresh — the skipped rows just never came back. Every UrlFetchApp integration hits this eventually. The fix isn't one clever function; it's four small layers that keep a transient failure from becoming silent data loss. Here's the stack I use, with the code.
Use Google Sheets as a Translation Database for Your Web App (Apps Script + Next.js)
Every i18n setup I've seen has the same three-way standoff. Developers want type-safe JSON in the repo. Translators want a familiar tool, not a pull request. Product wants to fix a typo without a deploy. So you either pay $50–$500/month for a localization SaaS, or you copy-paste strings between a translator's spreadsheet and your JSON files until something silently breaks. For projects under ~1,000 keys, there's a better middle: the spreadsheet is the database.
How to Actually Unit-Test Google Apps Script (Vitest, Mocks & Clasp CI)
The bug that finally made me set up tests was a tax rounding error that quietly shipped wrong totals for two weeks. It lived in a plain function — no Sheets, no API — the kind of thing a single unit test would have caught in a second. But the project had zero tests, because the last person who tried had hit the wall everyone hits: Jest can't load SpreadsheetApp. Apps Script is testable. You just can't test all of it the same way.
Build a WhatsApp Storefront in Google Sheets with OpenAI Function Calling (No Website)
A café owner asked me for an online store. She didn't want Shopify, a domain, a theme, or a $90/month bill — she wanted customers to message her on WhatsApp, ask what's available, and place an order. That's not a website. That's three functions and a spreadsheet. Here's the whole thing: an AI that browses your catalog and logs orders over chat, backed by two Google Sheets tabs, for under $20/month. It's about 200 lines of Apps Script, and the three tools that do the work are below — verbatim.
Build a Commission Attribution Engine in Google Sheets (Matching, Splits & Clawbacks)
A rep pings you: "My payout is $340 short." You open the sheet, and three hours later you find it — the customer paid from ali.veli+billing@gmail.com instead of the address on the account, so the sale never got attributed to anyone. The math was never wrong. In the commission cleanups I've done for clients, nearly every dispute traced back to this: the payment didn't match the right rep. I'd put it around 95% — matching, not arithmetic. Yet almost everyone builds the calculator first.
Build a Real-Time Inventory Dashboard in Google Sheets (Reorder Points + Low-Stock Alerts)
A marketing campaign works, 150 units sell in a day — and 40 were in stock. Now you have 110 angry customers, refunds, and a marketplace penalty for overselling. The campaign that was supposed to make money just cost you money and trust. The fix isn't a $200/month inventory app. It's a Google Sheet that knows your reorder point per product, tells the difference between stock you have and stock you can actually sell, and emails you before you run out. This post builds it, with the code.
Let Your Marketing Team Edit Content Without Touching Code (2026)
Every content team has a version of this story. The marketing manager has copy ready. The changes are simple: swap a headline, update a product description, publish a new blog post. But the CMS is tangled with custom fields only a developer can navigate, or worse, the content lives directly in the codebase. So she opens a Jira ticket. The developer, mid-sprint, adds it to the queue. Three days later, the change goes live. Three days for a headline swap.
WhatsApp Automation for Small Businesses in 2026: AI Replies, Lead Capture & Tiered Commissions
Your customers would rather message you on WhatsApp than fill in a contact form. That's fine at ten conversations a day. At a hundred, messages get missed, nobody knows which rep is on which deal, and at month-end somebody rebuilds the commission sheet by hand and gets it wrong. The usual answer is a $49–$499/month WhatsApp SaaS platform, priced per seat, with your customer data living in someone else's database.
Build a Gumroad Lead Machine in Google Sheets (Ping Webhook + License API + AI Upsell)
A traditional B2B funnel asks a stranger to fill a form, wait for a sales rep, and sit through a call — and it typically converts around 0.1–0.5%. I stopped running that. Instead I sell a small $29 product on Gumroad and let the purchase itself qualify the lead. This post is the Apps Script that turns every Gumroad sale into a logged, license-verified lead with an AI-personalized follow-up email — no CRM, no Zapier, about 70 lines you can copy.
Build a WhatsApp Sales Inbox in Google Sheets (Apps Script + GPT-4o-mini)
Last month a client's two sales reps both spent an hour chasing the same WhatsApp lead. Neither closed it — the customer felt double-teamed and went quiet. Their "system" was one shared WhatsApp login and a lot of hope. I rebuilt it as a Google Sheets sales inbox: every WhatsApp message lands in a sheet, gets an AI buying-intent score, and gets locked to one rep for 15 minutes. This post is the whole build, with the code — about 80 lines of Apps Script you can copy and adapt.
Replace Expensive SaaS With Google Workspace + Apps Script (CRM, Billing, Inventory)
Most growing companies quietly bleed $1,000–$5,000 a month on software they barely use. It's subscription bloat — a CRM, a Zapier, a Calendly, a billing tool — each raising prices 10–30% a year, each built so you can't easily leave. For a lot of SMBs, you can replace most of that stack with tools you already pay for: Google Workspace + Apps Script. Here's what to replace, the highest-ROI patterns, and — honestly — when not to.
Extracting Invoices From WhatsApp Photos With AI Vision (Apps Script + Google Sheets)
Every logistics and field-sales team runs the same expensive process: a driver photographs a receipt into a WhatsApp group, and a back-office clerk manually types the invoice number, total, and date into a spreadsheet. Hundreds of receipts a week = transcription errors and thousands of wasted hours. AI vision models kill that bottleneck. Here's the pipeline that turns a blurry field photo into clean structured data in seconds. Why vision models beat traditional OCR OCR reads characters.
Turning WhatsApp Into a Mobile ERP for Field Logistics (Apps Script + Google Sheets)
Field-service software has an adoption problem: drivers won't use it. Heavy app, another login, crashes in low-signal areas. So the "real-time" data still shows up as end-of-shift phone calls. The fix that actually sticks: stop building an app and use the one drivers already live in — WhatsApp. With Apps Script and Google Sheets behind it, WhatsApp becomes a frictionless mobile ERP. Here's the build. WhatsApp as a data-entry terminal A driver texts Status ABC-1234 Delivered.
Four signals I built into an OSS decision score instead of fabricating reviews
The OSS alternatives directory launched with a content problem: AlternativeTo and SaaSHub have years of user reviews. Mine went live in April with zero. Fabricating reviews is a policy violation. Soliciting them takes time I don't have in month two of a six-month experiment. What I built instead is a decision score — four signals derived from GitHub data I already fetch during ETL, each converted into a labeled rating that differs per entry.
AI-Powered B2B Lead Scoring on Autopilot via Google Sheets & Gemini
Imagine dozens of new potential clients (leads) flooding into your B2B database or registration forms every single day. When your sales team clocks in, how do they know which prospect to call first? Does an individual registration from j.doe@gmail.com carry the same weight on your list as a corporate procurement request from procurement@ibm.com?
Beyond the Grid: Building Secure, Zero-Cost B2B Client Portals on Google Sheets
Every growing B2B organization eventually hits the same operational barrier: how do you share critical, row-level transactional data with an external client without exposing the rest of your corporate database? If you run business operations out of Google Sheets, your instinctive reaction might be to lean on protected ranges, hidden tabs, or individual spreadsheet workbooks.
I Contain Multitudes (and Also Three Git Repos)
My blog is older than most of the tools I use to run it. The oldest posts started life on LiveJournal sometime in the early 2000s, got dragged through a WordPress import at some point in the mid-2000s, spent the better part of a decade as a Hugo site, and, about a week ago, moved into an Astro 5 site that reproduces every one of those old URLs byte for byte. That's 2,630 posts spanning 2001 to 2020, frozen exactly where they landed.
Cosmic as Agent Memory: Structured, Versioned, and Queryable
This is a refreshing take on the agent memory bottleneck. Everyone jumps straight to vector DBs for semantic retrieval, but they completely neglect the operational reality of running agents in production: debugging, human-in-the-loop validation, and prompt regression. Treating a headless CMS/structured API store as the episodic memory layer is brilliant for one major reason: human observability.
How to Build a Free Omnichannel PIM System with Google Workspace and Magento 2
Managing product data across Adobe Commerce (Magento 2), Amazon, and physical POS systems is a constant, exhausting battle for omnichannel merchants. Keeping description variants, localized pricing matrices, and high-resolution digital assets aligned across isolated operational silos quickly devolves into absolute chaos. The corporate reflex to this problem is predictable: throw enterprise budget at it.
How to Build a Serverless B2B CRM: Automating Magento 2 into Google Workspace
If you are running Adobe Commerce (formerly Magento B2B), you already know the complexity of modern wholesale operations. You are likely managing corporate "Company Accounts," dealing with tiered negotiated catalogs, and configuring custom buyer roles. But here is where most merchants trip over: Operational latency. When a large B2B wholesale buyer registers on your site, waiting for a human administrator to manually copy-paste their registration data into an enterprise CRM is a liability.
How to Leverage Magento 2 Asynchronous Bulk APIs in Google Apps Script (Zero Timeouts)
When connecting Google Workspace to enterprise e-commerce infrastructures like Adobe Commerce (Magento 2), most developers fall into a resource-heavy architecture trap. They write a basic synchronous loop in Google Apps Script to push catalog changes row by row.
Building a Static Site with Astro and Cosmic CMS
Astro's HTML-first philosophy is having a moment. A post on Hacker News this week about doubling user growth by going HTML-first cracked the top 10 with 383 points, and the replies were full of developers reconsidering their stacks. The short version: ship less JavaScript, get faster sites, keep more visitors. Astro is purpose-built for exactly this.
Building a Serverless Bridge: Syncing Magento 2 Orders to Google Sheets in Real-Time
E-commerce operations live and die by data velocity. For enterprise engineering teams running Magento 2 (Adobe Commerce), extracting transactional order data for downstream fulfillment, accounting, or B2B sales pipelines can be a persistent infrastructure bottleneck. Most companies either rely on archaic end-of-day CSV exports or pay hundreds of dollars a month for third-party middleware connectors that choke under heavy seasonal API polling limits. Today, we will eliminate the middleman entirely.
Preventing Stockout Crises: Building Automated Inventory Alerts in Google Sheets
The "Out of Stock" badge is arguably the most damaging message you can display to a high-intent shopper. In digital commerce, when a customer cannot purchase instantly, they pivot to a competitor in seconds. The financial impact goes far beyond a single lost sale—the Customer Acquisition Cost (CAC) spent to capture that user is completely vaporized, and repairing broken brand trust is exceptionally high.
Goodbye CSV Nightmares: Automating Magento Order Line Item Exports in Google Sheets
A high-performing e-commerce store lives and dies by its warehouse fulfillment speed. However, for teams running on Adobe Commerce (Magento), a massive operational bottleneck exists right out of the box: exporting order line items cleanly. When operations managers use Magento's native "Export Orders" functionality to generate a CSV for their pick-and-pack teams, the resulting spreadsheet is notoriously chaotic.
Ditch Looker/Tableau: Build a Live Executive BI Dashboard in Google Sheets
When an organization scales, leadership naturally looks for Business Intelligence (BI) solutions to visualize performance. The corporate instinct is almost always the same: sign an expensive, long-term contract with Tableau, PowerBI, or Looker. While these are phenomenal enterprise platforms, they carry heavy licensing fees and require data engineers to set up and maintain complex ETL pipelines.
Automating Magento BI Dashboards in Google Sheets (Ditch Static CSVs)
While Magento maintains robust e-commerce capabilities, its native dashboard lacks the dynamic flexibility that modern Operations and Finance teams demand to make agile decisions. To calculate custom KPIs, forecast inventory, or run cohort analyses, businesses invariably resort to the same painful routine: exporting massive order lists into spreadsheet software. However, relying on manual, static CSV exports means your executive data is already outdated the second the download finishes.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Hayrullah
Contact Hayrullah, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack