{"id":320,"date":"2012-01-29T22:49:33","date_gmt":"2012-01-29T22:49:33","guid":{"rendered":"http:\/\/wobable.com\/?p=320"},"modified":"2012-01-29T23:16:19","modified_gmt":"2012-01-29T23:16:19","slug":"how-to-add-a-countdown-to-your-twitter-profile-photo","status":"publish","type":"post","link":"https:\/\/wobable.com\/?p=320","title":{"rendered":"How to add a Countdown to your Twitter Profile Photo"},"content":{"rendered":"<blockquote><p>&#8220;Wouldn&#8217;t it be cool to run a Twitter countdown to the Olympics? We could change the profile image each day to show how many days there are left!!&#8221;<\/p><\/blockquote>\n<p>That was my challenge. It took me a little while to work out, but I found a very elegant solution &#8211; which I hope will help you too. Obviously it can be used to countdown to any event &#8211; but with 6 months until the Olympic Cycling Road Race comes to Surrey, the Olympic opening ceremony will be my focus!<\/p>\n<h2>The effect<\/h2>\n<p>Every day, the Twitter profile image for the countdown account changes to show how many days are left.\u00a0I created an animated gif of the profile image countdown so you can get the idea of what we are aiming for. One of these each day:<\/p>\n<p><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/Countdown.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"Countdown\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/Countdown.gif\" alt=\"\" width=\"153\" height=\"153\" \/><\/a><\/p>\n<p>As well as changing the avatar, I want to schedule a tweet to go out each day to let people know how long it is until the Olympics start.<\/p>\n<h2>The thinking part&#8230;<\/h2>\n<p>Sending a countdown tweet would be easy &#8211; I could schedule that in CoTweet (at least\u00a0<a href=\"http:\/\/mashable.com\/2012\/01\/21\/free-cotweet-alternatives\/\">until they axed the free version!<\/a>)<\/p>\n<p>Changing the profile image was the taxing bit. I could fairly easily create lots of profile images with a different number on each, but I was clear from the start I wanted to automate changing the images over &#8211; I haven&#8217;t got the time or patience to go into Twitter every day to change the image. On top of that, it should ideally change over at midnight &#8211; so it is accurate all day. I could then schedule to send a countdown tweet later in the day (when people would be awake to see it).<\/p>\n<p>A quick Google later, the closest apps I could find were:<\/p>\n<ul>\n<li><a title=\"Twimsy\" href=\"http:\/\/www.twimsy.com\/\">Twimsy<\/a>\u00a0an app that allows you to change your avatar to one of 9 previously uploaded versions by sending a message to @twimsy. I could schedule a tweet to change it, but would need to keep reloading new images&#8230;<\/li>\n<li><a href=\"http:\/\/www.twiback.com\/en\/\">Twiback<\/a>\u00a0an app that rotates through a number of pictures you preload. You can set what time it changes, but I couldn&#8217;t work out how to change the image to a <em>particular<\/em> picture.<\/li>\n<\/ul>\n<p>I even looked at writing a PHP script and running a <a href=\"http:\/\/en.wikipedia.org\/wiki\/Cron\">cron job&#8230;<\/a>but my programming skills are really not up to it!<\/p>\n<h4>IFTTT to the rescue!<\/h4>\n<p>Then I remembered <a href=\"http:\/\/ifttt.com\/wtf\">IFTTT.com<\/a>. This awesome site allows you to easily join together different Channels, and set tasks that follow the description &#8220;If <span style=\"color: #ff0000;\">THIS<\/span> then <span style=\"color: #ff0000;\">THIS<\/span>&#8220;. For instance &#8220;If <span style=\"color: #ff0000;\">[I post to YouTube]<\/span> then <span style=\"color: #ff0000;\">[post to my Twitter]<\/span>&#8220;.\u00a0That <a href=\"http:\/\/ifttt.com\/wtf\">link <\/a>will explain it far better than I can &#8211; go off and read it. I&#8217;ll wait!<\/p>\n<p>In IFTTT parlance THIS is known as a trigger and THAT is an action. The action we want \u00a0is the &#8220;update Twitter profile photo&#8221; action. This requires a filename as an input.<\/p>\n<p>My first plan was to trigger it at a certain date and time &#8211; but that would require 180 different IFTTT tasks (one for each day of the countdown). That was way too much work.<\/p>\n<p>Then I thought of using the &#8220;every day at a certain time&#8221; trigger. The downside of this is I need a way of telling it which image to upload. I wondered about using an &#8220;addin&#8221; from the date\/time trigger (this is a piece of information that the trigger passes to the action), but was struggling to connect the addin to the file name.<\/p>\n<h2>The solution<\/h2>\n<p>Finally, I had a brainwave&#8230;IFTTT can use Google calendar entries as a trigger, and the contents of the calendar as addins. If you know IFTTT then this is what we are aiming for:<\/p>\n<p><a title=\"Click for the IFTTT recipe\" href=\"http:\/\/ifttt.com\/recipes\/18882\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-325\" title=\"Twitter Profile Picture Countdown IFTTT Task\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task-6506672.png\" alt=\"The IFTTT Task for updating the profile picture based on a Google calendar\" width=\"641\" height=\"232\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task-6506672.png 641w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task-6506672-300x108.png 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task-6506672-150x54.png 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task-6506672-400x144.png 400w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/a><\/p>\n<p>Whenever there is a calendar entry with a title containing the keyword &#8220;ProfilePic&#8221;, update the image of the Twitter account to the filename stored in the &#8220;Description&#8221; field of the calendar.<\/p>\n<p>Read on for a more detailed explanation covering:<\/p>\n<ul>\n<li><a title=\"How to add a Countdown to your Twitter Profile Photo\" href=\"https:\/\/wobable.com\/?p=320&amp;page=2\">How to prepare the countdown profile images<\/a><\/li>\n<li><a href=\"https:\/\/wobable.com\/?p=320&amp;page=3\">How to bulk upload the calendar entries<\/a><\/li>\n<li><a href=\"https:\/\/wobable.com\/?p=320&amp;page=4\">How to use IFTTT to link the Google Calendar and Twitter together<\/a><\/li>\n<li>Oh, and an added bonus discussion on using IFTTT to schedule tweets!<\/li>\n<\/ul>\n<p style=\"text-align: right;\"><em>Next page: How to prepare the countdown images&#8230;<\/em><\/p>\n<p><!--nextpage--><\/p>\n<h2>How to prepare the countdown images&#8230;<\/h2>\n<p>The Twitter profile image is an important part of your online identity, so I&#8217;d look to overlay the existing image with a countdown (so it looks like it&#8217;s a <a href=\"http:\/\/twibbon.com\/join\/Go-Surrey\">twibbon<\/a>).<\/p>\n<p>Start by preparing your base image in your image editor of choice. I made it 300dpi, and 5cm square:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CountdownBackdrop.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-thumbnail wp-image-326\" style=\"border-image: initial; border-width: 1px; border-color: black; border-style: solid;\" title=\"CountdownBackdrop\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CountdownBackdrop-150x150.png\" alt=\"The backdrop for my Twitter profile countdown\" width=\"150\" height=\"150\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CountdownBackdrop-150x150.png 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CountdownBackdrop-300x300.png 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CountdownBackdrop-400x400.png 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CountdownBackdrop.png 591w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a><\/p>\n<p>We now need to add the countdown overlay. While it is not the immediately obvious choice, I think the quickest and best way to do this is using MS PowerPoint!<\/p>\n<p style=\"text-align: left;\">Create a new PowerPoint document, click &#8220;page setup&#8221; and set the slide size to 5cm by 5cm:<\/p>\n<p style=\"text-align: left;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-327\" title=\"powerpointscreengrab1\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab1-300x196.jpg\" alt=\"Set the document size to 5cm by 5cm\" width=\"300\" height=\"196\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab1-300x196.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab1-150x98.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab1-400x261.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab1.jpg 762w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Insert the backdrop image into the Slide Master, so that it appears behind the default text boxes:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-328\" title=\"powerpointscreengrab2\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab2-300x296.jpg\" alt=\"The PowerPoint Master Slide\" width=\"210\" height=\"207\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab2-300x296.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab2-150x148.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab2-400x394.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab2.jpg 535w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Then format and fill the subtitle with &#8220;days to go&#8221;, and replace the title with the slide number (click on the image for a more detailed view):<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab31.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-330\" title=\"powerpointscreengrab3\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab31-300x216.jpg\" alt=\"Insert the slide number into the title field\" width=\"270\" height=\"194\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab31-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab31-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab31-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab31.jpg 1023w\" sizes=\"auto, (max-width: 270px) 100vw, 270px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">You can probably see where we are going with this&#8230;insert the number of duplicate slides that you need to countdown (in my case 179&#8230;). The page numbers then create the effect of a countdown (well count up) &#8211; one on each slide!<\/p>\n<ul>\n<ul>\n<li>If it is only a few, you can do this manually for each slide.<\/li>\n<li>If you have some, don&#8217;t forget that you can duplicate multiple slides at a time. (Highlight them before clicking &#8220;duplicate slide&#8221;)<\/li>\n<li>If you have a lot to create (and understand macro programming), this piece of macro code might help:<\/li>\n<\/ul>\n<\/ul>\n<pre>Public Sub HowManyDuplicateSlides()\r\nFor i = 1 To InputBox(\"How many slides do you want to add?\")\r\n     Set newSlide = ActivePresentation.Slides(1).Duplicate\r\nNext i\r\nMsgBox (\"All done - \" &amp; i - 1 &amp; \" duplicate slides added!\")\r\nEnd Sub<\/pre>\n<p>Last thing, don&#8217;t forget to change the word &#8220;days&#8221; to &#8220;day&#8221; on slide 1!<\/p>\n<p>Now we need to export all the slides to\u00a0separate\u00a0images. This is easily done in PowerPoint &#8211; open up the &#8220;save as&#8221; dialogue box and select &#8220;.jpeg&#8221; from the &#8220;save as type&#8221; dropdown. You will then get asked if you want to export every slide:<\/p>\n<p><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-337\" title=\"powerpointscreengrab4\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab4-300x216.jpg\" alt=\"&quot;Export every slide&quot; dialogue box\" width=\"300\" height=\"216\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab4-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab4-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab4-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab4.jpg 1023w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>After a short while (depending on how many slides are exported) you should end up with a whole folder filled with countdown images. Each will be labelled &#8220;SlideX&#8221; where X is the number of days to go:<\/p>\n<p><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-338\" title=\"powerpointscreengrab5\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab5-300x216.jpg\" alt=\"The finished countdown images in a folder\" width=\"300\" height=\"216\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab5-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab5-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab5-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/powerpointscreengrab5.jpg 1023w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>You then need to upload all these images to the internet somewhere. I put them on my server &#8211; you could probably use a free image host of some sort. The key is you need to retain the same filenames.<\/p>\n<p>You probably also want to create a final image to be uploaded when the event arrives &#8211; one without any countdown graphics of any sort. I called mine &#8220;Slide0&#8221;.<\/p>\n<p style=\"text-align: right;\"><em>Next page:\u00a0How to bulk upload the calendar entries to Google calendar&#8230;<\/em><\/p>\n<p><!--nextpage--><\/p>\n<h2>\u00a0How to bulk upload Google calendar entries<\/h2>\n<p>Now we have our images, the next step is to create the Google Calendar entries. We could do this by hand &#8211; but the chance of making a mistake is high so I prefer to spend time automating it.\u00a0The idea here is to fool Google Calendar into accepting a CSV file which it thinks has been exported from Outlook.\u00a0Instead, we have hand crafted it in Excel. This spreadsheet should make life easier for you:<\/p>\n<p><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/EmptyCountdownFile.xls\">EmptyCountdownFile.xls<\/a><\/p>\n<p style=\"text-align: left;\">Basically you fill in the boxes on the first sheet.<\/p>\n<div align=\"center\">\n<p><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-342 alignnone\" style=\"margin-left: 10px; margin-right: 10px;\" title=\"ExcelScreenGrab1\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab1-300x216.jpg\" alt=\"Fill in the excel spreadsheet with the details of the countdown\" width=\"210\" height=\"151\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab1-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab1-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab1-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab1.jpg 1023w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Switch to the second sheet and it is already filled out, ready for you to export as a CSV file. Don&#8217;t worry that there are empty rows towards the bottom of the sheet (it will create up to 366 calendar entries &#8211; enough for a full year countdown), or that there are some numbers in column A (used as part of the functions to fill the fields). Google Calendar seems to just ignore any data it doesn&#8217;t understand.<\/p>\n<p><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-343 alignnone\" style=\"margin-left: 10px; margin-right: 10px;\" title=\"ExcelScreenGrab2\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab2-300x216.jpg\" alt=\"Save the second worksheet as a CSV file - select &quot;Save As -&gt; Other Formats&quot;\" width=\"210\" height=\"151\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab2-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab2-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab2-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab2.jpg 1023w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">You will need to select &#8220;CSV&#8221; from the &#8220;Save file as type&#8221; dropdown menu.<\/p>\n<p><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-344 alignnone\" style=\"margin-left: 10px; margin-right: 10px;\" title=\"ExcelScreenGrab3\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab3-300x216.jpg\" alt=\"Select &quot;CSV&quot; from the &quot;Save as type&quot; drop down menu.\" width=\"210\" height=\"151\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab3-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab3-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab3-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ExcelScreenGrab3.jpg 1023w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<\/div>\n<p style=\"text-align: left;\">During the save you will be prompted by two warning boxes. One tells\u00a0you that CSV files can only contain one sheet (click &#8220;OK&#8221;), and the other talks about features that are not compatible with CSV format (Click &#8220;Yes&#8221;).<\/p>\n<p style=\"text-align: left;\">Now you need to import your CSV File to Google Calendar.\u00a0I&#8217;ll assume you already have a Google calendar set up.<\/p>\n<p style=\"text-align: left;\"><strong>The first thing to do is to turn off default reminders. <\/strong>This is because you don&#8217;t want an email or text message at midnight each night to tell you that the profile image is changing! I have bolded it because Google Calendar won&#8217;t allow you to reimport the same appointment twice, so you need to get \u00a0it right first time!<\/p>\n<p style=\"text-align: left;\">In Google Calendar, select &#8220;settings&#8221;<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-345\" style=\"margin-left: 10px; margin-right: 10px;\" title=\"CalendarScreengrab1\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab1-300x216.jpg\" alt=\"Remove default reminders by clicking &quot;settings&quot;\" width=\"210\" height=\"151\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab1-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab1-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab1-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab1.jpg 1023w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<p>and then remove the default reminder settings:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-346 alignnone\" style=\"margin-left: 10px; margin-right: 10px;\" title=\"CalendarScreengrab2\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab2-300x216.jpg\" alt=\"Remove any default reminders in Google Calendar\" width=\"210\" height=\"151\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab2-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab2-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab2-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab2.jpg 1023w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Save your change and go back to the calendar. It is now time to import the CSV file. Select &#8220;Other calendars &#8211;&gt; Import calendar&#8221;.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-349 aligncenter\" title=\"CalendarScreengrab3\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab3-300x216.jpg\" alt=\"\" width=\"210\" height=\"151\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab3-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab3-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab3-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab3.jpg 1023w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Now choose the CSV file you saved earlier.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-350 alignnone\" style=\"margin-left: 10px; margin-right: 10px;\" title=\"CalendarScreengrab4\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab4-300x216.jpg\" alt=\"\" width=\"210\" height=\"151\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab4-300x216.jpg 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab4-150x108.jpg 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab4-400x288.jpg 400w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/CalendarScreengrab4.jpg 1023w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">and hey presto &#8211; 180 calendar entries (well 181 &#8211; because of the &#8220;Slide0&#8221; one) ready and waiting to be picked up by IFTTT.<\/p>\n<p><em>Next page: How to\u00a0tie it all together with IFTTT&#8230;<\/em><br \/>\n<!--nextpage--><\/p>\n<h2>How to tie it all together with IFTTT<img decoding=\"async\" title=\"Next page...\" src=\"https:\/\/wobable.com\/wp-includes\/js\/tinymce\/plugins\/wordpress\/img\/trans.gif\" alt=\"\" \/><\/h2>\n<p>IFTTT have made it very easy to share their tasks as a &#8220;recipe&#8221;, so here is the recipe I cooked up for the Twitter avatar countdown:\u00a0<a href=\"http:\/\/ifttt.com\/recipes\/18882\">http:\/\/ifttt.com\/recipes\/18882<\/a>.<\/p>\n<p>Click on the link, then click &#8220;Use Recipe&#8221;. You will be prompted to join IFTTT (or sign in) and then you can see which channels are the &#8220;Missing Ingredients&#8221;. Assuming you are new to IFTTT, you will be prompted to authorise Google Calendar and Twitter, and then click &#8220;Create Task&#8221; .<\/p>\n<p>You should then see this in &#8220;Your Tasks&#8221;:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-354 aligncenter\" title=\"ifttt_Task\" src=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task.png\" alt=\"\" width=\"776\" height=\"157\" srcset=\"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task.png 970w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task-300x60.png 300w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task-150x30.png 150w, https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/ifttt_Task-400x80.png 400w\" sizes=\"auto, (max-width: 776px) 100vw, 776px\" \/><\/a><\/p>\n<p>That&#8217;s that then! You might want to check it works by waiting up until midnight on the first night, but I can assure you that (assuming you&#8217;ve followed my blog closely) it will work!<\/p>\n<p>One Twitter countdown to the Olympics, no problems!<\/p>\n<h2><a name=\"#Bonus\"><\/a>Added bonus! Schedule tweets using the same concept!<\/h2>\n<p>As an added bonus, especially now that CoTweet has bitten the dust, here is a recipe for scheduling tweets using the same concept:\u00a0<a href=\"http:\/\/ifttt.com\/recipes\/18890\">http:\/\/ifttt.com\/recipes\/18890<\/a>.<\/p>\n<p>Be aware that IFTTT will run the task within 15 minutes of the calendar start time &#8211; so it may not hit the moment exactly &#8211; but for most cases that should be fine.<\/p>\n<p>In many ways, this approach is more powerful than CoTweet&#8217;s scheduled posts &#8211; you can bulk upload them from a CSV file (beat that CoTweet!) and you can turn off all the scheduled tweets by turning the task off (the power button second from the left) &#8211; CoTweet only allows you turn them off one at a time.<\/p>\n<p>Why is being able to turn off all your scheduled tweets useful? Imagine you have lined up a load of happy jolly tweets to go out, and then there is a major earthquake somewhere in the world. 90% of twitter are discussing the earthquake, and there are your tweets promoting your product. At best you look naive or out of touch; at worst, heartless, crass and insensitive. When a crisis hits (either globally, or even just your brand or account), being able to cut the scheduled tweets in one single click is a very useful function to have!<\/p>\n<p>&nbsp;<\/p>\n<p>I hope you have found this useful. I used it for the <a href=\"https:\/\/twitter.com\/#!\/cyclesurrey\" target=\"_blank\">CycleSurrey Twitter account<\/a> that I run for work. If you have used it, drop me a comment and let me know &#8211; I&#8217;d love to see where it takes you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;Wouldn&#8217;t it be cool to run a Twitter countdown to the Olympics? We could change the profile image each day to show how many days there are left!!&#8221; That was my challenge. It took me a little while to work out, but I found a very elegant solution &#8211; which I hope will help you &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/wobable.com\/?p=320\"> <span class=\"screen-reader-text\">How to add a Countdown to your Twitter Profile Photo<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":339,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[98],"tags":[134,131,135,136,133,132,152,153],"class_list":["post-320","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-social-media","tag-avatar","tag-countdown","tag-cyclesurrey","tag-olympics","tag-picture","tag-profile","tag-social-media","tag-twitter"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p2c0fT-5a","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/wobable.com\/wp-content\/uploads\/2012\/01\/Countdown.gif","_links":{"self":[{"href":"https:\/\/wobable.com\/index.php?rest_route=\/wp\/v2\/posts\/320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wobable.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wobable.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wobable.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wobable.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=320"}],"version-history":[{"count":23,"href":"https:\/\/wobable.com\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":364,"href":"https:\/\/wobable.com\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions\/364"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wobable.com\/index.php?rest_route=\/wp\/v2\/media\/339"}],"wp:attachment":[{"href":"https:\/\/wobable.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wobable.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wobable.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}