TAGS is a free Google Sheet template which allows you to set up and run automated collections of search results from Twitter. Follow the instructions for a basic setup of TAGS so you can begin scraping tweets.
To begin, click on TAGS (New Sheets).
You’ll now see the TAGS v6.0 template built on Google Sheets.
Click File —> Make a copy… and save it to your Drive. Your new copy should open in a new tab. Once you’ve created your own copy, click Enable custom menu in the Instructions area and click Continue to authorize.
You will be prompted to select the Google account of your choice.
Next, click Accept to allow the TAGS v6.0 Client to access your Google account.
You can now enter a search term. For this example, I’m using #fracking. If necessary, set the Advanced Settings. Twitter only allows tweets from the last 7 days to be scraped.
Click Tools —> Script editor. Once on the Script editor, click Run —> getTweets
Return to the front end of the Google Sheet, which should now be showing data in the Stats category.
Return to the front end of the Google Sheet by clicking the Readme/Settings tab. Click TAGSExplorer to publish the data on the web and view a visualization.
Return to the Readme/Settings tab and click TAGS Archive to publish the data to the web and create a searchable archive of the data.