Send personalized email to customers in Gmail, and format row in Google Sheets

Send personalized emails to customers who qualify for promotional offers, prompting them to activate their membership and select their site. Track new or updated rows in Google Sheets, filter for eligibility, and use Gmail for communication.