I have a Google Spreadsheet that is full of values (that I am sending from my website). I need to send an email campaign to my customers using MailChimp. Of course, I am using an email Template. The issue is populating that email template with multiple rows of different values from the Google Spreadsheet.
I am sorry if this is a stupid question but I am new to this. I have sent the email and it contains dynamic values from only one row of my Google Spreadsheet. I need to basically choose more than one rows and populate those values in the template.
Also, this process should be automated. For example, as the Google Spreadsheet is filled with new values, they should all be picked from the spreadsheet and populating the template and sending the fully prepared template (with updated dynamic values) to MailChimp. Thanks in advance to everyone.
You can ask me any question, if you didn't understand what I said.