This tutorial will teach you to import your tweets into Google Calendar using a csv file. By doing that and combining it with an IFTTT schedule, you can schedule thousands of tweets to be posted at specified dates and times as a complement to your social media strategy.
Google Calendar contains events. The elements of the events can be turned into tweets.
- The Start Date for example is the date when the tweet will be posted.
- The location of the event can be used to store a specific keyword that will be the trigger of the tweet.
- The title of the event can be the link to the post or picture to be attached to the tweet. It can also hold hashtags.
- The Event Description can be the tweet text.
In this post we will take it to the next level. If we already know how to schedule one tweet from a single event or even a series of tweets (recurring events) from the mentioned post, then how do we schedule a whole bunch? It’s not much of a time save if you, instead of writing tweets, create Google Events, is it?
Well, Google Calendar has this great feature of importing a list of events from a CSV file.
So what is a CSV file? It is a Comma Separated Value File. in other words a spreadsheet that you can create in Excel of Google Sheets.
And because Excel or Google Sheets are so good in creating lists, we can actually create thousands of rows that we can import at one time.
So let’s start with the format. TheCSV file you create has to have a specific number of columns and they have to be names in a specific way.
The csv file format
The following columns have to exist in your CSV file
- Start Date
- Start Time
- End Date
- End Time
Once you created your spreadsheet, start filling it with data. You can create your own IFTTT applet of use this IFTTT Applet …
… here is how it works.
The applet will post a tweet at “START TIME” of your event consisting of “DESCRIPTION” + a space + “TITLE”
The applet runs when an Event contains the keyword in the Location. My keyword is TweetONTextTweets.
Create your own keyword and make sure you add it to the applet in the keyword section when you activate it.
So, if your first row is like this:
Then your tweet would look like this:
And here is a screenshot of the actual tweet. As you can see, the hashtags are each on its own line, just like in the Excel Sheet
That is all. Just create an Excel file with all the tweets you want to schedule and import it in the Google Calendar.
Using Excel to prepare the list, you can create a random time schedule so that your posts are sent at random times to make them feel unscheduled. Also, you can schedule certain posts on Monday, with a Monday hashtag and so on. Because Excel is a very versatile program, the schedule can be built very creatively.
Importing to Google Calendar
To import to Google Calendar, there is a very simple procedure. Once your schedule is complete in excel or any other csv editor you may use, go to Google Calendar, click on Settings, and in the settings, go to Import & Export
Simply Select the file you want to import and click on the import button.
Done. Thousands of Tweets can be scheduled in seconds.
Experiment with a couple of lines in the csv before you import a year worth of tweets. Make sure everything works as intended.