Email Scheduler for Gmail

[Michael Demsey]

Step-by-step process on how to schedule and send Gmail emails with Google Spreadsheets

http://dmzilla.com/2014/12/08/how-to-schedule-gmail-emails-to-send-at-a-later-date-or-time/

[Blair Kutzman]

[+ad...@dmzilla.com]

Hello Michael,

Thanks for the post!

I'm assuming you're emailing for feedback on the product/design, so here are my thoughts:

• I love the idea of reusing the Google spreadsheet date chooser as the scheduling mechanism. By far the most complicated and troublesome part of Gmail Delay Send is using Date.js to parse the dates.
• Gmail Delay Send has to edit the message (to remove the date part) so getting the format correct is another problem that you have cleverly avoided!  :-)

Doc suggestions:

• Might want to link to more information about the limit of 100 emails per day. Many people have questions about this. Also it might be worth testing this failure case is handled gracefully in your script as people do hit this frequently.
• You might want to mention the limit on the number of recipients also (gmail delay send info which links to google).
• You mention Privacy in the "third party services" section. And you also say that they are giving "Google Spreadsheets" access to their account not DMZilla. But aren't they giving your code inside the spreadsheet access to their account? This seems misleading.. 

Design suggestions:

• Instead of having them manually click a 'import from drafts' button when they open, I wonder if you could hook into the spreadsheet open hook and execute that automatically? Probably a good idea to keep menu in case they want to refresh manually though. The original gmail delay send script worked much like this, you can still find the code here.
• Also you might want to consider how you're going to update the code you have inside the spreadsheet. Inevitably you will find something you want to change or new functionality that you'd like to enable.  The original gmail delay send had a url fetch mechanism to do this (link to code above). It would pull down the latest .js file and just call .exec on it. That way I could update the downloaded .js file when i wanted to update but people didn't have to re-install the script. You could also consider building a simple web app instead of the spreadsheet approach. Then they could access easily from a phone. The backend could still be a spreadsheet but they wouldn't know that.
• It might be cool if the ID column contained a link to the email in their draft box? Either that or maybe hide the whole column. Not sure users care what the ID is if they can't do anything with id.

Some nit grammer stuff

• In the advantages section "Google and they anyways have the access to everything" I think you want to remove "the".
• Step 1: "Do add" might be just "Add"

But overall looks great! Have you done other Google Apps scripts? I don't know much about it, but have you considered adding it to the Gallery?

-Blair

On Wed, Dec 10, 2014 at 1:19 PM, Michael Demsey <michael...@gmail.com> wrote:

Step-by-step process on how to schedule and send Gmail emails with Google Spreadsheets

http://dmzilla.com/2014/12/08/how-to-schedule-gmail-emails-to-send-at-a-later-date-or-time/

--
You received this message because you are subscribed to the Google Groups "GmailDelaySend" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gmaildelaysen...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.