I need to send auto e-mails to some of our customers based on the data on specific cells in my Google Spreadsheet. I do not want to send the emails from gmail account. I have another domain for the email which is not gmail. So I need to use mandrill api to use our own domain. The summary of this project is:
1- Auto emails to the customers in the spreadsheet
2- These auto emails would be triggered at a time in a day and based on an information on specific cells. And also it should be OK when I want to send
3- Email's domain should be another email which is not gmail as I will tell.
I have mandrill account with verified domain and APIs