THE CHALLENGE: One of our clients came to us wanting us to produce an email for every one of their stores, twice a month, and send them the code. That doesn’t sound like a big deal except they have 27 stores! So that was 54 emails pre month! Seeing that I was the only developer; that task took up most of my time.
THE SOLUTION: Since all of the emails followed same look; I created a templated system and connected it to a Google Spreadsheet which the client would send to me twice a month. This system automatically generates an email based off of the information they supply in the sheet. Problem solved!