HOW TO BE ALWAYS AWARE OF WHAT HAPPENED IN SPORT ?

Everything is available on this website for instance

What is the project?

The principle of this API aims at offerering a solution for a need that is expressed by a lot of people around me. A lot of people (young student who have a lot of course and would like to see friends the evening or middle-aged people who are working all-day-long and have to carry about children the evening) find it hard to know exactly what happens when it comes to speaking about a field their like such as sport. Indeed, there are more and more informations and it´s not easy to follow everything. But you are quickly lost when you miss some results, some breaking news, some transfers... At a time when information is instantaneous, you can not see everything.

That is why I had an idea while reading this course on Brightspace. I am found of using the website ´Eursoport´ which is very exhaustive. But as I do not have enough time to read it, I imagined a solution that list every tweets of this website, that put them on Excel so that I can see all informations at the end of the day. Everytime a tweet is written, it appears on a sheet. I made the sane thing with SoFoot in order to miss zero informations and because I like football in particular. I think it is very pratical as you have all informations in one sheet. It´s more convenient than going on Tweeter and read the Tweets of this two sites or on the apps as there are many ads, many meaningful informations...


How does it work ?

Here is a screenshot of Eurosport´s Twitter page. We can see inforöations which are very useful in order to know what is happening in the sport´s world. I could have done the same scrrenshot with SoFoot but it is the same idea. It shows that Tweet are short and clear and that is what I looked for öy Excel.

And here is the final result. It´s pretty clear, exhautif and convenient. Everytime I go on this sheet, I read the news and when I read everything, I cancelled informations so that next time I only have inforöations I do not know. It does not appear on the screenshot but I also have access to the URL of the tweet and I know if it was tweeted by Eurosport or SoFoot.


You need to use data of Twitter in order to put them on Excel. We will use Zapier to connect APIs. We aim at combining APIs in order to facilitate our lives for something. So we´ll see :

How can it be done?



Step 1

  1. We go on Zapier and click on "Make a new zap"
  2. You choose to use API of Twitter
  3. Connect to your account
  4. Choose the trigger event you need so click on "User tweet"
  5. Put "@Eurosport_FR" and "@sofoot"
Step 2

  1. You choose to use API of Google Sheets
  2. Connect to your account
  3. Choose the trigger event you need so click on "Create Spreadsheet Row"
  4. Create a doc and choose it