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.
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.