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 own it does not stop a double send. It stops the next run from repeating the last one. It does nothing about two runs that are reading the sheet at the same time. That happens more easily than it…
We haven't written up this one. Dev.to has the full story — the link below goes straight to it.