google sheets

Fluco Toolbox: Twitter Archiver

Welcome to Fluco Toolbox, a series of posts that showcases potential edtech tools for the Fluvanna County classroom. Each post will discuss the tool, the type of problems it can help solve, and how it can be used in the classroom. If you’re a Fluvanna County staff member and want to learn more about using the tool in your own classroom, please schedule to see your ITRT and we will develop professional development based on your needs. If you’ve stumbled upon this post and you’re not part of the district, no worries! Feel free to use the information provided to jumpstart your own research.

Have you ever wanted to create an archived collection of tweets on a trending topic? What about a conference? Love Tweetdeck, but hate scrolling down through all the images and GIFs? Or maybe you just love looking at tweet data.

Today’s Fluco Toolbox tool is: Twitter Archiver

First, the basics:

Name: Twitter Archiver
URL: Link here
Cost: FREE w/ Premium option ($29 yearly)
Problem this tool solves: Use this Google Sheets add-on to archive tweets on a trending topic or hashtag. Customize fetch rules to limit based on language, mentions, user, and more.

Twitter Archiver is a Google Sheets add-on that’s very handy to capture tweets based on a series of rules. It has both a free and premium side, each with their own pros and cons. This tool is a great way to capture Twitter updates when Tweetdeck isn’t the preferred option. Twitter Archiver removes the images and GIFs so that the tweet and links are the priority. Bonus: it works in the background even when the computer is off so the file is constantly being updated!

Before I jump into how to use the tool, I want to share a comparison of the free and premium versions. We all love free, and for most educators, this will be the best option. However, those who follow a lot of conference or popular educational hashtags may prefer the $29 per year premium option instead.

The free version allows the user to create one rule for fetching tweets. This rule can be edited and changed over time, allowing the user to pull different hashtags in as needed. Because of this, it is best for the user to have one Spreadsheet named Twitter Archiver. A new tab is created for each new rule, and old tabs can be deleted when no longer necessary. The free version fetches tweets every hour and is supposed to be limited to 100 tweets. However, my test run of this with a trending hashtag showed that it was able to pull in over 2k the first round, and over 300 the second time.

Upgrading to premium does cost $29 per year. With premium, new tweets are fetched every 15 minutes, allowing you to stay on top of the most recent tweets. It also does not limit to 100 per hour. Multiple rules can be created, which means that the user is not limited to using just one spreadsheet for Twitter Archiver. Finally, technical support is free for 60 days.

To begin using Twitter Archiver, use the link above to add the add-on to your Google Sheets. Open a new Sheets file, and name the file Twitter Archiver. In the ribbon at the top, go to “Add-ons” and select “Twitter Archiver”. The first time the add-on is used, you will be asked to authorize Google to connect to your Twitter account.

Follow the steps above again, this time selecting “Create Rule”.

twitterarchive3

Fill in the parameters for the rule. If you are only wanting hashtags, do not add the # symbol to your parameters.

twitterarchive4

Note: Mine is set to Manage, as I’d already created an original rule prior to this post. Your screen will look similar to mine.

Once the rule has been created, the Google Sheet will have a tab for a Log and a tab for the rule. As more rules are created (or the original updated), new tabs will be added.

twitterarchive5

The tab that houses all of the archived tweets looks like the image below. It is much easier to scroll through and read tweets on a topic without pictures, and with a more compressed look and feel. It is also easier to sort the tweet data, or search for keywords that appear over and over again.

twitterarchive6

That’s all there is to it! Don’t forget to manage and update the original file if you are a free user. I love the data this thing collects, but I’m a big dork for all that fun data stuff, too. I plan to use this in the future for conferences because I’m able to see more information at once. Happy tweeting!

Resources

G Suite Teacher Resource: Graphbook

There’s no easy template available for online graph paper that suited my needs for Minecraft designing and pixel art, so I created my own. Presenting Graphbook, a 15 pg workbook in Google Sheets for those who want to design on the go without paper or pencil.

Name: Graphbook
Creator: Rachel Moravec
Description: Graphbooks are online graphing pages created in Google Sheets. Graphbooks allow students to use for any assignment requiring graphing, without the need for physical paper. It was originally designed for use with Minecraft. Graphbook comes in 2 download options- Portrait and Landscape. Portrait books are set up to print nicely in a portrait layout, and landscape in a landscape layout. Each book has 15 pages. Duplicate and rename workbook tabs to add more pages. Each page has numbers running across the top and side for easier design. Pages are 28 x 36 and 36 x 28.

graphbook image.PNG