Add Specific Tweets in your Google Sheets.

Presentation

You are a student, a teacher, a marketing expert or you just want to get some informations about a specific topic ? You think that Twitter is a huge plateforme where you can find some usefull information. However, it is not always easy to find what we are looking for on this social media...

I have the solution for you !

By following the next instructions, you will be able to add tweets about a specific topic directly into your google spreadsheets. Isn't it great ?

How does it work ?

Each time that a new tweet contains the words that you will have chosen, a new row will be creating in your google Spreadsheets. You can choose the tweet's caracteritics that will appear : text, username ... That way, we you will able to read what the Tweeter community think about a topic.

Before :

After :

Zappier

To beggin with, you will need Zappier which is a web device that provides some APIs and connect them together. Those APIs are going to be verry usefull since they allow access to some fonctionalities of some applications. Therefore, we are going to use an API linked to Twitter and an other one linked to Google Spreadsheets.

Steps and Tutorial

After creating a spreadsheets where you want to collect the relevant tweets follow this steps on Zappier :

  1. Create a Zipper account
  2. Click on "Make a Zap"
  3. Select the API of Twitter
  4. Select "Search Mention"
  5. Add the mentions that you want in the tweets
  6. Add your Twitter account
  7. Click on "Continue"
  8. Click on "test trigger"
  9. Click on "Continue"
  10. Select the API of Google Sheets
  11. Select "Create a Spreadsheets Row"
  12. Click on "Continue"
  13. Add you Google account
  14. Select "My google drive"
  15. Select the Spreadsheets where you want to add the tweets
  16. Select the Page of your Spreadsheets where you want to add the tweets
  17. Select which information about the tweet you want to add : text, username,...
  18. Click on "Continue"
  19. Click on "Test and Continue"
  20. Click on "Turn on Zap"

And now here is a little tutoriel :

Resources

You will find some more information about the process on this page using Zapier or IFTTT. Or you may want to use another plateform like automate.io.

I have to admit, I am not the first person to get the idea of connecting Twitter to Google Sheet. Some people have already thought about this, like Corentin Robert who use it to follow the corona virus evolution.

Finally, you can check how to do the reverse process : tweet from googlesheet.