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 …

Instagram Story links get 15-25% swipe-through rates for brands, publishers

Instagram may arrived late as a traffic source for brands and publishers, but it’s already showing early signs of success, driving new visitors to their sites and even outperforming its parent company, Facebook.For years brands, publishers and other have tried to push people from the Facebook-owned photo-and-video-sharing app to their sites. Outside of ads and excepting a recent test with some retailers, Instagram didn’t offer much help to companies looking to use it to drive traffic. So they had to find workarounds. They put links in their Instagram bios. They scrawled short-code URLs onto their pictures. And they typed out links in their captions.Then last month Instagram finally introduced an official alternative to these hacky workarounds: the ability for verified profiles to insert links in their Instagram Stories.Almost a month after the launch, 15% to 25% of the people who see a link in an Instagram Story are swiping on it, according to a handful of brands and publishers that h…

Crimson Hexagon Now Offers Access To Tumblr Firehose

Analytics provider Crimson Hexagon announced today that it has joined Tumblr’s Preferred Data Partners program, and now can offer customers access to insights about Tumblr’s full firehose of public activity.Boston-based Crimson Hexagon provides analytics for brands and agencies, analyzing consumer behavior on Twitter, Facebook, Instagram, Sino Weibo, Google+, YouTube, blogs, forums, review sites and other online platforms. The Tumblr integration offers Tumblr data for all public posts since October 2014 and will enable customers to track brand mentions and logos, measure conversation volumes and analyze sentiment drivers on Yahoo’s network.Crimson Hexagon has given several clients beta access to Tumblr data since the beginning of the year; among them is marketing agency VML, which has been pleased with the results.“By using Crimson Hexagon’s Tumblr data, we have expanded our view of online conversation, which allows us to discover new communities of brand-loyal customers for our clien…