quick and dirty way to blast a CSV list of emails with template data using Node and the Mandrill API
use http://akhoury.github.io/pages/mandrill-blast/
You need to have NodeJS installed and running, then
npm install mandrill-blast
OR
git clone https://github.com/akhoury/mandrill-blast.git
cd mandrill-blast node blast.js --source="sample.emails.csv" --key="0123456789" --template="sample.template.html" --from-email="you@example.com" --from-name="Your Name" --to-email-column="email" --subject="Hi {{name}}" --to-name-column="name"
MUST have headers for each column, at the top
id,email,name,friend,location,token 1,dude@example.com,gooby,derp,fakeville,123456789 2,dudette@example.com,goobette,derpina,fakecity,987654321
uses Handlerbars format for templating, it's pretty simple see sample.template.html for an example.
You need an account and a valid API Key, get one at mandrill.com
- make it a reusable module
- anything that the heart desires, I needed this as a 10 minutes hack and it got the job done, if you have ideas or needs, submit a pull or feature request.