Digital Inspiration has made a neat Google Sheets app that imports tweets with a particular search term or hashtag.
The tweets are fetched and updated automatically, for free.
You will need to make a copy of theTwitter Archiversheet in your Google Drive to start.
Agree to the rules and click “Create your Twitter system.”
go for the API Keys tab and make a note of the Twitter Consumer Key and Secret.
Copy-paste the Twitter secret and key inside the editor.
opt for Run menu, choose Initialize and grant the necessary permissions.
Your spreadsheet will import the first 100 tweets, and update with more as they come in.
The sheet can be sorted by any of those elements.
How to Save Tweets for any Twitter Hashtag| Digital Inspiration
