A script that checks my Google Docs spreadsheet contact list, and sends out emails to contacts x days after each contact was logged ("date" column), then y times every z days thereafter.
The way I see it working is it consecutively logs the dates of when it sends out emails into a column ("email sent dates"). That way it knows when it needs to send one (z) and how many left to send (y).
For contacts without a date in the "email sent dates" column it will check the "date" column (that's already on the spreadsheet now) and send it according to x (e.g. 3 days).
I will have a "status" column on the spreadsheet where I will manually input the contact's status such as "in contact", "working with", etc. If there's anything in that column the script will know not to send an email (because I'm already working with them).
In the config, I will need to be able to input x, y, and z; the spreadsheet column names the script will look for; emailed from / reply to address; the email messages to be sent (with the ability to address them by name in the message body and subject); and a way to cycle through those messages if the frequency exceeds the number of messages I have written (e.g. if I have only three messages written but I'm calling for six messages to be sent... the fourth email will use message one, and the fifth message two, and so on) - however I do not want message x to be cycled - I want message x to be separate.
In addition, I will need an easy way to input my email providers parameters into the config. I will need it to be universal so I can easily input any provider. I will need to be able to see the messages sent using my email providers interface (in this case I will be using Thunderbird).
Please give me a brief description on how you will execute the project.
Let me know if you have any questions.