Skip main navigation

Using a Twitter Data Harvester in Google Sheets

Watch Dr. Mathei's tutorial on how to use a Google Sheet to manipulate data using TAGS.

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.

This article is from the free online

Digital Media Analytics: Introduction

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now