Skip to main content
Instapage

How to Save Tweets for any Twitter Hashtag


Wouldn’t it be nice if Twitter had an Export button? You search for something, maybe an #hashtag or your brand name, and all the matching tweets would get saved in a spreadsheet or another file format of your choice. And, better still, the archive would update itself as new matching tweets are posted on Twitter in the future.


Well, Twitter is unlikely to provide you an option to save search results directly but here’s a do-it-yourself solution that takes 5-minutes to implement (watch video) and it will save all matching tweets for your search term(s) in a Google Spreadsheet automatically.


The idea is simple. We’ll have a Google Spreadsheet that will talk to Twitter through a Google Script and will import all the search results into the sheet. It will make this connection to Twitter every few minutes and fetches all the new tweets that have been added to Twitter since the last check.


Archive Tweets Permanently


Save Tweets Forever in a Spreadsheet



  1. Click here to copy the Twitter Archiver sheet into your Google Drive. Set the name of the sheet as any hashtag or a search phrase. For instance, you could set the sheet name as #WorldCup2014 to save all the FIFA related tweets.

  2. Go to apps.twitter.com and create a new application. Put http://ift.tt/PDVGTM as the Callback URL and save your changes. Select the API Keys tab and make a note of the Twitter Consumer Key and Secret.

  3. Switch to your Google sheet and select Tools -> Script Editor. Don’t worry, you don’t have to write a single line of code here, just copy-paste the Twitter secret and key inside the editor. Now select the Run menu, choose Initialize and grant the necessary permissions.


That’s it. The tweets will now appear inside your Google Sheet. These are the first set of 100 tweets and new tweets will be automatically pulled and added into your sheet every few minutes.


In addition to tweets, the Twitter Archiver app also imports other data like the tweet’s retweet & favorite count and the tweeter’s friend & followers count. This data will help you filter out the spam or figure out the most influential tweets from the imported data.


The Twitter Archiver sheet will run in the background and monitor Twitter for new tweets. If you would like to stop the tracker, go to the Script Editor and choose Stop from the Run menu as shown in the screencast video.


Twitter Archiver – Video



Since the tweets are saved in a standard spreadsheet, you can easily export the search results in various formats including PDF, CSV or even publish your data set as an HTML web page (choose File -> Publish to Web inside Google Sheets). Advanced users may try this technique to create JSON or RSS Feeds from Twitter.




This story, How to Save Tweets for any Twitter Hashtag, was originally published at Digital Inspiration on 30/06/2014 under Twitter, Internet



from Digital Inspiration Technology Blog

Comments

Popular posts from this blog

How to Get SMS Alerts for Gmail via Twitter

How do you get SMS notifications on your mobile phone for important emails in your Gmail? Google doesn’t support text notifications for their email service but Twitter does. If we can figure out a way to connect our Twitter and Gmail accounts, the Gmail notifications can arrive as text on our mobile via Twitter. Let me explain:Twitter allows you to follow any @user via a simple SMS. They provide short codes for all countries (see list) and if you text FOLLOW to this shortcode following by the  username, any tweets from that user will arrive in your phone as text notifications. For instance, if you are in the US, you can tweet FOLLOW labnol to 40404 to get my tweets as text messages. Similarly, users in India can text FOLLOW labnol to 9248948837 to get the tweets via SMS.The short code service of Twitter can act as a Gmail SMS notifier. You create a new Twitter account, set the privacy to private and this account will send a tweet when you get a new email in Gmail. Follow this account …

Another SEO tool drops the word “SEO”

This guest post is by Majestic’s Marketing Director, Dixon Jones, who explains the reasons for their recent name change.
Majestic, the link intelligence database that many SEOs have come to use on a daily basis, has dropped the “SEO” from it’s brand and from its domain name, to become majestic.com. Since most people won’t have used Google’s site migration tool before, here’s what it looks like once you press the “go” button:

In actual fact – there’s a minor bug in the tool. The address change is to the https version of majestic.com (which GWT makes us register as a separate site) but that message incorrectly omits that. Fortunately, elsewhere in GWT its clear the omission is on Google’s side, not a typo from the SEO. It is most likely that the migration tool was developed before the need for Google to have separate verification codes for http and https versions of the site.
The hidden costs of a name change
There were a few “nay sayers” on Twitter upset that Majestic might be deserting it…

6 types of negative SEO to watch out for

The threat of negative SEO is remote but daunting. How easy is it to for a competitor to ruin your rankings, and how do you protect your site? But before we start, let’s make sure we’re clear on what negative SEO is, and what it definitely isn’t.Negative SEO is a set of activities aimed at lowering a competitor’s rankings in search results. These activities are more often off-page (e.g., building unnatural links to the site or scraping and reposting its content); but in some cases, they may also involve hacking the site and modifying its content.Negative SEO isn’t the most likely explanation for a sudden ranking drop. Before you decide someone may be deliberately hurting your rankings, factor out the more common reasons for ranking drops. You’ll find a comprehensive list here.Negative off-page SEOThis kind of negative SEO targets the site without internally interfering with it. Here are the most common shapes negative off-page SEO can take.Link farmsOne or two spammy links likely won’…