Survey and email campaign automation

The respondent clicks on a link that gives him access to a Google questionnaire
https://docs.google.com/forms/d/e/1FAIpQLScjeaahpnH0lOyhtTSSaYpJsyisiQd6BxaOzEQdZASFWrxPzg/viewform?usp=sf_link
He enters his email and answers questions
Answers are imported into a google sheet
https://docs.google.com/spreadsheets/d/1u_6ZCHRIi7xBE1XCidhWtMUCV5zBWLxbmHqY7Vb10bE/edit?usp=sharing
As soon as a new row is added, the following routine must be coded to automate the following:

Take the following items in their cells
Column B: Respondent's email
AB column: survey score

Variables according to score
If score between 0 and 2
Copy number from AB and insert into HTML newsletter block 1
Copy line from column AD1 and insert into HTML newsletter block 2
Copy line from column AD2 and insert into HTML newsletter block 3

If score between 3 and 4
Copy number from AB and insert into HTML newsletter block 1
Copy line from column AE1 and insert into HTML newsletter block 2
Copy line from column AE2 and insert into HTML newsletter block 3

If score 5
Copy number from AB and insert into HTML newsletter block 1
Copy line from column AF1 and insert into HTML newsletter block 1
Copy line from column AF2 and insert into HTML newsletter block 2

In all case copy Email address from column B in the “ To:” field of the email
Sending the email + a copy to frederick.buhr@zalis.com


HTML email template: