How to download referenced images and videos of tweets

Recently I wanted to download a twitter stream. I didn’t want to write a specific program for it. After some research I found the following steps:

1. Load the tweets into a Google Sheet. This can be done using the Twitter Archiver plugin
2. Download the file to the desktop
3. Remove everything but the column “Media” and safe the file as a csv file
4. Remove the empty lines:

   sed -i '/^$/d' file.csv

5. Let wget download the images/files
   

   wget -i file.csv