---
title: "#magesheet articles | Hashnode"
description: "Explore 69 articles tagged #magesheet on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/magesheet"
---

Tag

# #magesheet

69 posts · 0 followers

[Hayrullah Kar](https://hashnode.com/@magesheet) · [2d ago](https://hashnode.com/posts/google-sheets-to-custom-app-log-two-weeks-of-edits-before-you-ask-for-a-quote/6af981f77ee70ce106b40160)

### [Google Sheets to Custom App: Log Two Weeks of Edits Before You Ask for a Quote](https://magesheet-team.hashnode.dev/google-sheets-to-custom-app-log-two-weeks-of-edits-before-you-ask-for-a-quote?utm_source=hashnode&utm_medium=feed)

Collisions and accountability are the two sheet problems you can count. An installable onEdit log, an overlap finder and a report with a rule of thumb that is mine, tested with 113 tests.

18 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/google-sheets-to-custom-app-log-two-weeks-of-edits-before-you-ask-for-a-quote?utm_source=hashnode&utm_medium=feed)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [4d ago](https://hashnode.com/posts/google-forms-approval-self-approval-apps-script/6af602c44ae4b38c185ba137)

### [Google Forms Approvals in Apps Script: When the Requester Approves Their Own Request](https://magesheet-team.hashnode.dev/google-forms-approval-self-approval-apps-script?utm_source=hashnode&utm_medium=feed)

A manager submits a 300 request for herself, the chain is just her, and the status becomes APPROVED. Seven results from running the code, and three functions that fix them.

15 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/google-forms-approval-self-approval-apps-script?utm_source=hashnode&utm_medium=feed)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [Nov 7](https://hashnode.com/posts/outgrown-google-sheets-formula-audit-apps-script/6aef5092740d55cd99e290c9)

### [Outgrown Google Sheets? Count the Slow Formulas Before You Decide](https://magesheet-team.hashnode.dev/outgrown-google-sheets-formula-audit-apps-script?utm_source=hashnode&utm_medium=feed)

One Apps Script function counts NOW(), A:A ranges and IMPORTRANGE in every tab and writes a Sheet health report. Testing it also found three inputs our locked recordSale() let through.

12 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/outgrown-google-sheets-formula-audit-apps-script?utm_source=hashnode&utm_medium=feed)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [Nov 5](https://hashnode.com/posts/build-vs-buy-break-even-google-sheets/6aecc4134175d3022d7bdd99)

### [Build vs Buy in Google Sheets: The Break-Even Cell That Said -400 Months](https://magesheet-team.hashnode.dev/build-vs-buy-break-even-google-sheets?utm_source=hashnode&utm_medium=feed)

B / (S - R - M) is the right formula. In a sheet it returns -400 when upkeep eats the saving, and it holds the subscription flat for three years. Three custom functions fix both.

11 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/build-vs-buy-break-even-google-sheets?utm_source=hashnode&utm_medium=feed)

[2](https://hashnode.com/posts/build-vs-buy-break-even-google-sheets/6aecc4134175d3022d7bdd99)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [Nov 1](https://hashnode.com/posts/apps-script-failed-retry-ledger-watchdog/6ae73cbe21d3303efa05a8a0)

### [Apps Script Error Handling: The Failed Invoice Your Ledger Skips Forever](https://magesheet-team.hashnode.dev/apps-script-failed-retry-ledger-watchdog?utm_source=hashnode&utm_medium=feed)

Run against fakes, the guide's retry ledger skipped a send that threw on every later run: 0 invoices sent, heartbeat ok. A failed state, a retry limit and a watchdog with memory fix it.

12 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/apps-script-failed-retry-ledger-watchdog?utm_source=hashnode&utm_medium=feed)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [Oct 28](https://hashnode.com/posts/workspace-offboarding-dry-run-resume/6ae1947284c79ec38b967bbf)

### [Google Workspace Offboarding: A Dry Run That Survives a Failed Step](https://magesheet-team.hashnode.dev/workspace-offboarding-dry-run-resume?utm_source=hashnode&utm_medium=feed)

Run against a fake Admin SDK, the plan-then-apply offboarding script could not finish after one transient error, wiped a phone twice, and ignored a row the reviewer deleted. Moving the plan into the sheet fixes all three.

13 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/workspace-offboarding-dry-run-resume?utm_source=hashnode&utm_medium=feed)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [Oct 26](https://hashnode.com/posts/whatsapp-response-time-in-google-sheets-the-webhook-can-t-tell-your-bot-from-your-agent/6adf104fa412e85d1ebd0847)

### [WhatsApp Response Time in Google Sheets: The Webhook Can't Tell Your Bot From Your Agent](https://magesheet-team.hashnode.dev/whatsapp-response-time-in-google-sheets-the-webhook-can-t-tell-your-bot-from-your-agent?utm_source=hashnode&utm_medium=feed)

Run on fake events, the usual webhook-to-Sheets code logs a 2-second bot acknowledgement and a 10-minute agent reply as identical rows. Tag every outgoing message, and count business minutes.

14 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/whatsapp-response-time-in-google-sheets-the-webhook-can-t-tell-your-bot-from-your-agent?utm_source=hashnode&utm_medium=feed)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [Oct 24](https://hashnode.com/posts/my-inbox-sloth-has-to-quote-the-sales-pitch-before-it-files-it-away/6add3590a90ef15485eb3786)

### [My Inbox Sloth Has to Quote the Sales Pitch Before It Files It Away](https://magesheet-team.hashnode.dev/my-inbox-sloth-has-to-quote-the-sales-pitch-before-it-files-it-away?utm_source=hashnode&utm_medium=feed)

A local Gemma model sorts my inbox overnight. Prompt rules alone were not stable at temperature 0, so the code checks every sales pitch label against the email itself.

9 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/my-inbox-sloth-has-to-quote-the-sales-pitch-before-it-files-it-away?utm_source=hashnode&utm_medium=feed)

[2](https://hashnode.com/posts/my-inbox-sloth-has-to-quote-the-sales-pitch-before-it-files-it-away/6add3590a90ef15485eb3786)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [Oct 22](https://hashnode.com/posts/adobe-commerce-to-looker-studio-sum-grand-total-is-not-revenue/6ada4b76e45e5683bfa0e3a2)

### [Adobe Commerce to Looker Studio: SUM(grand\_total) Is Not Revenue](https://magesheet-team.hashnode.dev/adobe-commerce-to-looker-studio-sum-grand-total-is-not-revenue?utm_source=hashnode&utm_medium=feed)

Run against a fake store, the Orders tab from the usual recipe keeps cancelled orders as pending and adds euros to dollars. A row that carries net revenue in base currency, and a check against the store.

12 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/adobe-commerce-to-looker-studio-sum-grand-total-is-not-revenue?utm_source=hashnode&utm_medium=feed)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [Oct 21](https://hashnode.com/posts/one-text-amount-in-getvalues-breaks-the-whole-commission-total/6ad92e206211a13322e8bbba)

### [One Text Amount in getValues() Breaks the Whole Commission Total](https://magesheet-team.hashnode.dev/one-text-amount-in-getvalues-breaks-the-whole-commission-total?utm_source=hashnode&utm_medium=feed)

getValues() returns text cells as strings, so += concatenates instead of adding. A tested fix that parses amounts to cents and throws on unreadable cells.

5 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/one-text-amount-in-getvalues-breaks-the-whole-commission-total?utm_source=hashnode&utm_medium=feed)
