I built an automation following this youtube: https://www.youtube.com/watch?v=Zfo8QurhtZ0
Successfully extract the table from the google sheet.
However, when i send the email, the email body successfully extract the correct first name and email content, however the email is sent to everyone in the excel sheet. (i.e. each email with tailored made content is sent to all the rows in the excel, and everyone receives multiple emails with different name.
Can somebody help look into this?