How to Get Email Notifications for TSQLTuesday

Update: Whoops! I made a mistake in the original run of this post in the setup of the IFTTT applet. I corrected it (hopefully), and updated the post, but TSQL2sday updates on the website happen once a month so still waiting to see the outcome of the test.

Lots of us want to write for TSQL Tuesday, but aren’t always on Twitter at the right time each month to see when the announcement comes out using the #tsql2sday hash tag. And maybe we have an RSS feed set up, but we often get behind on a big pile of posts to read. (Guilty!)

I want an email!

Wouldn’t it be nice to get a notification in your inbox when a new topic is announced, the week before TSQLTuesday itself?

You can set this up in two minutes by configuring a free IFTTT applet to email you when a new post goes into the RSS feed for TSQLTuesday.com.

IFTTT, or “If-This-Then-That” has been around since 2010. I first used it in the early days of the service when I was looking for a place to rent in a competitive market, and wanted to get notified of new postings on Craigslist. It’s very handy for custom notifications of all sorts.

How to set it up

Here’s how to set up your email:

  1. Create a free account on https://ifttt.com/. Your account settings are where you tell it your email address.
  2. Add the RSS feed to Email applet: https://ifttt.com/applets/147561p-rss-feed-to-email
    1. Click ‘Turn on’
    2. Optionally type a feed name into the top box
    3. Paste the feed URL into the bottom box: http://tsqltuesday.com/feed/
    4. Click save

The fine print: I just set this up for myself for TSQLTuesday. I have used this basic functionality on IFFT before, but I managed to set this up wrong the first time I wrote this post, and I’m on my second test now 🙂

2 Responses to How to Get Email Notifications for TSQLTuesday

  1. Martin Surasky September 19, 2017 at 8:28 am #

    Hi Kendra!

    Right after receiving this blog post I went on and set up my ifttt account to receive SQLTuesday notifications. I was expecting to receive September one via email but the date came and go and no email was sent to me.

    Did this work for you? anybody has tried? am I the only one who tried this technique and failed miserably?

    Thanks!

    • Kendra Little September 19, 2017 at 10:06 am #

      Hey Martin,

      I went back and looked at my past applets and I managed to screw up the setup on this one somehow. Moments of genius!

      I believe the top box is applet name and the bottom box is the feed URL. I was setting the feed URL as the name and leaving the default URL in there, and yeah… I can see why that wouldn’t work 🙂

      I updated the screenshots and the post.

      Kendra

Leave a Reply