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.
Template
Directions
After making a copy of the template you will want to place your hashtag in cell F2.
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.
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.
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.
Caution
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”
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?
There is a Google Sheets Add-On to collect tweets, I am not sure if that would do what you’re looking for.