One Text Amount in getValues() Breaks the Whole Commission Total
A commission statement is the sum of a rep's deal amounts times the rate. The loop that computes it...
Oct 21, 20264 min read0 reactions0 comments
Back to articles Oct 21, 2026 
Oct 18, 2026
Oct 22, 2026
Oct 6, 2026
Oct 19, 2026
Oct 20, 2026
Sep 25, 2026
Oct 15, 2026
Oct 16, 2026
Sep 22, 2026
Sep 7, 2026
Sep 6, 2026
Tag archive
#magesheet
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...
Oct 18, 20269 min read5 reactions0 comments
Adobe Commerce to Looker Studio: SUM(grand_total) Is Not Revenue
The Adobe Commerce to Looker Studio guide on the MageSheet blog ends with a dashboard step: set...
Oct 22, 20269 min read5 reactions1 comments
The 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...
Oct 6, 20267 min read5 reactions0 comments
MailApp's Daily Limit Counts Recipients: Routing Sheet Email Between MailApp and a Provider
A Google Sheet that sends email usually ends up with two senders. MailApp for internal alerts,...
Oct 19, 20267 min read13 reactions0 comments
Apps Script Is Free. Your Triggers Share 90 Minutes a Day.
A free Gmail account can run Apps Script on a schedule without paying Google anything. There is no...
Oct 20, 20268 min read2 reactions0 comments
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...
Sep 25, 20265 min read5 reactions0 comments
Email From a Google Sheet: Claim the Row Before You Send It
Every guide to sending email from a Google Sheet ends with the same safety rule: write SENT next to...
Oct 15, 20269 min read0 reactions4 comments
Syncing a Google Sheet to a Mailjet List Without Re-Subscribing Anyone
A common setup: a customer list lives in a Google Sheet, and a nightly Apps Script job mirrors it...
Oct 16, 20268 min read5 reactions2 comments
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...
Sep 22, 20268 min read5 reactions0 comments
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...
Sep 7, 20266 min read1 reactions0 comments
Ops Per Run, Not Message Volume, Decides Rent or Build
A WhatsApp order bot at 2,000 messages a month looks like an obvious candidate to own rather than...
Sep 6, 20266 min read1 reactions0 comments