Notify new Mailchimp subscribers with personalized Gmail email and update Google Sheets status

Notify new subscribers in Mailchimp with a personalized email via Gmail, including a unique promotional code, while updating the code's status in Google Sheets for better tracking and engagement.