Find out How to Save Tweets for any Twitter Hashtag

Anyone who has been using Twitter for long would have thought about getting an “Export” button to save your searches. More often than not, you find yourself searching Twitter for a trending hashtag or one of your older tweets. It would be very beneficial if Twitter can save all matching tweets to a Google spreadsheet. And if the spreadsheet could connect to the server and keep updating the search results frequently, it would be awesome, right?

Well, if you are entertaining any such hopes from Twitter, we would like to burst the bubble right now and say it’s never going to happen. However, no need to slip into despair yet, there is a work around for this problem. This will take no more than 5 minutes to implement, and once it is done, all your search results will be automatically saved into a Google spreadsheet and available any time you want. What is more, this spreadsheet keeps updating it with latest results and present you an up-to-date result at all times.

Twitter Hashtag

How to save your tweets in a spreadsheet?

This is where we are going to tell you about Twitter Archiver. This is a solution specially devised for people like you who would like their search results neatly listed in a spreadsheet, so that they don’t have to go through the same process every now and then. There are two versions of this software available- free and premium. Understandably, the premium version allows you better control and is more efficient. It allows multiple search results and hashtags in the same spreadsheet and update with the latest results more accurately.

In this article, we will provide you with information on using the free edition of Twitter Archiver.

Using the Twitter Archiver free edition

  1. Make sure you have a Google account. If not, create one and sign up for Google Drive.
  2. Now, you need to copy the Twitter Archiver in to your Google Drive. While saving the spreadsheet, use the respective hashtag or search phase.
  3. Go to twitter.com  and create a new app. In the Callback URL field, put https://spreadsheets.google.com/macros and save your changes. Select the API Keys tab and make a note of the Twitter Consumer Key and Secret.
  4. Open your script editor by selecting Tools from Google sheet. We are not calling in for any script writing skills here. All you need to do is copy paste the secret and key in the editor. After that is done, select Initialize from the Run menu and allow required permissions.

And you are good to go. From then on, any related tweets will be copied automatically to your Google spreadsheet and the same will be kept updated every few minutes or so. Other than tweets, the Twitter Archiver allows you to keep a track of the retweets and favorite counts as well. You can disable the Twitter Archiver anytime you want by going to the Script Editor and choosing stop from the Run menu. The spreadsheet can be converted to PDF, CSV or even as a webpage anytime you want.

Leave a Reply

Your email address will not be published. Required fields are marked *