Twitter is a great free tool to send, receive and share micro (small) messages (aka tweets) with other Twitter users. These tweets are limited to 280 characters (as of writing this post) and can include images and videos. Once you login to your Twitter account, it defaults to Home where you can see your timeline. This timeline shows all the tweets from the users that you follow on Twitter. These users can be people and/or organizations.
Your timeline can get long (would seem like infinite scrolling) if you follow many users and those users post at different times of the day. This means is that you have to be constantly checking Twitter to see what other users are tweeting about. For most people, this can be very time-consuming. No worries, there is a solution (a little applet) that can help.
Here is what you will need:
- Twitter Account (free)
- Google Account (free)
- IFTTT Account (free)
Here are the steps for IFTTT:
- Log in to IFTTT
- Click on New Applet
- Click on ‘+this’
- Click on the Twitter service
- Click on the trigger ‘New tweet by a specific user’
- Type the Twitter user name you want follow and click on ‘Create trigger’
- Click on ‘+that’
- Click on Google Sheets
- Click on ‘Add row to spreadsheet’
- Verify what information you want in the Google Spreadsheets rows, the Google Sheets location and then click ‘Create action’
- Verify applet information and then click on Finish.
Congratulations you have created an applet on IFTTT! Now, simply go to your Google Sheets and see the tweets being collected automatically!
But wait there is more! The tweets that you are collecting can be used to do many things such as:
- Easily search through the Twitter user’s tweets
- Determine when (day and time) the Twitter user is most active
- Determine the most words used by the Twitter user
Get Started on Google’s G Suite and get 20% off the first year on either G Suite Basic plan or G Suite Business plan by using thee promotion codes:
Basic Plan – C3VLCH3RJFVHAWU
Business Plan – AD4XQPHWAYFMEQW
- Don’t forget to link your Google account to the IFTTT account
- Google Sheets don’t count toward your Google account size limit
- Google Sheets have a limit of 2000 rows (by default) but more rows can be added
- Adhere to all rules and regulations pertaining to Twitter, Google, and IFTTT
You must be logged in to post a comment.