Tag

#google-apps-script

145 posts8 followers

Explore Hashnode

Alternatives

Hayrullah Kar1d ago · 13 min read

Google Workspace Offboarding: A Dry Run That Survives a Failed Step

Our guide to automating Google Workspace onboarding and offboarding builds the leaver process around a dry run. planOffboarding reads the account and writes a plan to a sheet, a person reviews it, and

magesheet-team.hashnode.dev

Hayrullah Kar3d ago · 14 min read

WhatsApp Response Time in Google Sheets: The Webhook Can't Tell Your Bot From Your Agent

Our guide to syncing WhatsApp conversation data into Google Sheets says the first response time must not count automated replies. An auto-acknowledgement is not a response, and if you count it your me

magesheet-team.hashnode.dev

Hayrullah KarOct 22 · 12 min read

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 grand_total to a currency and check that the aggregation is Sum. I ran the guide's Apps Script against a

magesheet-team.hashnode.dev

Hayrullah KarOct 21 · 5 min read

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 is four lines long, and it can return a figure wrong by millions without raising an error. In my com

magesheet-team.hashnode.dev

Hayrullah KarOct 20 · 10 min read

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 licence, no seat and no per-run charge, and my guide to what Apps Script costs walks through why. The

magesheet-team.hashnode.dev

Hayrullah KarOct 19 · 9 min read

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, because it needs no account and costs nothing. A provider such as Mailjet for anything a customer sees, b

magesheet-team.hashnode.dev

Hayrullah KarOct 18 · 11 min read

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 arriv

magesheet-team.hashnode.dev

Hayrullah KarOct 16 · 11 min read

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 into a Mailjet contact list so campaigns go to whoever is in the sheet. The simplest version of that j

2 magesheet-team.hashnode.dev

Hayrullah KarOct 15 · 12 min read

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 each row after you mail it, so a rerun skips what already went out. The rule is right, and on its ow

3 magesheet-team.hashnode.dev

Karuna LabsOct 9 · 7 min read

How to Find Unanswered Emails in Gmail (Both Directions) With a Free Apps Script

How 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 waiti

karunalabs.hashnode.dev

Search Hashnode

Explore Hashnode

Trending tags this week

Google Workspace Offboarding: A Dry Run That Survives a Failed Step

WhatsApp Response Time in Google Sheets: The Webhook Can't Tell Your Bot From Your Agent

Adobe Commerce to Looker Studio: SUM(grand_total) Is Not Revenue

One Text Amount in getValues() Breaks the Whole Commission Total

Apps Script Is Free. Your Triggers Share 90 Minutes a Day.

MailApp's Daily Limit Counts Recipients: Routing Sheet Email Between MailApp and a Provider

Your Mailgun Webhook Checks the Signature. Does Your Inbound Route?

Syncing a Google Sheet to a Mailjet List Without Re-Subscribing Anyone

Email From a Google Sheet: Claim the Row Before You Send It

How to Find Unanswered Emails in Gmail (Both Directions) With a Free Apps Script