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.
More from Reviews
Helping The Homeless? This Startup Has An App For That
Samaritan wants to connect the homeless with the people who usually walk by them without stopping, offering a chance to …
Sixt Aims To Revolutionize Urban Mobility With Its New App
SIXT – the car rental company – has launched a new mobility app that lets you rent a car, hail …
This Social Experiment Charges You 1 Cent For Every Character You Type
What would happen if you had to pay for each character you wrote in an online chat? A social experiment …
