There are plenty of paid services that will help you setup a Twitter archive while also offering twitter monitoring and social listening, but I am going to show you how to set up your own Twitter archive using Google Sheets, Google Calendar and Zapier.

With this method you will be able archive tweets from your Twitter account indefinitely.

Zapier also offers many other powerful integrations between Twitter and Google for expanded archiving of Twitter activity. You can keep a record of tweets from your competitor’s accounts, monitor tweets from a Twitter list or archive tweets from search terms and hash tags. However for this Zap we are just going to cover how to archive your own tweets.

To get started archiving your tweets you’ll need a free Zapier account, a Google Calendar and a fresh Google Sheet to use as your archive.

Archiving Tweets With Google Calendar

If you want to setup a historical record of tweets from your account in a calendar view then just use Zapier’s built in Google Calendar Zap. My only recommendation is that you create a new Google Calendar so you can easily turn on and off the tweets in your calendar view. I named mine “Twitter Archive”.

Screen Shot 2015-06-07 at 1.08.58 PM

In the Zap builder Select Twitter > My Tweet then Google Calendar > New Detailed Event

Screen Shot 2015-06-07 at 1.02.36 PM

Select your linked Twitter account

Screen Shot 2015-06-06 at 2.27.05 PM

Select your linked Google Calendar account

Screen Shot 2015-06-11 at 11.25.50 PM

Skip step 4.

In step 5 make sure to select “Twitter Archive” (or whatever you named your calendar).

Screen Shot 2015-06-07 at 1.11.31 PM

Zapier’s default settings auto-fill such that new tweets will be entered into your calendar as if they were calendar events, with the date that you tweeted as the start and end date of the event. Turn the Zap on and you are ready to go!

Records will be added to your Google Calendar within 15 minutes of sending your next Tweet. It will continue until you turn off the Zap.

Archiving Tweets With Google Sheets

This Zap will archive your tweets into Google Sheets and allow you to sort tweets by date, number of favorites and number of retweets. You can even graph your Tweets if you want to get that nerdy. I prefer this method because you can always transfer Google Sheets data into a Google Calendar.

Before you start you will want to add column titles for the tweet data you want to archive. Zapier will recognize these column titles when you are building the Zap.

For this example I chose to track the tweet text, how many retweets it received, how many favorites it received and when it was tweeted. Your Google Sheets column headers should look like this:

Screen Shot 2015-06-07 at 1.58.47 PM

Now head to the Zap builder and select Twitter > My Tweet on the left and Google Sheets > Create Spreadsheet Row on the right

Screen Shot 2015-06-06 at 2.23.53 PM

Select your linked Twitter account

Screen Shot 2015-06-06 at 2.27.05 PM

Select your linked Google Sheets account

Screen Shot 2015-06-06 at 2.26.11 PM

Skip step 4 regarding filters. We won’t use any filters here.

Step 5 is where you will select what tweet data to track and where to map it to the columns in Google Sheets.

Not sure which Twitter fields to pick? I have put together a special guide for you below.

Notice how the names of the columns from your Gogle Sheet show up as separate rows in Zapier

Screen Shot 2015-06-07 at 2.03.33 PM

Select “Insert Fields” on each row and select the corresponding Twitter field you want to track.

Now just turn on the Zap and you’re done!

Records will be added to the google sheet within 15 minutes of sending your next Tweet. It will continue until you turn the Zap off.

Here is what the records look like in the Google Sheet after Zapier imports them from my Twitter timeline (with some styling added to the column headers).

Screen Shot 2015-06-10 at 11.18.57 PM


BONUS: How to Pick the Right Twitter Field Data

Zapier does its best to make it easy for the common man to integrate with Twitter but there can be a learning curve.

For me it was understanding which Twitter fields corresponded to which information I wanted to track.

For instance, what exactly does “Retweeted Status Truncated” mean and why would I want to use it?

You may recognize this big scary list when you were clicking on “Insert Fields”.

Screen Shot 2015-06-11 at 10.39.52 PM

Not to worry. To help you understand what these fields mean I put together a guide of all the most important Twitter fields in Zapier in easy to understand terms.

Feel free to copy/paste the info from my Google Sheet or take a glance at the screenshot below.