Reading all the tweets you are interested in seems like an impossible mission. There are just too many people to follow, hashtags to search, keywords to look for. But the cool guys at Digital Inspiration made a neat Google Sheets app that imports tweets to your Google Drive automatically.
Also Read: Learn How To Craft Better Tweets With Twitter Counter
The app imports tweets based on usernames, hashtags or keywords. The tweets are fetched and automatically saved in your Google Sheets. And the best news is that it will not cost you a dime, Digital Inspiration provides this app for free.
You will need to make a copy of the Twitter Archiver sheet in your Google Drive to start. Then change the sheet’s name (note: not the file name) to whatever your desired keyword or hashtag will be.
Next, you need to obtain some credentials from Twitter. For this, go to apps.twitter.com and fill in your name, a description and the Google Sheet’s link in the “Website” section. Agree to the rules and click “Create your Twitter application.” This next part might seem technical, but it’s easy copy-pasting, just follow the steps:
- Put https://spreadsheets.google.com/macros as the Callback URL and save your changes.
- Select the API Keys tab and make a note of the Twitter Consumer Key and Secret.
- Switch to your Google sheet and select Tools -> Script Editor.
- Copy-paste the Twitter secret and key inside the editor.
- Select the Run menu, choose Initialize and grant the necessary permissions.
And that was it, you are now ready. Your spreadsheet will import the first 100 tweets, and update with more as they come in. As you will see you also get the date and time for each tweet, retweets, favorites, the user who tweeted it, the number of people they follow, and their total followers. The sheet can be sorted by any of those elements.
Here is a video to help you understand Twitter Archiver and set it up:
Related Stories:
- 3 Freemium Twitter Analytics Tools [REVIEW]
- Twitter Wants To Help Keep Your Account Safe
- Shop Directly From Twitter With #AmazonCart
A version of this article was originally published on Life Hacker.
You might also like
More from Reviews
The New Fujifilm Instax Square SQ1 Brings Instagram To The Real World
Fujifilm is making shooting analog instant-film easy and highly pleasurable with the new Instax Square SQ1.
Photoshop Now Uses Advanced AI To Create A Mask Around Hair
Adobe has released the latest version of Photoshop which now uses AI and additional algorithms to handle complex selections like …
Netflix Party: An App To Watch With Friends
Netflix Party is a new way to watch Netflix together, without having to leave the comfort (and safety) of your …
Discover Hoop, The “Tinder For Snapchat”
Hoop is an app that works a lot like Tinder, using Snap Kit (Snapchat's developer tool kit) to help you …
Turn Tweets Into Instagram-Friendly Posts With Pikaso
Are you tired of seeing badly-cropped tweets in your Instagram feed? Pikaso has a solution! It turns Tweets into Instagram-friendly …
S’more Is A New Dating App That Is About “Something More” Than Physical Attraction
Are you looking for something more? Then this new dating app might be the one for you. S'More is launching …
Friended Is A New Social Network That Wants To Be Just That
There is a new kid on the block. Social networking platform Friended wants to offer just that: a place for …
Adobe Premiere’s ‘Auto Reframe’ Feature Optimizes Your Videos For Different Social Platforms
With Adobe Premiere Pro's new AI-powered Auto Reframe feature, you may never have to resize and crop a video for …