create a blast emailer

This is the first step of a program that will be used by our company for email campaigns. If you work with us here, it is likely that we will have many more projects to improve this program. Input: 1. A google spreadsheet list contain information such as "name, business name, phone number, email and contact form URL" 2. Subject line, sender information and content written with "liquid" tags. ([login to view URL]). For example: The content of the email will be Hi Hi{% if [login to view URL] > 1 %} {{customer.business_owner | split: " " | first}}{% else %}{% endif %} business_owner= Dave Smith and the rendered content will be: "Hi Dave" Function: 1. The program will render and send the emails to email addresses listed in the google spreadsheet. *Must use an email gateway API which I will pay for. 2. The program will render and send the emails through contact forms listed in the google spreadsheets. (The contact forms URLs are provided). *You must use a captcha API to overcome contact form captcha. Output: Add to the google spreadsheet the date when the email was sent, if sending was successful. An example of the emails and data list is provided