I often find myself looking for past tweets and followers trying to find a specific link to a blog post or an image. Twitter itself is pretty useless for this task. There are several ways to download your data from Twitter, but I’ve found a new way using Zapier and Dropbox that doesn’t required coding and allows you to track other data besides tweets. At some point, I’ll index this data in Elasticsearch to make it really easy to find stuff. But for now, using a text editor’s Find in a consolidated text file works pretty well as an MVP. In the future, I’d like to do some analysis with my followers. I’m especially fascinated with bots and how spammers are making them more and more realistic (including pics, topical tweets, short profile bios, realistic number of followers/following).

Here’s how you can set up a Zap to automatically append Twitter (tweets, mentions, favorites, new followers) data to a simple text file:

  • Create a Zap with Twitter/My Tweet as the trigger and Dropbox/Append Text File as the action. The Append Text File action is key to this solution and allows you to continually add to the end of the file. I think it’s new within the last year or so. I had previously set up a Zap to store tweet information in a Google Spreadsheet but it forced me to set up the exact columns beforehand and was not easy to change.
Zapier triggers
  • Select and authenticate your Twitter and Dropbox accounts
  • Select the folder for your Dropbox files. I created a new folder called Twitter to store several files
  • Choose the fields to append to your file. I chose to use a multi-line format with record delimiters and field labels. I like this format because it is human-readable and will allow me to easily parse it in the future with a tool like AWK, even if the file becomes huge. To make it a little more readable, I added a literal “@” before any user name fields. Since I use the same file for tweets and mentions, I added a literal “type: mytweet” to help me separate that data.
Zapier tweet field mapping details
  • Create other Zaps to log mentions, new followers and favorites. Here is how I setup the file contents for the other files: mentions:
Zapier mentions field mapping details


Zapier favorites field mapping details

new followers:

Zapier followers field mapping details

If you don’t like this method, you can try downloading your Twitter archive, using scripting in a language like Python, or find an existing tool/service.