Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Click Here to Tweet

Google Sheets: Click Here to Tweet

Twitter Google Sheets

I like to use a spreadsheet to tweet things. There is a formula you can use in a spreadsheet that allows you to click on a hyperlink and compose a tweet. You can create a list of questions for your Twitter chat. Using the spreadsheet allows you to more easily tweet out the questions. If you have some quotes that you like to tweet often you can create a list in a spreadsheet and simply click on the hyperlink to tweet out your quotes. Crowdsource information from people and then tweet out their contributions.


Click Here for the Click Here to Tweet Template


After making a copy of the template you will want to place your hashtag in cell F2.
place your hashtag

The Click to Tweet formula allows you to concatenate up to 5 columns. Probably you only need to use one or two columns. Delete the column headers in columns A to E. Replace them with the information you want to collect.
replace column headers

As information is placed into column A a link will show up in column G. This link to tweet will combine whatever information is in the first five columns of the row. The click to tweet formula will also automatically include the hashtag you put into F2. In a Google spreadsheet when you click on a hyperlink the link actually appears below the link. Click on the “Go to link” to launch the tweet.
Click to tweet

After clicking on the link a new tab is opened to send the tweet. Tip: Use Control W to close the tab to get back to the spreadsheet to tweet the next item on your spreadsheet.
Screen Shot 2015-03-30 at 7.20.54 PM


Symbols can mess up the click to tweet link. Avoid using the & or # symbols. If you need to use symbols in your tweet instead use the HEX code. For example use %23 instead of #. Use %26 instead of &.

Sample: Follow the hashtag %23coffeeEDU to find out more about these 1 hour unconference events.

2 thoughts on “Google Sheets: Click Here to Tweet

  1. Ok, Alice… This is so perfect for my principals wanting to host school chats… Now I need the “reverse”… For these principals, I would love a recipe that would fill in a second sheet to the workbook like a form… Each time the hashtag is used, a time/date stamp, the twitter handle, the tweet with hashtag, is recorded for Q1, Q2, etc… A way to accumulate PD for the teachers… sum of the number of tweets and amount of participation time… does that make sense?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.