This data will help you filter out the spam Twitter users or easily surface tweets from the most influential users. In addition to tweets, the Twitter Archiver app will also import other data including the tweet’s retweet & favorite count, the tweeter’s friend & followers count and whether they are verified or not. After the initial set is pulled, the archiver will poll Twitter every hour and pull in the matching tweets that have been posted since the last run. It writes these tweets in a separate sheet inside the Google Spreadsheet. Internally, the sheet will connect to Twitter and pull in the historic tweets that match your search term(s). Now that you have created your Twitter search query, click “Start Tracking” button to initialize the Twitter Archiver. You can create rules that mention certain search terms, look for exact phrases, find tweets by #hashtags, tweets that particular Twitter users and so on. If you have every used the advanced search page on Twitter, this search rule screen will be very familiar. Once your Twitter account is authorized, go to the Twitter Archiver menu again and create a new Search Rule.

Allow the Google Sheet to access Twitter on your behalf - the app needs this permission to only fetch tweets and will never post anything to your Twitter account. Go to the Add-on menu, choose Twitter Archiver and select the Authorize menu. To get started, install the Twitter Archiver and it will create a new Google Spreadsheet. Save all kinds of tweets with the Twitter Archiver How to Save Tweets in a Google Spreadsheet You can use the tool to monitor tweets around any conference hashtag, learn what people are saying about your brand, track popular search terms, save tweets from any geographic location and more. Meet Twitter Archiver, the simplest tool for saving tweets, forever It is a Google add-on that takes 5-minutes to setup (watch video tutorial) and will easily capture all tweets that match particular search terms in a Google Spreadsheet automatically. And this archive would just update itself in the background as new tweets arrive. Wouldn’t it be nice if Twitter had an Export button? You search for a trending #hashtag, or an old tweet, or your brand name, and all the matching tweets get saved in an Excel or Google spreadsheet.

Download twitter archive