We have been using SendGrid for some time for transactional email delivery, however - we are starting to send bulk packages of email at various intervals in an automated manner.
We are trying to find a way to send these bulk emails to sendgrid for delivery instead of our current process (looping over a list of users and sending the email iteratively)
Using something other than sendgrid is not an option
We need to basically have a way to upload a list of users, replacement values for keywords in the email: %first_name%, %username% etc - in order to send these emails to users.
What would be the best way to accomplish this?