Using a Twitter Data Harvester in Google Sheets

We have already seen that data needs to be sorted, cleaned, and organised in such a way as to allow the analyst to interpret the outcomes. TAGS is a free Google Sheet template that lets you set up and run automated collections of search results from Twitter.

This tutorial will focus on how to use TAGS, a simple Twitter harvester built around Google Sheets, and it will show how simple and effective social media analysis can be. To get the most of out of this course and apply to your work, you’ll need to know some technology and statistics.

The tutorial shows you how to harvest any number of tweets (within reason, and with some limits that are significant in themselves) about a person, a topic, or a place.

Download TAGS and follow along in this tutorial.

• The tool will walk you from a simple question to a table of information from which you can run some correlations and t-tests, plus some smart charts.

• Try this on your Twitter account. Share your discoveries with the other learners. How did it work? Did you have any issues? What did you find?

Share your findings and help each other troubleshoot if necessary.