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
Responses
Markdown supported · ⌘↵ to post
StackShortlist
Proof Over Promises.
Treating the sheet as the source of truth for who exists, but never for who is subscribed, is the key distinction here. Mailjet's own unsubscribe and bounce status should always win over a row reappearing in the sheet, or one bad paste can re-add people who opted out. A small log tab listing each contact the job skipped and why also makes the nightly run much easier to trust.