Collecting Twitter Data Using TAGS

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).
 
A screen shot of the TAGS page which prompts you to select either the New or Old version of Google Sheets.
 
 
You’ll now see the TAGS v6.0 template built on Google Sheets.
 
A screenshot of the TAGS template 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.
 
A screenshot of a copy of the TAGS Google Sheet that is saved in your Drive.
 
 
You will be prompted to select the Google account of your choice.
 
A screenshot of the prompt for selecting a Google account.
 
 
Next, click Accept to allow the TAGS v6.0 Client to access your Google account.
 
A screenshot of the terms that allow the program 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.
 
A screenshot of a search term entered in your copy of TAGS.
 
 
Click Tools —> Script editor. Once on the Script editor, click Run —> getTweets
 
A screenshot of the script editor.
 
 
Return to the front end of the Google Sheet, which should now be showing data in the Stats category.
 

Screen Shot 2015-02-24 at 12.55.17 PM
 
 
Click the Archive tab at the bottom to view the data.
 

A screenshot of the archive generated from scraping 3000 tweets with the #fracking hashtag.

A screenshot of the archive generated from scraping 3000 tweets with the #fracking hashtag.

 
 
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.
 
A screenshot of the visualization once published.
 
 
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.
 
A screenshot of the searchable archive generated from TAGS.