Đang Thực Hiện

Google Spreadsheet Auto Email Script

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.

Kỹ năng: Google App Engine, Java, Javascript, Python, XML

Xem thêm: google spreadsheet auto email, google check email script spreadsheet, google docs script date, auto email google spreadsheet, using google spreadsheet, use script in google spreadsheet, thunderbird javascript, spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, script google spreadsheet, java thunderbird, google. docs, give me my email, docs. google, anything auto, script email spreadsheet google, where is google docs, spreadsheet google, how to google docs, google script spreadsheet, google google docs, google docs status, google docs is

Về Bên Thuê:
( 11 nhận xét ) Las Vegas, United States

Mã Dự Án: #1061050

Đã trao cho:

brendonf

As discussed

$120 USD trong 7 ngày
(14 Đánh Giá)
3.8

5 freelancer đang chào giá trung bình $208 cho công việc này

srinichal

I will use the Google GDATA API and also smtp to send the emails

$250 USD trong 4 ngày
(50 Đánh Giá)
6.1
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Thêm

$200 USD trong 3 ngày
(21 Đánh Giá)
6.0
sabirmostofa

Expert php developer here. please check PM for details.

$250 USD trong 10 ngày
(8 Đánh Giá)
4.5
vic116

Hello, ready to write script for you

$220 USD trong 7 ngày
(4 Đánh Giá)
3.3