People and organizations start using Twitter today for general public announcements or as a primary communication channel in closed communities. For example, I use Twitter when I want to share a story with my students or announce a newly available studying material. But what do you do if there are some people who do not want to use Twitter and still rely on email communication? By using Twitter API and Google AppsScript you can write and run a simple mashup that sends an email anytime you post a new message on Twitter.
To convert tweets to emails using AppsScript I set up a Google spreadsheet and wrote a mashup that fetches tweets from Twitter via Twitter API, checks whether a tweet has not already been emailed, sends the tweet via AppsScript email service and “remembers” the tweet so that it cannot be sent again next time the mashup is run. If you use the mashup on your own, you can control its operation by a number of parameters. You can specify a Twitter account you want to fetch tweets from, a comma separated list of email addresses, emails’ subject, and a creation date of the first tweet you want to start sending emails. In addition, you can control a maximum number of emails that the mashup should send per a single run.
Want to use the Twitter to email mashup on your own? Just make a copy of the Google spreadsheet, specify your input parameters on the first sheet and configure a trigger in the Google AppsScript editor. Feel free to make any modifications if you have specific requirements.