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.

Compétences : Moteur Google App, Java, Javascript, Python, XML

en voir plus : 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

Concernant l'employeur :
( 11 commentaires ) Las Vegas, United States

Nº du projet : #1061050

Décerné à:


As discussed

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(14 Commentaires)

5 freelance font une offre moyenne de $208 pour ce travail


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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(50 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(21 Commentaires)

Expert php developer here. please check PM for details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(8 Commentaires)

Hello, ready to write script for you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)