Goal: connect ChatGPT to my Google Sheets with a simple script.

Desired behavior: whenever I add a new customer name to the sheet, a personalized email for that customer is written automatically.

Task: explain how I can set this up, and walk me through the logic step by step.